Can a query that is currently run through the PDA Query Facility be saved and executed in Batch?

book

Article ID: 53134

calendar_today

Updated On:

Products

CA RC Compare for DB2 for z/OS CA Database Analyzer for DB2 for z/OS CA Fast Unload for DB2 for z/OS CA Fast Check for DB2 for z/OS CA Fast Index for DB2 for z/OS CA Fast Load for DB2 for z/OS CA Rapid Reorg for DB2 for z/OS CA Distributed Database Management CA Database Analyzer for DB2 for Oracle CA Database Analyzer (IMS Tools) CA Mainframe Configuration Manager for IMS for z/OS IMS TOOLS - MISC CA Compress Data Compression (IMS Tools) CA Database Analyzer for IMS for z/OS CA Database Copier for IMS for z/OS CA Database Organizer for IMS for z/OS CA Mainframe Extended Terminal Manager (IMS Tools) CA High Performance Recovery for IMS for z/OS CA Database Organizer (IMS Tools) CA Mainframe Program Restart Manager for IMS for z/OS CA Secondary Index Builder for IMS for z/OS CA Secondary Index for IMS for z/OS

Issue/Introduction

Description:

Currently, Query Facility is being used to identify all tables that have increased number of rows over a period of time of over 10%.

This is done by selecting option "9) Query Facility" from the PDA main menu, then option "1) Tablespace / Table Queries" and then by selecting option 5 TABLE ROW ANALYSIS.

This can only process tables under 1 database at a time so we'll need to run this process several times to cover all tables within a subsystem.

Can the query be saved and run in batch?

Solution:

YES - To save and run the report in batch you would have to create a Report Procedure (PDA main menu option 8).

You would input the same report criteria as you did when you used the online Query Facility (opt 9).

For example, on the Build Report Procedures panel you would set the Report Type to T (Trend) and hit enter.

  • Locate the desired report on the left (RAQTB1 = report #5 Table Row Analysis).

  • If EQFs have been defined/created for the desired report than locate the appropriate EQF name in the EQF NAME column.
    If no user EQFs were created then the only one available will be the CA supplied named "STANDARD".
    In either case, you would select the appropriate EQF NAME by placing a 's' under the 'W' column for a Weekly report.
    Fill in the rest of fields as required like you did in Query Facility.

  • Save the report procedure.

The Report procedure can now be submitted for online or batch execution as a stand-alone procedure or as part of an Execution procedure. The Report procedure can also be referenced as the report associated with a PR utility code defined in an action procedure.

Please Note, a report procedure will include all objects in a DB2 subsystem (that have PDA stats of course) alternatively a "PR" utility code will only include the objects specified in the Extract Procedure.

Also note that there is additional information on Report Procedures and Query facility in the PDA User Guide and Reference Guide.

Environment

Release:
Component: DBA