When the DATATYPE=STAN, UNLDOBJ=N, UNLDTEXT=D, COLLID=NULLID parameters are used in a Detector PDTBATCH job, what records will be unloaded?

Products

• Detector for DB2 for z/OS

Issue/Introduction

When the DATATYPE=STAN, UNLDOBJ=N, UNLDTEXT=D, COLLID=NULLID parameters are used
within a Detector for Db2 for z/OS (PDT) PDTBATCH job, what records will be unloaded?

Resolution

The records below are unloaded for Collection ID NULLID, when these parameters are used:

For the Standard Text Table:
DTXT (Dynamic Text) records are unloaded 

For the Standard Activity Table:
PKGS (Package Statement Totals)
STMT (Statement Records by Plan/Package)
DYNS (Plan Dynamic SQL Summary Display or Pgm Dynamic SQL Summary Display)
PGM  (Program by Plan) 
PKGE (Package/DBRM Summary Display) 
PKGP (Package/DBRM Plan Display)
PLAN (Planname Summary Display)