APAR status
Closed as duplicate of another APAR.
Error description
db2 gets OS I/O messages in db2diag.log. No crashes or failures. DB2 function normally. Just these messages appear in db2diag.log from time to time when trying to attach to db2 instance. The entries in db2diag.log look like this: 2009-02-05-09.06.26.597549-300 E802279E500 LEVEL: Warning (OS) PID : 31700 TID : 183046802080PROC : db2agent (idle) 1 INSTANCE: db2inst1 NODE : 001 APPHDL : 1-1068 APPID: GAA34D89.H68E.047865140626 FUNCTION: DB2 UDB, oper system services, sqloflock, probe:100 MESSAGE : ZRC=0x860F0003=-2045837309=SQLO_DERR "disk error occurred (DOS)" DIA8402C A disk error has occurred. CALLED : OS, -, fcntl OSERR: EIO (5) The issue occurs when db2 tries to obtain a lock on a seed file .ftok The traces collected during the attachement will show multiple calls to sqloflock function within a loop trying to lock .ftok seed file. The seed file is getting locked with Shared Read only mode where it should have been locked as Shared Write mode and this causing OS I/O error.
Local fix
No Local Fix
Problem summary
Problem conclusion
Temporary fix
Comments
This APAR is a duplicate of IZ46871
APAR Information
APAR number
IZ46907
Reported component name
DB2 DPF
Reported component ID
5724N7400
Reported release
910
Status
CLOSED DUB
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2009-03-18
Closed date
2009-03-18
Last modified date
2009-11-16
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fix information
Applicable component levels
[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"910","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
16 November 2009