IZ53225: FSYNC() ERROR IN DB2DIAG.LOG WHEN BACKING UP TO TAPE DEVICE

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

• db2diag.log reports fsync() error, when a back up is done to a
  tape device The backup is successfull but the error is reported
  in the db2diag.log.
  
  db2diag.log snippet :
  
  2009-05-06-23.26.22.716588-300 E1622483A491       LEVEL: Severe
  (OS)
  PID     : 1368274              TID  : 17137       PROC : db2sysc
  INSTANCE: db2inst2             NODE : 000
  EDUID   : 17137                EDUNAME: db2med.15829.0 (DWPROD)
  FUNCTION: DB2 UDB, oper system services, sqloclose, probe:10
  CALLED  : OS, -, fsync
  OSERR   : EINVAL (22) "Invalid argument"
  DATA #1 : File handle, PD_TYPE_SQO_FILE_HDL, 8 bytes
  0x0700000062FFDC10 : 0000 00FE 0000 0080
  
  The error is pretty benign and does not affect the backup and
  can be ignored.
  

Local fix

Problem summary

• User Affected: Any backing up DB2 to a tape device
  Problem Description: An fsync error is recorded in the
  db2diag.log at the end of a backup to a tape device
  Problem summary: see above.
  

Problem conclusion

• Problem was first fixed in Version 9.5 FixPak 5
  

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:

  IC64038 IC68041

Fix information

• Fixed component name

  DB2 CEE AIX

• Fixed component ID

  5765F3000

Applicable component levels

• R950 PSN

     UP