Subsystem Analyzer for DB2 for z/OSDatabase Management for DB2 for z/OS - Performance SuiteDatabase Management for DB2 for z/OS - SQL Performance SuiteDetector 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.