How to include USERID in object reporting
search cancel

How to include USERID in object reporting

book

Article ID: 143754

calendar_today

Updated On:

Products

Subsystem Analyzer for DB2 for z/OS Database Management for DB2 for z/OS - Performance Suite Database Management for DB2 for z/OS - SQL Performance Suite Detector for DB2 for z/OS

Issue/Introduction

Detector data are unloaded and loaded into DB2 tables for historical activity searches. Currently the OBJECT and STANDARD table data is aggregated but that aggregation ignores USERID. Can the userid be used?

Environment

Release : 20.0

Component : Detector for DB2 for z/OS

Resolution

Userid is not being ignored  when loading the tables. Userid is blank because this is collected only with the KEYS turn on when starting the collection. A lot of shops don't collect the KEYS because of overhead of collecting them.