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.

 

Cause

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

Environment

Release : 20.0

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

Resolution

Correcting the sort order of the input files proved corrective.