IFCIDS for Db2 z/OS Audit

WLX Audit for Db2 z/OS works solely with IBM Technology. It gathers all static & dynamic SQLs from EDM & DSC Caches by STC to OPx and efficiently uses IFCIDs 23, 24, 25, 62, 90, 91, 140, 141,142, 143, 144, 219, 220, 316, 318, 400, 401

There are hundreds of IFCIDs that you can start and use for Db2 z/OS Audit or performance monitoring. Some come  very cheaply like the 316, 317, 401 some are very CPU expensive like the 58 (SQL Full Trace). WorkLoadExpert (WLX) does not use the following IFCIDs for this very reason.


IFCIDS for Db2 z/OS Audit, we use and don’t use


WLX Audit for Db2 z/OS use the Following IFCIDS – CHEAP!


IFCIDs 23, 24, 25, 219, 220 : Utilities


IFCIDs 55, 83, 87 : Set Current SQLID, Identify and End of Signon


IFCIDs 62 : DDL


IFCIDs 90, 91, 140, 142, 143 : Commands and other Audit data


IFCID 141 : DCL


IFCIDs 144, 316, 318, 400, 401 : DML


IFCID 270 : Trusted context CREATE / ALTER


IFCID 271 : Column Mask/Row Permission – CREATE / DROP / ALTER


 


WorkLoadExpert (WLX) does not use the following IFCIDs – $ EXPENSIVE!


IFCID 58 : SQL Trace. Very expensive indeed!


IFCIDs 63, 350 : SQL statement text output by every PREPARE, BIND/REBIND and also very expensive


IFCID 97 : Drop of objects is covered by the 62 DDL IFCID


IFCID 107 : For every table open and close is very expensive and again can be easily got with the data already in the IFCIDs 316, 317 and 401


IFCID 145 : Audit SQL text. Is Available with the IFCIDs 316, 317, 401 and so this is not required


IFCID 247 : Host variables. Is very expensive and not required for Audit


IFCID 361 : Audit Administrative Authorities. Unless you are running with Audit Policy SYSADMIN or DBADMIN this IFCID outputs for *every* SELECT, INSERT etc. This is very high CPU and just dangerous in production. The data within can be captured using other means.