ccmdb info

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


Feedback