DB2 - Problem description
Problem IC64952 | Status: Closed |
The "USERID" and "AUTHID" for all events in the AUDIT category are incorrect. | |
product: | |
DB2 FOR LUW / DB2FORLUW / 910 - DB2 | |
Problem description: | |
Problem Description: When using DB2 Audit facility, all events in the AUDIT category have the "USERID" and "AUTHID" recorded as the user ID of the instance owner regardless of the real user ID that called db2audit. For example, your instance owner was "DB2INST1" and you logged into the system using another account "USER1" and then issued some Audit administration commands like: -- db2audit configure -- db2audit start -- db2audit stop The audit facility will log the "USERID" and "AUTHID" which called those events as "DB2INST1" while the expected id is "USER1". | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * All users of version 9.1 on Linux, Unix and * * Windowsplatforms. * **************************************************************** * PROBLEM DESCRIPTION: * * When using DB2 Audit facility, all events in the * * AUDITcategory have the "USERID" and "AUTHID" recorded as the * * userID of the instance owner regardless of the real user ID * * thatcalled db2audit.For example, your instance owner was * * "DB2INST1" and youlogged into the system using another * * account "USER1" andthen issued some Audit administration * * commands like:-- db2audit configure-- db2audit start-- * * db2audit stopThe audit facility will log the "USERID" and * * "AUTHID" whichcalled those events as "DB2INST1" while the * * expected id is"USER1". * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 UDB Version 9.1 FixPak 9 or higher levels. * **************************************************************** | |
Local Fix: | |
available fix packs: | |
DB2 Version 9.1 Fix Pack 9 for Linux, UNIX and Windows | |
Solution | |
First fixed in DB2 UDB Version 9.1 FixPak 9. | |
Workaround | |
not known / see Local fix | |
BUG-Tracking | |
forerunner : APAR is sysrouted TO one or more of the following: IC65184 IC65185 IC72242 follow-up : | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 02.12.2009 26.04.2010 26.04.2010 |
Problem solved at the following versions (IBM BugInfos) | |
9.0., 9.1. | |
Problem solved according to the fixlist(s) of the following version(s) | |
9.1.0.9 |