Maintenance Information command

Purpose

The dnimaintinfo command allows you to perform verification actions for maintenance purposes. Before issuing the command, run the profile dniprofile in the current shell and ensure that you have access to a Java runtime environment.

Required access rights:
  • User has to be a database administrator as described in Table 1
  • Write permission on file system to create log files
Predefined roles that provide required access rights: None

Format

Read syntax diagramSkip visual syntax diagram dnimaintinfo Action Options
Action
Read syntax diagramSkip visual syntax diagram -verify_jar-query_jvm_sp-help-?
Options
Read syntax diagramSkip visual syntax diagram  -dsn DNIvDSN  -schema DNIvSN  -uiduser_id -pwpassword -verbose

Parameters

-verify_jar (or -vja)
Use this parameter to verify if the JAR files used by Db2® stored procedures and Db2 user defined functions need migration. This is the default action.
-query_jvm_sp
Use this parameter to obtain information on the Java environment used by Db2 stored procedures and user defined functions provided by FTM SWIFT.
-help (or -h or -?)
Display a short overview of the command options.
-dsn data_source_name
Specifies information about the connection to Db2. Use one of the following notations:
  • Db2_database_name
  • //server:port/Db2_database_name
where:
Db2_database_name
The Db2 database name (for example, DNIDB)
server
The hostname or IP address of the Db2 server (for example, localhost)
port
The port of the Db2 server (for example, 50000)

If you do not specify this parameter, the first notation is used with the value of the environment variable DNI_DSN as Db2 database name.

-schema DNIvSN
Name of the schema to be used, for example, udb2adm1.
-uid user_id
The user ID of a Db2 administrator, for example, udb2adm1.
-pwd password
The password of the Db2 administrator.
-verbose
Optional parameter to increase the detail and number of the output messages.

Return codes

The dnimaintinfo command terminates with one of the following return codes:
Value Explanation
0 Successful processing.
4 No processing was done because an invalid parameter was specified or data in the database was not accessible.
8 Processing terminated because of an unexpected error.
12 Processing terminated due to a fatal error.

Example

The following command verifies the installed database routines:
dnimaintinfo -verify_jar -dsn MYDB -schema DNI -uid helen -pwd xxx