What is the purpose of the Database Analyzer for Db2 EXPLODE Command in RTOS Extract

Products

• Database Analyzer 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

What is the purpose of EXPLODE Command in a Database Analyzer for Db2 for z/OS (PDA) RTOS Extract.

Resolution

For RTOS Extracts (MODE=A(ction)) the EXPlode command shows the objects that were selected in real time the last time the Extract was executed/previewed. The list will be "empty":

1) for a new RTOS Extract that has never been executed,

2) if the last RTOS Extract executed did not select any objects based on the selection criteria, or

3) if a fatal error happened after the DELETE of the definition rows but before the new INSERTs. ("empty" may mean there are place holder rows for DSNDB06.SYSEBCDC).