IDB2 PTF LU03286 PROFILE-EXCEPTIONS RECORD ENHANCEMENTS

Products

• SYSVIEW Performance Management Option for DB2 for z/OS
• Database Management for DB2 for z/OS - Administration Suite
• Database Management for DB2 for z/OS - Performance Suite
• Database Management for DB2 for z/OS - Recovery Suite
• Database Management for DB2 for z/OS - SQL Performance Suite
• Database Management for DB2 for z/OS - Utilities Suite

Issue/Introduction

Is there any additional overhead that can be incurred with the rollout of PTF LU03286 PROFILE-EXCEPTIONS RECORD ENHANCEMENTS, PROFILE-MONITORING=YES/NO?

 

Environment

Release : 20.0

Component : SYSVIEW Performance Management Option for DB2 for z/OS

Resolution

The overhead in terms of CPU is negligible. The only thing to look out for is the stats history dataset. Turning PROFILE-MONITORING ON also turns gathering 402 records to history ON and that may influence the frequency at which you may want to do unloads(In case Time Of Day unloads instead of % used ones). No matter how many 402 records received, it will be negligible compared to the flow of accounting records. Lastly make sure to check HOLDDATA since a particular version of Db2 is needed to support this new sysparm.