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?
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.