Option

dbutility Command

Description

?

Short help

-d

All

Full tracing

-f filename

All

Specifies the configuration filename.

-h

Long help

‑k

reload

Makes the command preserve the stateinfo of data sets that have a ds_mode of 2 and have not been reorganized.

‑m

All

Includes a 5-digit millisecond timer in all output messages.

-r

redefine

Toggles the setting of the parameter use_dbconfig, which determines whether the command uses user scripts.

-t mask

All

Log file and tracing options

-u

configure, define, redefine, generate and dropall

Unconditionally performs the requested command, overriding any warnings that would be displayed without this option

-w

clone or process

Toggles the setting of the use_dbwait parameter.

-x

clone

Clones all active data sets except those specified at the command line

-y

process

Instructs the client to reclone all data sets whose ds_mode has a value of 11 or 12.

-z

clone or process

Instructs dbutility to not update the relational database during a clone or process command.

This option is useful in determining how much non-database time is required to extract data for a data set.

-A

clone or process

Prevents the DATABridge Client from dropping a table during a clone (the DATABridge Client drops only the index).

‑B

display

Causes the display command to quit after displaying the DATASETS client control table records.

-D database

Specifies the name that identifies the Oracle instance or the Net8 service that is being accessed. (Depreciated in DATABridge 6.0 and later for the Microsoft SQL Server client.)

-F afn

process

Use this option make the client act as if a QUIT AFTER afn command had been executed. It applies to process and clone commands only. The range of values allowed are 1-9999.

‑K

process

Prevents the audit file removal WFL from being run on the mainframe after the Engine finishes processing an audit file.

-L

All

Forces the Client to start using a new log file.

-O ODBCdatasource

All

Specifies the ODBC data source to connect to (SQL Server, DB2, and Informix clients only).

-P password

All

Sets the password associated with the user ID for the relational database. The password is limited to 30 characters.

‑R

redefine

Forces all data sets to be redefined.

-T

All

Forces the program to create a new trace file when tracing is enabled.

-U userid

All

Specifies the user ID for the relational database. The user ID must have the appropriate resource privileges for the designated relational database.

-W

All

Specifies that the configuration parameter use_nt_authen should be set to True.

-X

define, redefine, clone, process

Specifies the host password.

-Z

clone or process

Forces the program to drop and create the tables of all recloned data sets, regardless of the use of the delete_record or expanded update_type columns.