Missing records in INSIGHT.SUBSYSTEM_DAILY

Document ID : KB000015677
Last Modified Date : 14/02/2018
Show Technical Document Details
Introduction:

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

Question:

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
Answer:

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.