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

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 High Availability feature
  
  Problem  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
  
  Problem Summary:
  Use of Alternate server feature can corrupt the Db2 directory.
  

Problem conclusion

• First fixed in DB2 UDB Version 8 Fixpak 17
  

Temporary fix

Comments

APAR Information

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

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

  IZ12279 IZ12280

Fix information

• Fixed component name

  DB2 CEE AIX

• Fixed component ID

  5765F3000

Applicable component levels

• R820 PSY

     UP