How to report for a specific table within Subsystem Analyzer batch
search cancel

How to report for a specific table within Subsystem Analyzer batch

book

Article ID: 14828

calendar_today

Updated On:

Products

Subsystem Analyzer for DB2 for z/OS

Issue/Introduction

How to obtain a report for a specific table within Subsystem Analyzer for Db2 for z/OS (PSA).

Resolution

A report of table activity can be created using the PSABATCH member in your hlq.CDBAJCL library.

Make certain to place the name of the table to report on in the TABLE= parameter.
For example, the parameters below will generate a Database report on any table named SYSKEYS (eg. <creator>.SYSKEYS,etc):

REPORT=DB 
FORMAT=DETAIL
TABLE=SYSKEYS