The ccmdb info command reports or changes
the characteristics of a database.
Synopsis
ccmdb info database_path [-k|-keyword keyword [-v|-value value]]
Uses
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.
Note: The -k
size option functions only if you are logged on to the database
server.
Options and arguments
- 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:
accelerated | active | all | case
| database | dbpath | hostname | orhost | platform | protect | schema
| size | version
- accelerated displays the names of the accelerated
attributes in the database, including the user-defined attributes
and the built-in attributes.
- active shows whether users have sessions on the
specified database.
- all shows all keywords and their values.
- case displays information regarding the case
in which a file or directory created in or migrated to Rational® Synergy is stored.
- database is the name of the DBMS, which is always Informix®.
- dbpath is the full path to the db directory
of the database.
- hostname is the database server host.
- orhost is the host for the object registrar service.
If orhost does not exist, hostname is
used as the object registrar host.
- platform is the type of host on which the database
resides; for example, AIX®.
- protect shows whether a database is protected
or unprotected.
- schema displays the database schema version.
- size calculates and reports the size of the Informix database, the storage
root, and then the total, all in KB.
- version is the version of the database.
-v|-value value
Use
any one of the following keyword settings to change database information:[
attr_name | case | database | hostname | next_cvid ]
Note: For
each of these values, you must run as user ccm_root.
The value for the case keyword has significant
impact on your database:
- case displays information regarding the case
in which a file or directory created in or migrated to Rational Synergy are stored.
Enables
you to change a Rational Synergy
database between two modes: LOWER or PRESERVE.
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.
Note: Do
not change the case from
PRESERVE to
LOWER for
a database in which upper- or mixed-case objects have been created.
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 does not work correctly.
- database is the name of the DBMS, which is always Informix.
- hostname is the database server host.
- next_cvid sets the next cvid number
to the given value. The value passed must be greater than the maximum cvid currently
in use. You cannot adjust the next cvid counter downwards.
Examples
- Show the characteristics of the /vol/hydra/ccmdb/test_db database.
$ ccmdb info /vol/hydra/ccmdb/test_db
VERSION=7.2
PLATFORM=Solaris
DATABASE=informix
HOSTNAME=flash
ORHOST=flash
DBPATH=/vol/hydra/ccmdb/test_db
PROTECT=unprotected
ACTIVE=YES (database is active)
FILELIMIT=
CASE=PRESERVE
SCHEMA=0114
ACCELERATED=BUILT-IN:
member_status, created_in, local_to, modifiable_in, platform,
completed_in, crstatus, automatic_task_key, case_perserved_name
- In the database called /vol/tom/ccmdb/alpha,
set ORHOST to bill so that the database
can use an object registrar running on bill.
$
ccmdb info /vol/tom/ccmdb/alpha -k ORHOST -v bill
- In the database called /vol/tom/ccmdb/alpha,
change the case mode setting to PRESERVE.
$
ccmdb info /vol/tom/ccmdb/alpha -k case -v preserve
- Set the next cvid number for the basek2 database
to 10000.
$ ccmdb info -k next_cvid -v
10000 /orbit/ccmdb/basek2
Setting next cvid
to 10000 for database /orbit/ccmdb/basek2.