|
Problem IC80832
|
Status: Closed |
"UNRECOGNIZED OBJECT TYPE!" ERROR MESSAGE IN DB2DIAG.LOG WHEN AUDIT IS TURNED ON |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
When audit is turned on and the user issues a drop table, the
user might see the "Unrecognized object type!" error in
db2diag.log as below:
2011-12-26-02.44.23.236253-300 I2314012379E588 LEVEL: Error
PID : 11676 TID : 47262176635200PROC :
db2sysc 1
INSTANCE: DB2INST1 NODE : 001 DB : TESTDB
APPHDL : 1-28516 APPID:
12.345.678.901.23456.7890123456
AUTHID : DB2INST1
EDUID : 304517 EDUNAME: db2agent (TESTDB) 1
FUNCTION: DB2 UDB, trace services, sqlt_logerr_data (secondary
logging func, probe:0
MESSAGE : sqlr_obj_type_to_aud_type: Unrecognized object type!
DATA #1 : Hexdump, 1 bytes
0x00002AFC153ED590 : 00 |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* ALL *
****************************************************************
* PROBLEM DESCRIPTION: *
* "UNRECOGNIZED OBJECT TYPE!" ERROR MESSAGE IN DB2DIAG.LOG *
* WHEN *
* AUDIT IS TURNED ON *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 Version 9.7 Fix Pack 6 or higher. *
**************************************************************** |
| Local Fix: |
|
| available fix packs: |
DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
|
| Solution |
First fixed in DB2 Version 9.7 Fix Pack 6. |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 16.01.2012
11.06.2012
11.06.2012 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP6
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.6
|
 |
