Previous Topic: ca_dbmgr - Media Pool Management OptionsNext Topic: ca_dbmgr - Maintenance Options


ca_dbmgr - Database Management Options

The ca_dbmgr database management options allow you to query database information and set database options.

The ca_dbmgr command includes the following database management options:

ca_dbmgr [-cahost <host>] 
-tape delete <tapeID[:seqNo]
-prune on | off | set <count> days | months | year(s) <hh:mm>

-tape delete <tapeID[:seqNo]

Deletes a specified tape from the database.

-prune on | off | set <count> day(s) <hh:mm>

Sets database pruning on or off.

Specifies the elapsed number of days and the starting time for the pruning period. During the pruning process, all detail records older than the specified number of days will be removed from the database at the specified time every day.

For example, to specify that the pruning operation should remove all records older than seven days, and that the pruning should start at 5 PM every day, enter the following command:

ca_dbmgr -prune set 7 days 17:00

Note: Pruning removes detail records older than the specified number of days, but retains job and session records.

More information:

ca_dbmgr - Database Manager Command

ca_dbmgr - Examples