Database commands (db)

Database commands collect information about the database that Service Manager uses.

The timeout for Database commands is 60 seconds.

Note If you are running these commands with an Oracle database, you must create an OJDBC_LIB environment variable on the system and set its value to the Oracle driver path for the driver to be loaded successfully.

Option

Description

Usage

-version

Retrieves the database server version.

db -version

-info

Retrieves the server information:

SQL Server: collation

Oracle: characterset information; case-sensitivity information

DB2: DB configuration

db -info

-list

Retrieves the database (tablespace) list.

db -list

-timezone

Retrieves the database time zone and returns the time offset from the UTC/GMT time in hours.

db -timezone

-schema

Retrieves the table and index schema of the Service Manager database and outputs the information into an SM_schema.sql file.

Note This command works only with Oracle databases and requires that the sqlplus utility is installed on the system.

db -schema

-all

Runs all Database commands at one time and returns the results in the output.

db -all

-help

Displays Help information.

Note If the -help option is used together with other options, only Help information is returned.

db -help

-dlog

Outputs the command result to html and txt files.

db -all -dlog