PSSBLOAD utility

The DOMBRPT1 utility can produce reports or write the information to a data set in a format that you can load into Db2 tables.

As a complement, the PSSBLOAD utility can load performance data into three Db2 tables—METRICS, SQLTXT, and OBJECT_REF—with information from archived data sets for accounting metrics, object statistics, SQL errors, and SQL text along with the interval in which the statement was executed.

PSSBLOAD ensures that SQL queries can join the three tables on the text hash column. You can then run queries on the Db2 tables to solve problems such as

• Poor performance—You might want to know which SQL statements had the highest CPU in a given month, or which statement had the highest number of executions during a batch window.

• Audit database—You might want to know which users accessed a particular table, or which users violated Db2 authority.

• Impact Analysis—You might want to identify the programs, statement numbers, and SQL text that accessed a particular table.

Because PSSBLOAD extracts both dynamic and static SQL, the database can warehouse and expose SQL statements that are not stored in the catalog. PSSBLOAD formats the SQL text so that your queries will result in readable reports.

The PSSBLOAD utility provides sample queries, but you can customize your own SQL to meet the needs of your particular situation and to answer a variety of questions. For more information, see the sample queries contained in the PSSBQURY member of the hlq.llqSAMP data set.

Storing the performance data in Db2 tables allows you to:

• Keep data online and accessible for as long as you want

• Work with a more manageable set of data

• Easily customize queries so that they meet your needs

The PSSBLOAD utility extracts data from certain types of Apptune records and writes output data sets used for loading into the Db2 tables. The table titles are prefixed with a V vr_, in which V is a constant, v is the version number, and r is the release number. The following table describes these record types and the tables into which the output data sets are loaded.