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/OS CA SQL-Ease for DB2 for z/OS CA Sysview Performance Management Option 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