The ccmdb info command reports or modifies
the characteristics of the specified database.
Synopsis
ccmdb i|info database_path [/k|/keyword keyword] [/v|/value value]]
Uses
The user for this command
is the Rational® Synergy
administrator and any user. Any user can obtain information about
the database by using the keyword switch. However,
only the Rational Synergy
administrator can change the database information with the value switch.
Options and arguments
- database_path
- Specifies the database for which characteristics are being reported.
- /k|/keyword keyword
- Obtains database information. By default, all keyword database
information is shown. Keywords are not case-sensitive. Use any one
of the following keywords to designate the database information you
want to receive:
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 UNC 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, WINDOWS_XP.
- 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 kilobytes.
- version is the version of the database schema.
- /v|/value value
- You must use any one of the following keyword settings to change
database information:
[ attr_name | hostname | dbpath |
case | next_cvid]
Note: For each of these values, you
must run as the Rational Synergy
administrator.
- /k attr_name /v value
- Specifies attributes to be accelerated, in addition to the built-in
list of accelerated attributes. The built-in list of accelerated attributes
cannot be edited. Previously accelerated attributes not in the specified
list and not in the built-in list of accelerated attributes are removed
from the set of accelerated attributes.
By default, user-defined
and additional Rational Synergy
attributes are not accelerated.
- /k hostname /v value
- Enables you to change the hostname. Required if a machine name
is changed or a database is copied.
- /k dbpath /v value
- Enables you to change the database path. Required if the file
system or a shared name is changed.
The following two keyword settings
have special values that you must know.
- /k case /v value
- Enables you to change a Rational Synergy
database between two modes: LOWER or PRESERVE.
- The default LOWER mode causes file and directory
names to be stored in lower case. The PRESERVE mode
maintains the case preserving setting.
Attention: Do
not change
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 entry. Queries, scripts, and so on, containing upper-
or mixed-case objects do not work correctly.
- /k next_cvid /v value
- 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
- Set the ORHOST to bill so that
the database can use an object registrar that is running on bill.
>
ccmdb info \\orbit\ccmdb\test_ccm /k ORHOST /v bill
- In the database called \\bulldog\ccmdb\alpha,
change the case mode setting to PRESERVE.
>
ccmdb info \\bulldog\ccmdb\alpha /k case /v preserve
- Display the characteristics of the \\boon\ccmdb\test_db database.
> ccmdb info \\boon\ccmdb\test_db
VERSION=7.2
PLATFORM=WINDOWS
DATABASE=informix
HOSTNAME=vortex
ORHOST=vortex
DBPATH=\\boon\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
- 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.