ACCESS

Allows the ability to restrict access to a table, either from the database level or the area level.

ACCT

Provides options to edit an accounting database definition, catalog the definition to the Accounting Facility, and request an open, close, or spill of individual accounting tables.

BACKUP

Y

Outputs a sequential data set containing a backup of the area specified. The Directory (CXX), any specific data area, or all areas in a database can be backed up.

COMM

Communicates a specific request to the Multi-User Facility. Only the STATUS option can be executed in both Single User mode and Multi-User mode.

CONFIRM

Verifies that the data in a specific table adheres to SQL-defined integrity constraints.

CXXMAINT

Provides functions to maintain the Directory (CXX).

DBTEST

Executes one of the following test or analysis programs:

DBTSTPR

CA Datacom/DB Test Program. The DBTSTPR program can run in Single User mode if NO is specified for the MULTUSE= keyword.

DBIDCPR

Index Area Analysis Program

DBIDPPR

Index Area Population Analysis Program

DEFRAG

Defragments or compresses the DXX, that is, the "lowest" level of the IXX that contains key values and pointers to actual rows.

EDIT

Y

Validates the syntax and content of the DBUTLTY commands and associated keywords, without invoking the functions.

EXTBKUP

Reads a backup file and writes extract data to a sequential output data set(s).

EXTEND

Formats additional space to extend an Index Area (IXX) or data area.

EXTRACT

Y

Outputs a CA Datacom/DB table in expanded form to a sequential data set.

FILEIN

Allows you do one load with data from several backups.

FILEOUT

Used to define output data sets, for example to define one or more output data sets used by the EXTBKUP function.

FLEXPOOL

Adds or deletes dynamic data area or Index Area (IXX or DXX) buffers to the system.

INIT

Y

Formats the Directory (CXX), Log Area (LXX), Index Area (IXX), Force Area (FXX), or data area for use by CA Datacom/DB.

LINK

Links a data area or Index Area (IXX) to the Directory (CXX).

LOAD

Y

Reads data from a sequential or VSAM data set and loads this data into the specified area. LOAD only applies to a data area or the Directory (CXX).

LOCK

Locks a data area when you request a backup while the Multi-User Facility is updating the data area.

MASSADD

Reads a sequential or VSAM input data set and adds the records to a specified CA Datacom/DB table. MASSADD can run in Single User mode if NO is specified for the MULTUSE= keyword.

OLREORG

Reorganizes the database table without having to take it offline.

RECOVERY

Reprocesses maintenance transactions from a Recovery File (RXX) in either forward or backward mode. Forward recovery can be run in a Multi-User mode or in a Single User mode while the MUF is up, providing that the database is closed and not being used. Backward recovery must, however, be run in a Multi-User mode.

REMOVE

Deletes a key ID from the Index.

REORG

The parallel REORG function of the CA Datacom/DB Utility (DBUTLTY) provides a way for you to more quickly back up a large data area. By executing parallel tasks, the REORG function completes faster than a Native backup.

REPLACE

Provides the ability to load one table in a multiple table area with new data, replacing all current data for that table. It executes in the Multi-User Facility and allows full read and update access to every other table in the same area and database to other applications in the same Multi-User Facility.

REPORT

Prints one of the following reports:

• Directory (CXX) Report
• Summary Space Utilization Report
• Index Area (IXX) report
• Database History Report
• Log Area (LXX) Report
• Statistics and Diagnostics Area (PXX) Report
• Recovery File (RXX) Analysis Report
• Split File Analysis Report
• Data Area Space Estimation Report
• Utility Function History Report (TYPE=H)

RESET

Y

Resets the Log Area (LXX) as empty, or resets the Directory (CXX) exclusive control flags and sets database update and read controls to zero.

RETIX

Reads the area indicated (or all areas in a database) and rebuilds the data space index or the entire Index Area (IXX) information for that area based on the current data area information. You can also use the RETIX function to reset the Transaction Sequence Number (TSN).

RXXFIX

Y

Reconstructs log records being spilled to the Recovery File (RXX), if they had no End-of-File or trailer records as a result of an operating system or Multi-User Facility abend.

SECURITY

Clears cached permissions after making security changes.

SET

Allows you to establish how you want DBUTLTY to support error handling of functions within a specific execution. SET also allows debugging tools and tuning options to be specified.

SPILL

Moves transactions that can be spilled from the Log Area (LXX). We recommend you use the SPILLOPT function instead of the SPILL function (see the following). SPILL works the same as SPILLOPT SPILL=MAX.

SPILLOPT

Allows you to specify MAX or MIN when requesting a spill. Also allows the setting to allow update of a SPILL history table to record SPILL activity.

UNLOCK

Unlocks the data area you locked with the LOCK function and allows update access to the area.