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.

  • Perform the -verify_jar action to verify the current installation status of the JAR files used by Db2® stored procedures and Db2 user defined functions that are provided with FTM SWIFT.
  • Perform the -verify_ts action to verify the table spaces for usage of Db2 universal table spaces (UTS).
  • Perform the -verify_fin action to check if the Db2 performance statistics for the FIN tables must be updated.
  • Perform the -query_jvm_sp action to obtain information on the Java environment used by Db2 stored procedures and user defined functions provided by FTM SWIFT.
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-verify_ts-verify_fin-query_jvm_sp-help-?
Options
Read syntax diagramSkip visual syntax diagram  -dsn DNIvDSN  -schema DNIvSN  -uiduser_id -pwpassword -ssidsubsystem_id -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.
-verify_ts (or -vts)
Use this parameter to check if Db2 table spaces used by FTM SWIFT still need a migration to UTS.
-verify_fin (or -vfi)
Use this parameter to verify that the Db2 statistics for FIN tables are as expected. For more information about these statistics, see Administering database tables used by the SIPN FIN service.
-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_location_name
  • //server:port/Db2_location_name
where:
Db2_location_name
The Db2 location name (for example, DNIDB)
server
The hostname or IP address of the Db2 server (for example, localhost)
port
The port of the Db2 subsystem (for example, 50000)

Only the second notation allows to use passwords longer than 8 characters.

If you do not specify this parameter, the first notation is used with the value of the environment variable DNI_DSN as Db2 location 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.
-ssid subsystem_id
Use this optional parameter to specify a particular Db2 subsystem to be used. This has to be used if the default subsystem ID is different from the one used for the instance database.
-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
The following command verifies the table spaces in the FTM SWIFT database:
dnimaintinfo -verify_ts -dsn MYDB -schema DNI -uid admusr -pwd xxx
The following command checks if the Db2 FIN tables performance statistics need to be updated:
dnimaintinfo -verify_fin -dsn MYDB -schema DNI -uid admusr -pwd xxx