ccmdb info

The ccmdb info command shows the characteristics of a database and allows you to change them.

Synopsis

ccmdb info database_path [-k|-keyword keyword [-v|-value value]]

Uses

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.

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 indicates whether users have sessions on the specified database.
    Note: You must be user ccm_root to get information for the keyword active.
  • 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.
  • dbpath is the full path to the db directory of the database.
  • hostname is the database server host. This host is also the location from where the object registrar service runs.
  • 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, IBM-AIX.
  • protect shows whether a database is protected or unprotected.
  • schema displays the database schema version.
  • size calculates and reports the size of the database, the storage root, and then the total, all in KB.
  • version is the version of the database schema.
-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.
  • attr_name 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.

The case keyword values have 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. You can 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 do not work correctly.

  • database is the name of the DBMS.
  • 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


Feedback