To List Status for a Database Group

To view the status of a database group (caldb, sessdb, statdb), use the csdb utility list command.

To list database status:

1. Log in as a user who has administration rights to the system where Calendar Server is installed.

2. Calendar Server can be either running or stopped; however, if possible, stop Calendar Server.

3. Change to the /sbin directory. For example, on Solaris Operating Systems, enter:

   cd /opt/SUNWics5/cal/sbin

4. Run the list command against one or all of the database groups. For example, to list the status and statistics for all three database groups:

   ./csdb list

   The code that follows shows sample output:

   Sleepycat Software: Berkeley DB 4.1.25: (December 19, 2002) Calendar database version: 3.0.0 [BerkeleyDB] Total database size in bytes: 57344 Session database version: 1.0.0 [BerkeleyDB] Total database size in bytes: 0 Counter database version: 1.0.0 [Memory Mapped Files] Total database size in bytes: 118792

   Or, you can choose to use the verbose mode. For example:

   ./csdb -v list

   The following sample code shows the verbose output:

   Sleepycat Software: Berkeley DB 4.1.25: (December 19, 2002) Calendar database version: 3.0.0 [BerkeleyDB] Total database size in bytes: 57344 Total number of calendars: 2 Total number of events: 0 Total number of tasks: 0 Total number of alarms: 0 Total number of gse entries: 0 Total number of master component entries: 0 Total number of deletelog entries: 0 Total logfile size in bytes: 5779919 Session database version: 1.0.0 [BerkeleyDB] Total database size in bytes: 0 Total logfile size in bytes: 0 Counter database version: 1.0.0 [Memory Mapped Files] Total database size in bytes: 118792

   Or, use the -t option to specify one target database group (caldb, sessdb, or statdb). For example, to view database status and statistics for only the calendar database:

   csdb -t caldb list