To administer database files, use the Calendar Server utility csdb. This section contains topics:
The calendar database utility csdb treats the database files as three logical databases:
The caldb consists of all the .db files and the _db.*files found in the database directory. The following is the default location for the calendar database files (as well as the cld_cache and ldap_cache subdirectories):
/var/opt/SUNWics5/csdb
If you prefer, you can specify a different directory when running the Calendar Server configuration program (csconfigurator.sh). For information about the configuration program, refer to Chapter 3, Calendar Server Configuration Program (csconfigurator.sh)
The following table describes the calendar database (caldb) files:
Table 16–1 Calendar Server Database Files
File |
Description |
---|---|
ics50calprops.db |
Calendar properties for all calendars. Includes the calendar ID (calid), calendar name, Access Control List (ACL), and owner. |
ics50events.db |
Events for all calendars. |
ics50todos.db |
Todos (tasks) for all calendars. |
ics50alarms.db |
Alarms for all events and todos (tasks). |
ics50gse.db |
Queue of scheduling requests for the group scheduling engine (GSE). |
ics50journals.db |
Journals for calendars. Journals are not implemented in the current release. |
ics50caldb.conf |
Database version identifier. |
ics50recurring.db |
Recurring events. |
ics50deletelog.db |
Deleted events and todos (tasks). See also Chapter 18, Administering the Delete Log Database |
The session database consists of all files located in the following directories: /opt/SUNWics5/cal/lib/admin/session/ and /opt/SUNWics5/cal/lib/http/session/
The statistical database consists of all files found in the counter directory:
/opt/SUNWics5/cal/lib/counter/
The csdb utility -t option allows you to specify a target database:
-t caldb – calendar database
-t sessdb – session database
-t statdb – statistics database
If you do not include the -t option, csdb operates on all three databases, except for check and rebuild which operate only on the calendar database.