Sun Java System Calendar Server 6.3 Administration Guide

16.1 Using the csdb Utility to Manage Calendar Databases

To administer database files, use the Calendar Server utility csdb. This section contains topics:

16.1.1 Identifying the Three Logical Database Groups

The calendar database utility csdb treats the database files as three logical databases (groups):

16.1.1.1 Calendar Database Group (csdb)

The caldb database 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 2, Initial Runtime Configuration Program for Calendar Server 6.3 software (csconfigurator.sh)

The following table describes the various 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

16.1.1.2 Session Database Group (sessdb)

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/

16.1.1.3 Statistical Database Group (statdb)

The statistical database consists of all files found in the counter directory:

/opt/SUNWics5/cal/lib/counter/

16.1.2 Targeting Specific Database Groups with the csdb Utility

The csdb utility -t option allows you to specify a target database:

-t caldb

The calendar database group.

-t sessdb

The session database group.

-t statdb

The statistics database group.


Tip –

If you do not include the -t option, csdb operates on all three databases. Two commands, check and rebuild, operate only on the calendar database, caldb.