Informix - Problembeschreibung
Problem IT27544 | Status: Geschlossen |
ONSHOWAUDIT DOESN'T REPORT EXPECTED DATABASE NAME FOR RDRW EVENTS | |
Produkt: | |
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10 | |
Problembeschreibung: | |
Consider the following SQL: database audit_test1; select a.id,a.desc,b.desc from audit_test1:aud_1 a, audit_test2:aud_2 b where a.id=b.id; In the particular instance where databases audit_test1 and audit_test2 are on the same server (so local to same instance), if each table had a single row that satistifed the join you would see the following results in an onshowaudit output: ONLN|2018-04-25 10:15:35.000|server|898195|ol_informix1210_7|user|0:RDRW:audit_t est1:100:1049187:257:: ONLN|2018-04-25 10:15:35.000|server|898195|ol_informix1210_7|user|0:RDRW:audit_t est1:100:1049140:257:: The database field in both records is audit_test1. So RDRW appears to be reporting the database the session is connected to for all tables accessed, rather then the database the table resides in. | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * Users of IDS prior to 12.10.xC12. * **************************************************************** * PROBLEM DESCRIPTION: * * onshowaudit does not report expected database name for RDRW * * events. * **************************************************************** * RECOMMENDATION: * **************************************************************** | |
Local-Fix: | |
Lösung | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 26.12.2018 04.10.2019 04.10.2019 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
12.10.xC12 | |
Problem behoben lt. FixList in der Version |