|
Problem IT27544
|
Status: Closed |
ONSHOWAUDIT DOESN'T REPORT EXPECTED DATABASE NAME FOR RDRW EVENTS
|
| product: |
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10 |
| Problem description: |
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 Summary: |
****************************************************************
* 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: |
|
| Solution |
|
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 26.12.2018
04.10.2019
04.10.2019 |
| Problem solved at the following versions (IBM BugInfos) |
12.10.xC12
|
| Problem solved according to the fixlist(s) of the following version(s) |
