IBM Support

JR30345: ERROR(S) SQL0901N, SQL0452N, "CORRELATION IDENTIFIER OVERFLOW", OR SQLJC_ERROR_ICE WHEN IMPORTING BLOBS ON WINDOWS

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Importing BLOBs on Windows can result in SQL0901N, or SQL0452N,
    or "CORRELATION IDENTIFIER OVERFLOW", or SQLJC_ERROR_ICE errors.
    
    This is caused by a defect in the sqlochgfileptr() function when
    seeking in a file above 2 GB boundary (but below 4 GB).  This is
    Windows specific problem and a db2 trace would show error
    ERROR_NEGATIVE_SEEK (131):
    
    ----------------------------------------------------------------
    252586 data DB2 UDB oper system services sqlochgfileptr cei
    (3.3.15.660.2.1)
    pid 6216 tid 8140 cpid 7 node 0 probe 1
    bytes 40
    Data1 (PD_TYPE_DEFAULT,4) Hexdump:
    2C02 0000 ,...
    Data2 (PD_TYPE_DEFAULT,8) Hexdump:
    8E29 6280 0000 0000 .)b.....
    Data3 (PD_TYPE_DEFAULT,4) Hexdump:
    0000 0000 ....
    ...
    
    252596 errtrans DB2 UDB oper system services sqlochgfileptr cei
    (13.3.15.660.2.100)
    pid 6216 tid 8140 cpid 7 node 0 probe 100
    Error Translation
    Original Error OSERRNO = 131 => ERROR_NEGATIVE_SEEK
    New Error ZRC = 0x860F0006 = -2045837306 = SQLO_DSEK
    ----------------------------------------------------------------
    
    This problem can be identified by errors SQL0901N and
    SQLJC_ERROR_ICE in the db2diag.log:
    ----------------------------------------------------------------
    2008-07-30-21.52.15.828000+330 I79322H497         LEVEL: Warning
    PID     : 228                  TID  : 3764        PROC :
    db2move.exe
    INSTANCE: DB2                  NODE : 000
    APPID   : *LOCAL.DB2.080730154635
    EDUID   : 3764
    FUNCTION: DB2 UDB, DRDA Communication Manager, sqljcBeginDss,
    probe:100
    MESSAGE : ZRC=0x82360001=-2110390271=SQLJC_ERROR_ICE "SYSTEM
    ERROR"
              DIA8532C An internal processing error has occurred.
    DATA #1 : String, 32 bytes
    Correlation Identifier overflow.
    ----------------------------------------------------------------
    
    Another sign of hitting this APAR is db2move failure to import
    large BLOBs due to error SQL0452N:
    
    SQL0452N Unable to access the file referenced by host variable
    "8".  Reason code:  "5".  SQLSTATE=428A1
    

Local fix

Problem summary

  • USERS AFFECTED:
    The DB2 users on Windows platform
    
    PROBLEM DESCRIPTION:
    Importing BLOBs on Windows can result in SQL0901N, or SQL0452N,
    or "CORRELATION IDENTIFIER OVERFLOW", or SQLJC_ERROR_ICE errors.
    
    PROBLEM SUMMARY:
    The problem is caused by a defect in the sqlochgfileptr()
    function when seeking in a file above 2 GB boundary (but below 4
    GB).  This is Windows specific problem and a db2 trace would
    show error ERROR_NEGATIVE_SEEK (131):
    
    ----------------------------------------------------------------
    252586 data DB2 UDB oper system services sqlochgfileptr cei
    (3.3.15.660.2.1)
    pid 6216 tid 8140 cpid 7 node 0 probe 1
    bytes 40
    Data1 (PD_TYPE_DEFAULT,4) Hexdump:
    2C02 0000 ,...
    Data2 (PD_TYPE_DEFAULT,8) Hexdump:
    8E29 6280 0000 0000 .)b.....
    Data3 (PD_TYPE_DEFAULT,4) Hexdump:
    0000 0000 ....
    ...
    
    252596 errtrans DB2 UDB oper system services sqlochgfileptr cei
    (13.3.15.660.2.100)
    pid 6216 tid 8140 cpid 7 node 0 probe 100
    Error Translation
    Original Error OSERRNO = 131 => ERROR_NEGATIVE_SEEK
    New Error ZRC = 0x860F0006 = -2045837306 = SQLO_DSEK
    ----------------------------------------------------------------
    
    This problem can be identified by errors SQL0901N and
    SQLJC_ERROR_ICE in the db2diag.log:
    ----------------------------------------------------------------
    2008-07-30-21.52.15.828000+330 I79322H497         LEVEL: Warning
    PID     : 228                  TID  : 3764        PROC :
    db2move.exe
    INSTANCE: DB2                  NODE : 000
    APPID   : *LOCAL.DB2.080730154635
    EDUID   : 3764
    FUNCTION: DB2 UDB, DRDA Communication Manager, sqljcBeginDss,
    probe:100
    MESSAGE : ZRC=0x82360001=-2110390271=SQLJC_ERROR_ICE "SYSTEM
    ERROR"
              DIA8532C An internal processing error has occurred.
    DATA #1 : String, 32 bytes
    Correlation Identifier overflow.
    ----------------------------------------------------------------
    
    Another sign of hitting this APAR is db2move failure to import
    large BLOBs due to error SQL0452N:
    
    SQL0452N Unable to access the file referenced by host variable
    "8".  Reason code:  "5".  SQLSTATE=428A1
    

Problem conclusion

  • First fixed in DB2 UDB Version 9.5, FixPak 3 (s081118).
    

Temporary fix

Comments

APAR Information

  • APAR number

    JR30345

  • Reported component name

    DB2 UDB EXE WIN

  • Reported component ID

    5724E4901

  • Reported release

    950

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2008-08-27

  • Closed date

    2009-03-09

  • Last modified date

    2009-03-09

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

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

Fix information

  • Fixed component name

    DB2 UDB EXE WIN

  • Fixed component ID

    5724E4901

Applicable component levels

  • R810 PSN

       UP

  • R820 PSN

       UP

  • R910 PSN

       UP

  • R950 PSN

       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:
09 March 2009