USERID & END_USER_ID columns are not having any data after PDTBATCH

Article Id: 102336
Status: Published
Updated On: 20-06-2018 00:31
Products:
CA Bind Analyzer for DB2 for z/OS , CA SQL-Ease for DB2 for z/OS , CA Sysview Performance Management Option for DB2 for z/OS , CA Database Detector for DB2 for z/OS , CA Plan Analyzer for DB2 for z/OS , CA Subsystem Analyzer for DB2 for z/OS
Issue/Introduction:

I ran PDTBATCH report to UNLOAD group level history data from Detector Datastore and loaded them to PDT_STATNDARD_180 and PDT_STANTEXT_180 table.
Both tables has columns USERID & END_USER_ID but they are not having any data there.  

I ran PDTBATCH report to UNLOAD group level history data from Detector Datastore and loaded them to PDT_STATNDARD_180 and PDT_STANTEXT_180 table.
Both tables has columns USERID & END_USER_ID but they are not having any data there.
Can you please check why USERID its not showing.
 

Environment:

z/os DB2

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