JR28612: DB2 HANGS IF DB2AUDIG.LOG FILE EXISTS BUT CAN NOT OPEN.

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

• Db2 hangs if db2audig.log file exists but can not open.
  You may find below messages at db2diag.log.
  -----------------------
  2008-02-15-15.49.07.731000+540 I5078829H402 LEVEL: Error
  PID     : 1484            TID  : 7992      PROC : db2syscs.exe
  INSTANCE: UDB             NODE : 000       DB   : DB
  APPHDL  : 0-861                APPID: xxxx
  FUNCTION:DB2 UDB, bsu security, sqlex_write_log_record,probe:30
  RETCODE : ZRC=0x070F00CB=xxx=SQLO_FREV "File already exists."
  
  2008-02-15-15.49.07.856000+540 I5079233H393       LEVEL: Error
  PID     : 1484            TID  : 7992      PROC : db2syscs.exe
  INSTANCE: UDB             NODE : 000       DB   : DB
  APPHDL  : 0-861                APPID: xxxx
  MESSAGE : Audit error.  sqlcode is:
  DATA #1 : Hexdump, 4 bytes
  0x397253D0 : EEFB FFFF                                  ....
  -----------------------
  

Local fix

• N/A
  

Problem summary

• m/a
  

Problem conclusion

• Problem was first fixed in DB2 UDB Version 9 FixPack 5
  

Temporary fix

Comments

APAR Information

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

  JR28599

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

Fix information

• Fixed component name

  DB2 UDB ESE WIN

• Fixed component ID

  5765F4101

Applicable component levels

• R910 PSY

     UP