IZ08080: READING THE ALTERNATE SEVRER INFORMATION FROM CLIENT SQLDBDIR CAN FAIL WITH SQL10004

DB2 Version 9.5 Fix Pack 3b for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 1  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 following entries can be seen in the db2diag.log file:
  
  2007-06-13-09.11.05.513271+120 E7758C358          LEVEL: Warning
  (OS)
  PID     : 942172               TID  : 42496       PROC : java
  INSTANCE: pcwas601             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: pcwas601             NODE : 000
  FUNCTION: DB2 UDB, base sys utilities, sqleGetAlternateServer,
  probe:20
  RETCODE : ZRC=0xFFFFD8EC=-10004
  

Local fix

Problem summary

• READING THE ALTERNATE SEVRER INFORMATION FROM CLIENT SQLDBDIR
  CAN FAIL WITH SQL10004
  
  Users Affected
  DB2 systems using Alternate Server Feature
  Problem Description
  Reading the alternate server information can fail with the
  following message written to 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:
  Error during reading of alternate server information
  

Problem conclusion

• Problem first fixed in V9.5 FP1
  

Temporary fix

Comments

APAR Information

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

  IZ01702

• 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