USERID & END_USER_ID columns are not having any data after PDTBATCH
Article ID: 102336
Updated On:
Products
CA Bind Analyzer for DB2 for z/OS
CA Detector
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.
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
CONN_TYPE
CONN_NAME
CORRID
LOCATION
USERID
END_USER_ID
TRANSACTION_ID
WORKSTATION_ID
Feedback
Yes
No
Powered by
