Use the ccmdb info command to report or change the characteristics of a database.
With no options, the ccmdb info command shows all database information except size.
Any user can obtain information about the database using the default (database_path with no options) or the -keyword option. However, you must be user ccm_root to run this command with the -value option.
database_path
Specifies the path to the database for which you are showing or changing information.
-k|-keyword keyword
Specifies the type of database information to show or change. Use any one of the following (not case-sensitive) keywords to designate the type of information:
active | all | case | database | dbpath | hostname | orhost | platform | protect | schema | size | version
-v|-value value
Use any one of the following keyword settings to change database information:
[case | database | hostname | next_cvid ]
The case keyword values have significant impact on your database:
The default mode is PRESERVE, which causes Rational Synergy to store the file and directory names in the case in which they were created. The LOWER mode causes file and directory names to be stored in lower case.
If a database contains objects with upper- or mixed-case names, changing case from PRESERVE to LOWER down cases all user input: queries, scripts, and so on containing upper- or mixed-case objects do not work correctly.
$ ccmdb info /vol/sargasso1/ccmdb/base71 VERSION=7.1 PLATFORM=aix710/800 HOSTNAME=sargasso ORHOST=sargasso DBPATH=/vol/sargasso1/ccmdb/base71/db DATABASE=oracle PROTECT=unprotected ACTIVE=NO (database is inactive) CASE=PRESERVE SIZE=20480 KBYTES SCHEMA=0111
$ ccmdb info /vol/tom/ccmdb/alpha -k ORHOST -v bill
$ ccmdb info /vol/tom/ccmdb/alpha -k case -v preserve
$ ccmdb info -k next_cvid -v 10000 /orbit/ccmdb/basek2 Setting next cvid to 10000 for database /orbit/ccmdb/basek2.