IBM Support

LI73042: CLIENT LOAD FAILS WITH SQL0980C "A DISK ERROR OCCURRED" CONNECTING TO REMOTE MULTINODE SYSTEM WITH NODES ON SAME BOX.

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • A client Load  might fail if loading to a remote (different box)
    Multinode System with Nodes on the same box with the
    following errors:
    
    SQL3109N  The utility is beginning to load data from file
    "/u/r1dw/andchur/db23c827/R1DW.EQTY_MKT_RISK_USD_05_07/000/NYTD_
    R1DW_HI".
    
    SQL3500W  The utility is beginning the "LOAD" phase at time
    "01/03/2008
    12:28:05.306016".
    
    SQL0980C  A disk error occurred.  Subsequent SQL statements
    cannot be
    processed.  SQLSTATE=58005
    
    db2diag.log will show entries like:
    
    2008-01-03-12.28.05.314153-300 E117432E624        LEVEL: Warning
    (OS)
    PID     : 8579                 TID  : 183041513728PROC :
    db2lfrm0 1
    INSTANCE: nyqxt110             NODE : 001
    APPHDL  : 1-1478               APPID: *N0.nyqxt110.080103172805
    AUTHID  : ANDCHUR
    FUNCTION: DB2 UDB, oper system services, sqlochdir, probe:100
    MESSAGE : ZRC=0x860F000A=-2045837302=SQLO_FNEX "File not found."
              DIA8411C A file "" could not be found.
    CALLED  : OS, -, unspecified_system_function      OSERR: ENOENT
    (2)
    DATA #1 : File name, 86 bytes
    /a/nyn19f3/vol/nyn19f3v3/r_ied_r1dw/r1dw/andchur/db23c827/R1DW.E
    QTY_MKT_RISK_USD_05_07
    
    2008-01-03-12.28.05.315023-300 I118057E541        LEVEL: Error
    PID     : 8579                 TID  : 183041513728PROC :
    db2lfrm0 1
    INSTANCE: nyqxt110             NODE : 001
    APPHDL  : 1-1478               APPID: *N0.nyqxt110.080103172805
    AUTHID  : ANDCHUR
    FUNCTION: DB2 UDB, database utilities, DIAG_ERROR, probe:0
    DATA #1 : String, 197 bytes
    LOADID: 30707.2008-01-03-12.28.04.703962.1 (6;17)
    /a/nyn19f3/vol/nyn19f3v3/r_ied_r1dw/r1dw/andchur/db23c827/R1DW.E
    QTY_MKT_RISK_USD_05_07 , -2045837302, (nil), Detected in
    file:sqluldat.C, Line:4501
    

Local fix

Problem summary

  • User Affected: ALL
    Problem Description:
    CLIENT LOAD FAILS WITH SQL0980C "A DISK ERROR OCCURRED"
    ONNECTING TO REMOTE MULTINODE SYSTEM WITH NODES ON SAME BOX.
    Problem Summary:
    ERROR DESCRIPTION:
    A client Load  might fail if loading to a remote (different box)
    Multinode System with Nodes on the same box with the
    following errors:
    
    SQL3109N  The utility is beginning to load data from file
    "/u/r1dw/andchur/db23c827/R1DW.EQTY_MKT_RISK_USD_05_07/000/NYTD
    R1DW_HI".
    
    SQL3500W  The utility is beginning the "LOAD" phase at time
    "01/03/2008
    12:28:05.306016".
    
    SQL0980C  A disk error occurred.  Subsequent SQL statements
    cannot be
    processed.  SQLSTATE=58005
    
    db2diag.log will show entries like:
    
    2008-01-03-12.28.05.314153-300 E117432E624        LEVEL: Warning
    (OS)
    PID     : 8579                 TID  : 183041513728PROC :
    db2lfrm0 1
    INSTANCE: nyqxt110             NODE : 001
    APPHDL  : 1-1478               APPID: *N0.nyqxt110.080103172805
    AUTHID  : ANDCHUR
    FUNCTION: DB2 UDB, oper system services, sqlochdir, probe:100
    MESSAGE : ZRC=0x860F000A=-2045837302=SQLO_FNEX "File not found."
              DIA8411C A file "" could not be found.
    CALLED  : OS, -, unspecified_system_function      OSERR: ENOENT
    (2)
    DATA #1 : File name, 86 bytes
    /a/nyn19f3/vol/nyn19f3v3/r_ied_r1dw/r1dw/andchur/db23c827/R1DW.E
    QTY_MKT_RISK_USD_05_07
    
    2008-01-03-12.28.05.315023-300 I118057E541        LEVEL: Error
    PID     : 8579                 TID  : 183041513728PROC :
    db2lfrm0 1
    INSTANCE: nyqxt110             NODE : 001
    APPHDL  : 1-1478               APPID: *N0.nyqxt110.080103172805
    AUTHID  : ANDCHUR
    FUNCTION: DB2 UDB, database utilities, DIAG_ERROR, probe:0
    DATA #1 : String, 197 bytes
    LOADID: 30707.2008-01-03-12.28.04.703962.1 (6;17)
    /a/nyn19f3/vol/nyn19f3v3/r_ied_r1dw/r1dw/andchur/db23c827/R1DW.E
    QTY_MKT_RISK_USD_05_07 , -2045837302, (nil), Detected in
    file:sqluldat.C, Line:4501
    

Problem conclusion

  • First fixed in DB2 UDB Version 9.5, FixPak 2
    

Temporary fix

Comments

APAR Information

  • APAR number

    LI73042

  • Reported component name

    DB2 UDE ESE LIN

  • Reported component ID

    5765F4104

  • Reported release

    950

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2008-01-15

  • Closed date

    2008-08-28

  • Last modified date

    2009-03-24

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

    LI73032

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

Fix information

  • Fixed component name

    DB2 UDE ESE LIN

  • Fixed component ID

    5765F4104

Applicable component levels

  • R950 PSY

       UP

[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSEPGG","label":"DB2 for Linux, UNIX and Windows"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"950","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
24 March 2009