How can I attain a report for a specific Table?

book

Article ID: 14828

calendar_today

Updated On:

Products

CA Bind Analyzer for DB2 for z/OS CA Detector CA SQL-Ease for DB2 for z/OS CA Sysview Performance Management Option for DB2 for z/OS CA Database Detector for DB2 for z/OS CA Plan Analyzer for DB2 for z/OS CA Subsystem Analyzer for DB2 for z/OS

Issue/Introduction

This document states how to attain a report for a specific Table. 



How can I attain a report for a specific Table?

Environment

z/OS 1.11 and above.

Resolution

A report of Table activity can be created using the PSABATCH member in your <High.Level>.CDBASRC library. Make sure that you place the name of the Table that you're reporting on in the TABLE= parameter. For example, the parameters below will generate a Database report on any table named SYSKEYS (eg. SYSIBM.SYSKEYS, HAYGR01.SYSKEYS,etc):

REPORT=DB 

FORMAT=DETAIL 

TABLE=SYSKEYS