DB2 - Problem description
Problem IC76633 | Status: Closed |
DURING DB2 INSTANCE STARTUP THE DIAGPATH SETTING FOR DB2DIAG.LO G LOCATION IS NOT HONORED FOR a FIRST INFO MESSAGE from DB2SYSC | |
product: | |
DB2 FOR LUW / DB2FORLUW / 980 - DB2 | |
Problem description: | |
During DB2 instance startup procedure the DIAGPATH setting for db2diag.log locations is not honored for the first informational message from db2sysc. By means of APAR IC67948 the new functionality was added to the instance controller program to print informational message like: 2000-00-00-00.00.00.0000000-000 E2988A1291 LEVEL: Event PID : xxxxxxxx TID : 1 PROC : db2sysc INSTANCE: db2 NODE : 000 FUNCTION: DB2 UDB, base sys utilities, DB2main, probe:1 START : DB2 DBM DATA #1 : Build Level, 152 bytes Instance "db2" uses "64" bits and DB2 code release "SQL09018" with level identifier "02090107". Informational tokens are "DB2 v9.1.0.8", "s090823", "U823514", Fix Pack "8". DATA #2 : System Info, 224 bytes System: AIX test 3 5 00CCCAFC4C00 CPU: total:8 online:8 Threading degree per core:2 Physical Memory(MB): total:8192 free:394 Virtual Memory(MB): total:22528 free:10099 Swap Memory(MB): total:14336 free:9705 Kernel Params: msgMaxMessageSize:4194304 msgMaxQueueSize:4194304 shmMax:68719476736 shmMin:1 shmIDs:131072 shmSegments:68719476736 semIDs:131072 semNumPerID:65535 semOps:1024 semMaxVal:32767 semAdjustOnExit:16384 Cur cpu time limit (seconds) = 0x7FFFFFFFFFFFFFFF Cur file size limit (bytes) = 0x7FFFFFFFFFFFFFFF Cur data size (bytes) = 0x0000000008000000 Cur stack size (bytes) = 0x0000000010000000 Cur core size (bytes) = 0x000000003FFFFE00 Cur memory size (bytes) = 0x7FFFFFFFFFFFFFFF nofiles (descriptors) = 0x7FFFFFFFFFFFFFFF This APAR is addressing the issue that this informational message only goes to the db2diag.log file stored at the default location at $<INSTANCE_HOME>/sqllib/db2dump/db2diag.log even if the database manager DIAGPATH setting points to another location. | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * Unixes * **************************************************************** * PROBLEM DESCRIPTION: * * During DB2 instance startup procedure the DIAGPATH setting * * for * * db2diag.log locations is not honored for the first * * informational * * message from db2sysc. * * * * * * * * By means of APAR IC67948 the new functionality was added to * * the * * instance controller program to print informational message * * like: * * 2000-00-00-00.00.00.0000000-000 E2988A1291 LEVEL: * * Event * * * * * * PID : xxxxxxxx TID : 1 PROC : * * db2sysc * * * * * * INSTANCE: db2 NODE : 000 * * * * * * * * FUNCTION: DB2 UDB, base sys utilities, DB2main, probe:1 * * * * * * * * START : DB2 DBM * * * * * * * * DATA #1 : Build Level, 152 bytes * * * * * * * * Instance "db2" uses "64" bits and DB2 code release * * "SQL09018" * * * * * * with level identifier "02090107". * * * * * * * * Informational tokens are "DB2 v9.1.0.8", "s090823", * * "U823514", * * Fix Pack * * * * "8". * * * * * * * * DATA #2 : System Info, 224 bytes * * * * * * * * System: AIX test 3 5 00CCCAFC4C00 * * * * * * * * CPU: total:8 online:8 Threading degree per core:2 * * * * * * * * Physical Memory(MB): total:8192 free:394 * * * * * * * * Virtual Memory(MB): total:22528 free:10099 * * * * * * * * Swap Memory(MB): total:14336 free:9705 * * * * * * * * Kernel Params: msgMaxMessageSize:4194304 * * * * msgMaxQueueSize:4194304 * * * * shmMax:68719476736 shmMin:1 shmIDs:131072 * * * * * * * * shmSegments:68719476736 semIDs:131072 * * * * semNumPerID:65535 * * * * semOps:1024 semMaxVal:32767 * * * * semAdjustOnExit:16384 * * * * Cur cpu time limit (seconds) = 0x7FFFFFFFFFFFFFFF * * * * * * * * Cur file size limit (bytes) = 0x7FFFFFFFFFFFFFFF * * * * * * * * Cur data size (bytes) = 0x0000000008000000 * * * * * * * * Cur stack size (bytes) = 0x0000000010000000 * * * * Cur core size (bytes) = 0x000000003FFFFE00 * * * * * * * * Cur memory size (bytes) = 0x7FFFFFFFFFFFFFFF * * * * * * * * nofiles (descriptors) = 0x7FFFFFFFFFFFFFFF * * * * * * * * * * * * * * * * * * * * This APAR is addressing the issue that this informational * * * * message only goes to the db2diag.log file stored at the * * default * * location at $<INSTANCE_HOME>/sqllib/db2dump/db2diag.log * * even if * * the database manager DIAGPATH setting points to another * * * * location. * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 v9.8 Fixpack 4 * **************************************************************** | |
Local Fix: | |
n/a | |
available fix packs: | |
DB2 Version 9.8 Fix Pack 4 for AIX and Linux | |
Solution | |
First fixed in DB2 v9.8 Fixpack 4 | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 25.05.2011 01.08.2011 01.08.2011 |
Problem solved at the following versions (IBM BugInfos) | |
9.8.FP4 | |
Problem solved according to the fixlist(s) of the following version(s) | |
9.8.0.4 |