DYNAMIC SQL REPORTING IN BATCH

Products

• Bind Analyzer for DB2 for z/OS
• SQL-Ease for DB2 for z/OS
• SYSVIEW Performance Management Option for DB2 for z/OS
• Plan Analyzer for DB2 for z/OS
• Subsystem Analyzer for DB2 for z/OS

Issue/Introduction

We collect dynamic sql and see it. But we need report it in Batch but can't figure out. We see these options for Batch reports: * SPECIFY THE REPORT TO GENERATE. VALID REPORTS ARE; PLAN, PROG, SQL, * EXCP, AND SQLE. Which one to choose?

Environment

Release:
Component: PDT

Resolution

REPORT Generates reports of the collected data. The following report types are valid: DYNT (Dynamic SQL Activity Report) EXCP (Exception SQL Report) KEYDYNT (Dynamic SQL Activity Report by Key) KEYPLAN (Plan Activity Report by Key) KEYPROG (Package/DBRM Activity Report by Key) PLAN (Plan Activity Report) PLANDYNT (Plan Dynamic SQL Activity Report) PROGDYNT (Program Dynamic SQL Activity Report) PROG (Package/DBRM Activity Report) SQL (SQL Statement Activity Report) SQLE (SQL Error Report)