Overview of System and SQL Performance batch utilities
The System and SQL Performance products provide the following batch utilities:
Utility name | Description | Where documented |
|---|---|---|
DOMBRPT1 | The DOMBRPT1 utility produces printed reports from a batch job. DOMBRPT1 can also produce data in a format suitable for use by the Db2 Load utility. | See the documentation appropriate to your product: |
DOMBLOD1 | The DOMBLOD1 utility takes the DB2LOAD data set written by DOMBRPT1 and creates the appropriate CREATE TABLE DDL and LOAD utility control statements for the table to be loaded. | |
PSSBLOAD | The PSSBLOAD utility loads performance data into three DB2 tables—METRICS, SQLTXT, and OBJECT_REF—with information from archived LOGSET log files for accounting metrics, object statistics, SQL errors, and SQL text along with the interval in which the statement was executed. | |
PSSMNTL | The PTF Maintenance Listing utility program extracts and reports PTF reference information for the components of the SQL Performance Solution. It can also be used for displaying PTF reference information for the shared components of the BMC System Performance Solution. | |
DOMBPLOG | The DOMBPLOG utility prints all entries from the specified report log. | |
DOMARCI | The DOMARCI utility is a program that you can use to format a new COPYDIR file. | |
DOMARCB | The DOMARCB utility removes entries from the copy directory based on criteria that is specified in the program’s control statements, and then consolidates the remaining entries, allowing active records to be retained for a longer period of time. | |
DOMBSWIT | The DOMBSWIT utility invokes the Data Collector SWITCH command from a batch job. | |
DOMCOPY | The DOMCOPY utility copies trace data from the logfile to an archive data set. | |
DOMUVCPY | The DOMUVCPY utility copies variable repository (DCC$VARS) entries from one repository to another. |
Comments
Log in or register to comment.