Missing records in INSIGHT.SUBSYSTEM_DAILY

book

Article ID: 15677

calendar_today

Updated On:

Products

CA Bind Analyzer for DB2 for z/OS CA Detector CA SQL-Ease for DB2 for z/OS CA Sysview Performance Management Option for DB2 for z/OS CA Database Detector for DB2 for z/OS CA Plan Analyzer for DB2 for z/OS CA Subsystem Analyzer for DB2 for z/OS

Issue/Introduction

Not all data is being loaded into the INSIGHT.xxxx tables.



I am working to take the DB2 SMF data, unload, and load it into the INSIGHT.xxxx tables. 

I’m getting missing records in the SUSBSYSTEM_DAILY table, compared to the SUBSYSTEM_DETAIL. With this sysplex, the SMF data should be present for five DB2 subsystems.

What could be causing this problem?

Environment

Z/OS DB2

Resolution

In the Insight Batch Report Writer (NSIGHTRW) parameter file (DD NAME SYSPARMS), code the following line: 

DBSUB=SSID 

Code "SSID" , do NOT substitute a specific DB2 Subsystem name.