db2audit checking

[JS]

I have set up db2audit for checking on win2k v8 db, but when I extract
the records from the log and load them into the checking table, I
don't get the object name in objname colum. My understanding is that
this column should contain the table name for each insert, update,
delete or select statement.
Instead, I am seeing data that refers to the db name, the userid, a
tablespace name etc. Further, it seems as if the ACCESSAPP and
ACCESSATT column data is reversed, ACCESSAPP column showing hex number
for ACCESS ATTEMPTED and ACCESSATT column showing hex numbers for
ACCESS APPROVAL, unless there is some documentation error on IBM db2
V8 help site. The db2 v8 documentation site says that these two
columns should have the word insert, delete, drop etc, not the hex
code.
Can anybody shed any light on why I am not getting the objname for dml
type transactions in this table?
Thank you

[JS]

fy***@hotmail.com (JS) wrote in message news:<e9**************************@posting.google. com>...

I have set up db2audit for checking on win2k v8 db, but when I extract
the records from the log and load them into the checking table, I
don't get the object name in objname colum. My understanding is that
this column should contain the table name for each insert, update,
delete or select statement.
Instead, I am seeing data that refers to the db name, the userid, a
tablespace name etc. Further, it seems as if the ACCESSAPP and
ACCESSATT column data is reversed, ACCESSAPP column showing hex number
for ACCESS ATTEMPTED and ACCESSATT column showing hex numbers for
ACCESS APPROVAL, unless there is some documentation error on IBM db2
V8 help site. The db2 v8 documentation site says that these two
columns should have the word insert, delete, drop etc, not the hex
code.
Can anybody shed any light on why I am not getting the objname for dml
type transactions in this table?
Thank you

Follow up to my original post, the objname I am getting for the dml
statements from the extract is 'ALL_OBJECTS', anybody know what this
means? The only valid schema/table name I am getting is for the
checking table itself. Further, the mismatch of the approval
reason/access attempted can be fixed by simply reversing the column
position in the create table statement, I don't know if this is ithe
intended position or bug.