The IDB2 BTSTASM2 Report has incorrect values

Products

• Bind Analyzer for DB2 for z/OS
• SQL-Ease for DB2 for z/OS
• SYSVIEW Performance Management Option for DB2 for z/OS
• Plan Analyzer for DB2 for z/OS
• 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
• Insight Performance Monitor for DB2 UDB for z/OS

Issue/Introduction

Using multiple sorted SMF files as input to the IDB2 BTSTASM2 report several of the report fields have incorrect values.

 

Environment

Release : 20.0

Component : CA Insight Database Performance Monitor for DB for z/OS

Cause

The probable cause of the incorrect values was due to incorrect sort order of the SMF input files.

Resolution

Correcting the sort order of the input files proved corrective.