IBM Support

LI72283: DB2 PANICS WHEN EAGAIN (FILE SHARING VIOLATION) IS RECEIVED FROM SQLOSEEKWRITE64()

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Note that these symptoms are very similar to those of IY85772.
    .
    During high workload, DB2 UDB may sporadically receive the
    EAGAIN error from the operating system when writing data to
    disk. This typically happens due to filesystem contention
    related to tablespace container files. Under the current logic
    DB2 will panic, i.e. shut down the instance programmatically,
    as such a disk write problem is considered serious.
    .
    In reality, EAGAIN during disk write is often a non-serious
    intermittent problem. The purpose of this APAR is to add retry
    logic into DB2, so that every time we run into this scenario
    DB2 will try to recover, preventing the engine shutdown.
    .
    The problem may manifest itself by various symptoms. The key
    is to look for file sharing violations from sqloseekwrite64().
    .
    Example:
    .
    db2diag.log
    ===========
    2007-04-03-07.20.49.865314+240 I3381743G710       LEVEL: Error
    PID     : 12168                TID  : 3086034624  PROC : db2pcln
    INSTANCE: db2inst1             NODE : 000
    FUNCTION: DB2 UDB, os services, sqloseekwrite64, probe: 100
    MESSAGE : ZRC=0x870F0016=-2029060074=SQLO_SHAR "File sharing vio
              DIA8519C A file sharing violation has occurred
    .
    t12168.000
    ==========
    sqlbLogErr + 0x5e
    sqlbClnrAsyncWriteCompletion + 0x77c
    SQLO_LIO_HANDLE_DATA::sqloLioDeQueueNBlocks + 0xba
    sqloLioCollectNBlocks + 0x4a
    sqlbClnrCollectSomeAIO + 0x88
    sqlbClnrDispatchSomeAIO + 0xcc
    sqlbClnrWriteBatchIOList + 0x9b
    sqlbClnrWritePages + 0x8e
    sqlbClnrFindWork + 0x8cb
    sqlbClnrEntryPoint + 0x7b
    sqloCreateEDU + 0x28e
    

Local fix

  • Reduce the filesystem contention, if possible. For example, if
    the EAGAIN error occurs when writing into a tablespace
    container, add new containers to the tablespace and redestribute
    the tablespace data evenly across all the containers.
    

Problem summary

  • see APAR description
    

Problem conclusion

  • First fixed in DB2 UDB Version 9.1, FixPak 5
    

Temporary fix

  • see APAR description
    

Comments

APAR Information

  • APAR number

    LI72283

  • Reported component name

    DB2 UDE ESE LIN

  • Reported component ID

    5765F4104

  • Reported release

    910

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2007-04-19

  • Closed date

    2008-11-03

  • Last modified date

    2008-11-03

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

    LI72282

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

    LI73624

Modules/Macros

  • ENGN_SQO
    

Fix information

  • Fixed component name

    DB2 UDE ESE LIN

  • Fixed component ID

    5765F4104

Applicable component levels

  • R910 PSN

       UP

[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSEPGG","label":"DB2 for Linux- UNIX and Windows"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"910","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
16 October 2021