IDB2 DDL, SMF extract and load members for SUBSYS_SQL_DETAIL_DYNAMIC &SUBSYS_SQL_DETAIL_STATIC

Products

• SYSVIEW Performance Management Option for DB2 for z/OS
• Database Management for DB2 for z/OS - Administration Suite
• Database Management for DB2 for z/OS - Performance Suite
• Database Management for DB2 for z/OS - Recovery Suite
• Database Management for DB2 for z/OS - SQL Performance Suite
• Database Management for DB2 for z/OS - Utilities Suite

Issue/Introduction

Please provide the DDL for the table definition and the SMF extract and load members. For SUBSYS_SQL_DETAIL_DYNAMIC, SUBSYS_SQL_DETAIL_STATIC, SUBSYS_SQL_DETAIL_DYNAMIC_ACCEL & SUBSYS_SQL_DETAIL_STATIC_ACCEL

Environment

Release : 20.0

Component : SYSVIEW Performance Management Option for DB2 for z/OS

Resolution

Check your HGHLVL.CDBASKL0

1-(ARCDDL) for the DDL of the 4 tables you mentioned.

2-ARCLQDSA LOAD statement for  SUBSYS_SQL_DETAIL_STATIC_ACCEL

3-ARCLQDS LOAD statement for SUBSYS_SQL_DETAIL_STATIC

4-ARCLQDD LOAD statement for SUBSYS_SQL_DETAIL_DYNAMIC

5-ARCLQDDA LOAD statement for SUBSYS_SQL_DETAIL_DYNAMIC_ACCEL