IZ26781: DB2 ALTERNATE SERVER FEATURE CAN CORRUPT DB DIRECTORY ENTRY ON CLIENT RUNNING JAVA DB2 APPS ON MULTIPROCESSOR MACHINES.

DB2 Version 9.5 Fix Pack 3b for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 2a for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 2  for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 4  for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 4a for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 6a for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 10 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 systems using Alternate Server Feature on multiprocessor
  clients
  Problem Description:
  DB2 Alternate server feature can corrupt DB Directory entry on
  client running
  Java Db2 applications on multiprocessor machines.
  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
  
  Problem Summary
  Possibility of Db directory corruption if using Alternate Server
  Feature.
  

Problem conclusion

• Problem first fixed in DB2 V9.5 FP2
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

  IZ12279

• 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

• R950 PSY

     UP