March 25, 2008

Q: How do I manage the size and disk usage of the Longitude database?

A: Longitude uses an open source SAP database, which is automatically created with 3 GB allocated on the drive you choose when you install Longitude. The database will auto-expand on that drive when it reaches either 80% full or less than 100MB free. You can manually extend it on the same drive, but that is rarely needed given Longitude’s self-maintaining features.

Do not gauge database consumption based on what Windows shows as the size of the \Longitude\sapdb\indep_data\wrk\FZEDB1\DATA0001 file. Even if Windows shows that file at 3 GB, the database is not necessarily nearing the full 3 GB allocated.

You can check the consumption by logging into the WebDbm:

http://localhost:7230/webdbm

u: dbm
p: {the password you specified for the original Longitude user during installation}

See the screen shot below.

Posted by Greg Savas, Technical Support Engineer