USERID & END_USER_ID columns are not having any data after PDTBATCH
book
Article ID: 102336
calendar_today
Updated On:
Products
CA Bind Analyzer for DB2 for z/OSCA DetectorCA SQL-Ease for DB2 for z/OSCA Sysview Performance Management Option for DB2 for z/OSCA Database Detector for DB2 for z/OSCA Plan Analyzer for DB2 for z/OSCA 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