Previous Topic: How to Use the Console CommandNext Topic: Example JCL


How to Use the DBUTLTY Command

The MUF must be active when you execute this command. Execute the COMM function with the following command format.

                       ┌───────────────┐
►►─ COMM OPTION=STATS ─▼─┬───────────┬─┴─┬──────────────────────┬─────────────►◄
                         └─ ,DBID=n ─┘   └─ ,IGN68= ─┬─ NO ◄ ─┬─┘
                                                     └─ YES ──┘

Command

COMM

Invokes the function to pass communication to the MUF.

Required Keyword

OPTION=STATS

Requests current statistics be written.

Optional Keywords

,DBID=n

DBID= is optional and may repeat. Each occurrence may specify one or more valid database IDs or a range of DBIDs nnnn-mmmm (a range, for example, such as 100-250).

If DBID= is not specified, all databases are processed.

Every database specified by a DBID keyword is processed. Each database that is not defined generates an error and fails the function after all the databases are processed, except that a database in a range not defined is ignored.

If you request STATS for a particular database and the database is virtual, a warning message is issued and no stats are written. If you request (by not specifying a DBID) that STATS be written for all databases, STATS are written for all non-virtual databases. If any databases are virtual, a warning message is issued.

Valid Entries:

One or more valid database IDs or a range of DBIDs as already described.

Default Value:

ALL

IGN68=

Specify IGN68=YES to ignore a return code 68. IGN68= is allowed for every ACCESS and COMM function. By ignoring return code 68, you can set up and run JCL that incorporates a stack of DBUTLTY functions without requiring that the MUF be enabled. IGN68= would therefore be useful, for example, if you wanted to load a database without first enabling the MUF, perhaps to allow restart to properly occur. Following is an example showing a stack of DBUTLTY functions that use IGN68=.

 ACCESS STATUS=UTLTY,DBID=997,USERS=WAIT,IGN68=YES
 COMM   OPTION=CLOSE,DBID=997,IGN68=YES
 INIT   AREA=IXX,DBID=997
 INIT   AREA=A01,DBID=997
 LOAD   AREA=A01,DBID=997,FORMAT=NONE,KBYTES=9999,SORT=1
 ACCESS STATUS=WRITE,DBID=997,IGN68=YES

Note: If the CXX is externally secured, the INIT and LOAD functions do not execute without the MUF being available, and IGN68=YES is therefore not recommended.

A function or functions specified with IGN68=YES generates message DB13001E to note that the function did not occur. Because no error was recognized, however, other functions in the stack continue to execute, and the DBUTLTY step ends without a recognizable error. Message DB13001E signals that the MUF was not enabled For details about DB13001E, see the CA Datacom/DB Message Reference Guide.

The DBSYSID macro parameter DELAY68= can be used to specify the number of minutes that the MUF connection can wait if the MUF is not currently available. But if IGN68=YES is specified, DELAY68= is ignored and the function continues. If the delay is desired, however, either do not specify IGN68=, in which case it defaults to NO, or specify IGN68=NO.

Valid Entries:

NO or YES

Default Value:

NO