_dsnutil() function

The _dsnutil() function invokes the NGTUTIL interface to the IBM DSNUTILB program to run a Db2 standalone utility.

Syntax

x = _dsnutil(<command>)

Related topic

General-built-in-functions 

The command parameter is a string that contains a valid Db2 standalone utility command. The format of the command is shown in the following example:

x = _dsnutil('  MODIFY RECOVERY TABLESPACE NWSALES.REGION33 DELETE AGE(*)')

Note the following requirements for the command parameter:

  • You must precede the command with two blank spaces.
  • Ensure that the characters in the Db2 statement are all uppercase.

Restrictions

Any product that invokes SORT, such as CHECK INDEX, will fail. (Because they do not invoke SORT, RUNSTATS and MODIFY will function properly.)

Values returned

The _dsnutil function returns one of the following values:


Value

Description

0

Successful operation

-3

Argument is not valid (for example, if the first two characters of the argument are not blanks)

Any other non-zero number

Return code from Db2, indicating the result of the Db2 operation

out.x

Output lines from the Db2 utility

Each line in the series of numbered variables (out.1, out.2, out.3, and so on) contains a line of output. The out.0 line contains the total number of output lines. For more information, contact BMC Customer Support.


 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*