Controlling and Monitoring dbutility

The DATABridge Client includes a command-line console to help control and monitor dbutility. Commands are entered in the same command prompt session as the dbutility commands. When dbutility is running, make sure that the focus is on the command prompt window and then use the keyboard to enter the command. You need to type only enough of the command to make it unique.

The configuration file parameter inhibit_console allows you to disable the console, and the command-line option ‑C toggles this parameter. The available commands are as follows:

This Command	Allows You To
co[mmit] a[bsn] <number>	Dynamically change the value of the parameter commit_absn_inc. The change only takes effect at the next commit. The allowable range of values is the same as that of the parameter commit_absn_inc.
co[mmit] ti[me] <number>	Dynamically change the value of the parameter commit_time_inc. The change only takes effect at the next commit. The allowable range of values is the same as that of the parameter commit_time_ inc.
co[mmit] tr[ans] <number>	Dynamically change the value of the parameter commit_txn_inc. The change only takes effect at the next commit. The allowable range of values is the same as that of the parameter commit_txn_ inc.
co[mmit] s[tats]	Displays the commit statistics.
co[mmit] u[pdate] <number>	Dynamically change the value of the parameter commit_update_inc. The change only takes effect at the next commit. The allowable range of values is the same as that of the parameter commit_update_ inc.
h[elp]	Displays a list of available commands.
l[ogswitch]	Close the current log file and start a new one.
p[stats]	Display the performance statistics. These statistics are the same as those shown after an audit file switch when the show_perf_stats configuration file parameter is set to True.
q[uit] [at hh:mm \| after afn]	Terminate the program at the next quiet point. Issuing this command during data extraction has no effect until the fixup phase starts. Optionally, you can specify either to terminate the program at a particular time or to terminate it after a particular audit file is processed.
q[uit] now	Terminate the program immediately by first closing the TCP/IP connection to the server. This command is particularly useful when using DBWAIT and there are no updates available. This command will not take effect immediately if the client is waiting for an SQL operation to complete.
sc[hed] {on \| off}	Disable or enable update scheduling. For instructions on scheduling updates, see Scheduling dbutility Updates.
ss[tats]	Display statistics for DATABridge Server (or DATABridge Enterprise Server) at the next quiet point.
st[atus]	Display a variety of status information, such as the current stateinfo during audit file processing, the trace status, and the program status (for example, waiting for TCP for 100 ms).
tr[ace] trace_mask	Dynamically alter the trace mask; for more information, see Enabling a Trace.
ts[witch]	Close the current trace file and starts a new one.
v[erbose] {on \| off}	Alter the setting of the verbose flag; see ‑v in dbutility Command-Line Options.