ccmdb info

This topic contains information about the ccmdb info command.

Synopsis

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

Description and 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:

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 ]

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:

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.

Examples


Feedback