The Performance Database tables holds history information about Db2 activity, and the sequential output dataset created by NTH can be used as the input to create LOAD files with data to populate most of the tables, but not all.
The problem is that is not possible to choose extra traces (IFCIDs) that we want to send to NTH. During NTH customization it is possible to choose which options we want to turn on or off, and this will result in a fixed list of IFCIDs being collected or not.
The following 2 Statistics tables are part of the Performance Database and are based on IFCIDs that are not collected by any NTH option:
- Aggregated Accounting Data table (DB2PM_STAT_AGGRACC) which is based on IFCID 369 (Statistics trace class 9)
- Storage Data table (DB2PM_STAT_STORAGE) which is based on IFCID 225 (Statistics trace class 6)
NTH sequential output file can't be used as a single point for collecting data to load the Performance Database.
|Who would benefit from this IDEA?||all Omegamon users|
How should it work?
NTH should be improved to allow the user to choose extra IFCIDs to be sent to sequential output file.
This will reduce the volume of data being sent to SMF datasets and NTH would be the single focus point for collecting data to Performance database. The value of NTH would be extended.
Now, in our process we need to use both NTH and SMF to get all data that we want to load all Performance Database tables.
|Customer Name||Dutch Tax Office|
NOTICE TO EU RESIDENTS: per EU Data Protection Policy, if you wish to remove your personal information from the IBM ideas portal, please login to the ideas portal using your previously registered information then change your email to "firstname.lastname@example.org" and first name to "anonymous" and last name to "anonymous". This will ensure that IBM will not send any emails to you about all idea submissions