DB2 - Problembeschreibung
Problem IC91213 | Status: Geschlossen |
Execute category audit logs contain incorrect event values when viewed in table format | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 | |
Problembeschreibung: | |
The EXECUTE Audit category, when the audit log is viewed, can contain multiple rows describing one event. The first record describes the main event, and its event column contains the key word STATEMENT. The remaining rows describe the parameter markers or host variables, one row per parameter, and their event column should contain the key word DATA, but instead also contain STATEMENT. For example, querying the table containing the audit data would return something similar to this: CATEGORY EVENT STMTVALINDEX STMTVALDATA STMTTEXT -------- ---------- ------------ ----------- ---------- EXECUTE STATEMENT - - SELECT ... EXECUTE STATEMENT 1 12 - EXECUTE STATEMENT 2 Kevin - EXECUTE STATEMENT 3 2011 - 4 record(s) selected. | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * All Audit facility users * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 v9.7 FP9 * **************************************************************** | |
Local-Fix: | |
verfügbare FixPacks: | |
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows | |
Lösung | |
Problem first fixed in DB2 9.7 FP9 | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Bug-Verfolgung | |
Vorgänger : APAR is sysrouted TO one or more of the following: IC96387 IC96425 Nachfolger : | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 01.04.2013 16.12.2013 16.12.2013 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
9.7.FP9 | |
Problem behoben lt. FixList in der Version | |
9.7.0.9 | |
9.7.0.9 |