Fixes are available
DB2 Version 9.1 Fix Pack 7 for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 5 for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 6 for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 6a for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 7a for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 8 for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 9 for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 10 for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 11 for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 12 for Linux, UNIX and Windows
APAR status
Closed as program error.
Error description
The high availabilty feature alternate server can lead to database directory corruption or duplicate entries on multiprocessor clients running java application accessing DB2. The problem may have symptons of duclicate DB directory entries, corrupted DB entries or missing DB entries. Errors similar to the following may also be seen in the db2diag.log : 2007-06-13-09.11.05.513271+120 E7758C358 LEVEL: Warning (OS) PID : 942172 TID : 42496 PROC : java INSTANCE: db2inst1 NODE : 000 FUNCTION: DB2 UDB, oper system services, sqlochgfileptr, probe:100 CALLED : OS, -, unspecified_system_function OSERR : EBADF (9) "A file descriptor does not refer to an open file." 2007-06-13-09.11.05.513751+120 I8117C272 LEVEL: Severe PID : 942172 TID : 42496 PROC : java INSTANCE: db2inst1 NODE : 000 FUNCTION: DB2 UDB, base sys utilities, sqleGetAlternateServer, probe:20 RETCODE : ZRC=0xFFFFD8EC=-10004
Local fix
Avoid using the alternate server feature
Problem summary
Users Affected : Db2 users using alternate server feature with Db2 java applications on multiprocessor clients. Problem Description: Db2 alternate server feature can corrupt db entry on client running Java Db2 applications on multiprocessor client machines. The problem may have symptons of duclicate DB directory entries, corrupted DB entries or missing DB entries. Errors similar to the following may also be seen in the db2diag.log : 2007-06-13-09.11.05.513271+120 E7758C358 LEVEL: Warning (OS) PID : 942172 TID : 42496 PROC : java INSTANCE: db2inst1 NODE : 000 FUNCTION: DB2 UDB, oper system services, sqlochgfileptr, probe:100 CALLED : OS, -, unspecified_system_function OSERR : EBADF (9) "A file descriptor does not refer to an open file." 2007-06-13-09.11.05.513751+120 I8117C272 LEVEL: Severe PID : 942172 TID : 42496 PROC : java INSTANCE: db2inst1 NODE : 000 FUNCTION: DB2 UDB, base sys utilities, sqleGetAlternateServer, probe:20 RETCODE : ZRC=0xFFFFD8EC=-10004 Problem Summary: Possible corruption of the DB directory entries when using the Alternate Server High Availability feature.
Problem conclusion
Problem first fixed in Db2 V9.1 FP5
Temporary fix
Comments
APAR Information
APAR number
IZ12279
Reported component name
DB2 CEE AIX
Reported component ID
5765F3000
Reported release
910
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2008-01-04
Closed date
2008-07-14
Last modified date
2008-07-14
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fix information
Fixed component name
DB2 CEE AIX
Fixed component ID
5765F3000
Applicable component levels
R910 PSY
UP
Document Information
Modified date:
14 July 2008