WHY IDB2 BTRCSASL REPORT IS NOT GENERATING OUTPUT
search cancel

WHY IDB2 BTRCSASL REPORT IS NOT GENERATING OUTPUT

book

Article ID: 206986

calendar_today

Updated On:

Products

Database Management for DB2 for z/OS - Performance Suite SYSVIEW Performance Management Option for DB2 for z/OS

Issue/Introduction

Why is BTRCSASL not generating output?  The SMF input file has 100/101/102 records

 

********************************* TOP OF DATA ***************
                                                             
<<<REQUEST BTRCSASL ENDED       1 LINES>>>                   
******************************** BOTTOM OF DATA *************

Environment

Release : 20.0

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

Resolution

BTRCSASL needs IFCID369 not 100/101/102 records. If this IFCID is not being collected, then you need to add ifcid 369 to the sysparms HIST-STATS-RECS. See the link below for more about BTRCSASL and IFCID369. 

https://techdocs.broadcom.com/us/en/ca-mainframe-software/database-management/ca-sysview-performance-management-option-for-db2/20-0/reference/batch-reports/statistics-batch-reports/btrcsasl-detailed-summary-of-accounting-statistics-aggregated-by-connection-type-report.html