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.
Host variables. Is very expensive and not required for Audit.
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.