USERID and END_USER_ID columns missing data after Detector for Db2 PDTBATCH execution

Products

• Detector for DB2 for z/OS

Issue/Introduction

Executed a Detector for Db2 for z/OS (PDT) PDTBATCH report to unload group level history data from the PDT datastore and load
the unloaded data to archive tables: PDT_STANDARD_180 and PDT_STANTEXT_180

Both tables have columns USERID and END_USER_ID defined but there is no data loaded to these columns.

Resolution

The following columns have meaning only when the UNLDKEYS=Y input parameter is specified and Additional Keys is enabled for the collection:

CONN_TYPE
CONN_NAME
CORRID
LOCATION
USERID
END_USER_ID
TRANSACTION_ID
WORKSTATION_ID