IC63418: DB2 FAILED TO READ FROM RAW DEVICE BECAUSE MIS-ALIGNED BUFFER ADDRESS WAS PASSED.

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • DB2 failed to read from raw device because mis-aligned buffer
    address was passed.
    
    One of the possible db2diag.log may looks like:
    2009-09-25-13.56.37.106124+060 E465435E1262        LEVEL: Error
    (OS)
    PID     : 30650                TID  : 47949363013952PROC :
    db2sysc 2
    INSTANCE: lntxt010             NODE : 002          DB   : ATHENA
    APPHDL  : 2-237                APPID: *N2.lntxt010.090925125624
    AUTHID  : YANGRACH
    EDUID   : 463                  EDUNAME: db2agent (ATHENA) 2
    FUNCTION: DB2 UDB, oper system services, sqloread, probe:60
    MESSAGE : ZRC=0x870F0002=-2029060094=SQLO_BPSE "Debug logic
    error detected"
              DIA8501C A buffer pool logic error has occurred.
    CALLED  : OS, -, read                             OSERR: EINVAL
    (22)
    DATA #1 : File handle, PD_TYPE_SQO_FILE_HDL, 8 bytes
      File Handle              = 131
      File System Block Size   = 0 bytes
      File System Type         = UNKNOWN
      File Handle Flags :
        Require Sector Align   = No
        DIO/CIO Mode           = No
        Raw Block Device       = No
        Reserved Handle        = No
        Flush On Close         = No
        Thread-Level Lock      = Yes
        Write-through Mode     = Yes
        File Not Tracked       = No
    DATA #2 : unsigned integer, 8 bytes
    1024
    DATA #3 : signed integer, 8 bytes
    -1
    DATA #4 : String, 105 bytes
    Search for ossError*Analysis probe point after this log entry
    for further
    self-diagnosis of this problem.
    
    2009-09-25-13.56.37.107993+060 I466698E1820        LEVEL: Error
    (OS)
    PID     : 30650                TID  : 47949363013952PROC :
    db2sysc 2
    INSTANCE: lntxt010             NODE : 002          DB   : ATHENA
    APPHDL  : 2-237                APPID: *N2.lntxt010.090925125624
    AUTHID  : YANGRACH
    EDUID   : 463                  EDUNAME: db2agent (ATHENA) 2
    FUNCTION: DB2 Common, OSSe, ossErrorIOAnalysis, probe:100
    CALLED  : OS, -, read                             OSERR: EINVAL
    (22)
    DATA #1 : String, 117 bytes
    A total of 3 analysis will be performed :
     - User info
     - Target file info
     - I/O attempt
    
     Target file handle = 131
    DATA #2 : String, 190 bytes
      Real user ID of current process       = 86881
      Effective user ID of current process  = 86881
      Real group ID of current process      = 6179
      Effective group ID of current process = 6179
    DATA #3 : String, 257 bytes
    Target File Information :
      Size               = 0
      Link               = No
      Reference path     = N/A
      Type               = 0x2000
      Permissions        = rw-rw----
      UID                = 14246
      GID                = 6179
      Last modified time = 1253883369
    DATA #4 : String, 33 bytes
    I/O attempt not implemented yet.
    CALLSTCK:
      [0] 0x00002B9C04D0C8C2 pdOSSeLoggingCallback + 0x20C
      [1] 0x00002B9C092563EC
    /var/ibmdb2/lntxt010/sqllib/lib64/libdb2osse.so.1 + 0x1B23EC
      [2] 0x00002B9C092562E3 ossLogSysRC + 0xBF
      [3] 0x00002B9C0924B51E
    /var/ibmdb2/lntxt010/sqllib/lib64/libdb2osse.so.1 + 0x1A751E
      [4] 0x00002B9C0924889D ossErrorAnalysis + 0x2D
      [5] 0x00002B9C06626BB9 sqloSystemErrorHandler + 0x6D7
      [6] 0x00002B9C0521C0F2 sqloread + 0x458
      [7] 0x00002B9C058AA11A
    /var/ibmdb2/lntxt010/sqllib/lib64/libdb2e.so.1 + 0x19EE11A
      [8] 0x00002B9C04D6E8CF sqlbinit + 0xFCF
      [9] 0x00002B9C04E59975
    /var/ibmdb2/lntxt010/sqllib/lib64/libdb2e.so.1 + 0xF9D975
    
    2009-09-25-13.56.37.145687+060 I468519E537         LEVEL: Error
    PID     : 30650                TID  : 47949363013952PROC :
    db2sysc 2
    INSTANCE: lntxt010             NODE : 002          DB   : ATHENA
    APPHDL  : 2-237                APPID: *N2.lntxt010.090925125624
    AUTHID  : YANGRACH
    EDUID   : 463                  EDUNAME: db2agent (ATHENA) 2
    FUNCTION: DB2 UDB, buffer pool services, sqlbinit, probe:570
    MESSAGE : ZRC=0x870F0002=-2029060094=SQLO_BPSE "Debug logic
    error detected"
              DIA8501C A buffer pool logic error has occurred.
    
    Trace may shows:
    642389      sqloopenp entry [eduid 3901 eduname db2agent]
    642390      | sqloThreadLevelFileLockUnlock entry [eduid 3901
    eduname db2agent]
    642391      | sqloThreadLevelFileLockUnlock exit
    642392      | sqloflock entry [eduid 3901 eduname db2agent]
    642393      | sqloflock exit
    642394      sqloopenp exit
    642395      sqloseek entry [eduid 3901 eduname db2agent]
    642396      sqloseek exit
    642397      sqloread entry [eduid 3901 eduname db2agent]
    642398      | sqloSystemErrorHandler entry [eduid 3901 eduname
    db2agent]
    642399      sqloread errtrans [probe 60] [ OSERRNO = 22 -->  ZRC
    = 0x870F0002 = -2029060094 = SQLO_BPSE ]
    

Local fix

  • n/a
    

Problem summary

  • Problem Description:
    DB2 FAILED TO READ FROM RAW DEVICE BECAUSE MIS-ALIGNED BUFFER
    ADDRESS WAS PASSED.
    Problem Summary:
    DB2 failed to read from raw device because mis-aligned buffer
    
    address was passed.
    
    One of the possible db2diag.log may looks like:
    2009-09-25-13.56.37.106124+060 E465435E1262        LEVEL: Error
    (OS)
    PID     : 30650                TID  : 47949363013952PROC :
    db2sysc 2
    INSTANCE: lntxt010             NODE : 002          DB   : ATHENA
    APPHDL  : 2-237                APPID: *N2.lntxt010.090925125624
    AUTHID  : YANGRACH
    EDUID   : 463                  EDUNAME: db2agent (ATHENA) 2
    FUNCTION: DB2 UDB, oper system services, sqloread, probe:60
    MESSAGE : ZRC=0x870F0002=-2029060094=SQLO_BPSE "Debug logic
    error detected"
              DIA8501C A buffer pool logic error has occurred.
    CALLED  : OS, -, read                             OSERR: EINVAL
    (22)
    DATA #1 : File handle, PD_TYPE_SQO_FILE_HDL, 8 bytes
      File Handle              = 131
      File System Block Size   = 0 bytes
      File System Type         = UNKNOWN
      File Handle Flags :
        Require Sector Align   = No
        DIO/CIO Mode           = No
        Raw Block Device       = No
        Reserved Handle        = No
        Flush On Close         = No
        Thread-Level Lock      = Yes
        Write-through Mode     = Yes
        File Not Tracked       = No
    DATA #2 : unsigned integer, 8 bytes
    1024
    DATA #3 : signed integer, 8 bytes
    -1
    DATA #4 : String, 105 bytes
    Search for ossError*Analysis probe point after this log entry
    for further
    self-diagnosis of this problem.
    
    2009-09-25-13.56.37.107993+060 I466698E1820        LEVEL: Error
    (OS)
    PID     : 30650                TID  : 47949363013952PROC :
    db2sysc 2
    INSTANCE: lntxt010             NODE : 002          DB   : ATHENA
    APPHDL  : 2-237                APPID: *N2.lntxt010.090925125624
    AUTHID  : YANGRACH
    EDUID   : 463                  EDUNAME: db2agent (ATHENA) 2
    FUNCTION: DB2 Common, OSSe, ossErrorIOAnalysis, probe:100
    CALLED  : OS, -, read                             OSERR: EINVAL
    (22)
    DATA #1 : String, 117 bytes
    A total of 3 analysis will be performed :
     - User info
     - Target file info
     - I/O attempt
    
     Target file handle = 131
    DATA #2 : String, 190 bytes
      Real user ID of current process       = 86881
      Effective user ID of current process  = 86881
      Real group ID of current process      = 6179
      Effective group ID of current process = 6179
    DATA #3 : String, 257 bytes
    Target File Information :
      Size               = 0
      Link               = No
      Reference path     = N/A
      Type               = 0x2000
      Permissions        = rw-rw----
      UID                = 14246
      GID                = 6179
      Last modified time = 1253883369
    DATA #4 : String, 33 bytes
    I/O attempt not implemented yet.
    CALLSTCK:
      [0] 0x00002B9C04D0C8C2 pdOSSeLoggingCallback + 0x20C
      [1] 0x00002B9C092563EC
    /var/ibmdb2/lntxt010/sqllib/lib64/libdb2osse.so.1 + 0x1B23EC
      [2] 0x00002B9C092562E3 ossLogSysRC + 0xBF
      [3] 0x00002B9C0924B51E
    /var/ibmdb2/lntxt010/sqllib/lib64/libdb2osse.so.1 + 0x1A751E
      [4] 0x00002B9C0924889D ossErrorAnalysis + 0x2D
      [5] 0x00002B9C06626BB9 sqloSystemErrorHandler + 0x6D7
      [6] 0x00002B9C0521C0F2 sqloread + 0x458
      [7] 0x00002B9C058AA11A
    /var/ibmdb2/lntxt010/sqllib/lib64/libdb2e.so.1 + 0x19EE11A
      [8] 0x00002B9C04D6E8CF sqlbinit + 0xFCF
      [9] 0x00002B9C04E59975
    /var/ibmdb2/lntxt010/sqllib/lib64/libdb2e.so.1 + 0xF9D975
    
    2009-09-25-13.56.37.145687+060 I468519E537         LEVEL: Error
    PID     : 30650                TID  : 47949363013952PROC :
    db2sysc 2
    INSTANCE: lntxt010             NODE : 002          DB   : ATHENA
    APPHDL  : 2-237                APPID: *N2.lntxt010.090925125624
    AUTHID  : YANGRACH
    EDUID   : 463                  EDUNAME: db2agent (ATHENA) 2
    FUNCTION: DB2 UDB, buffer pool services, sqlbinit, probe:570
    MESSAGE : ZRC=0x870F0002=-2029060094=SQLO_BPSE "Debug logic
    error detected"
              DIA8501C A buffer pool logic error has occurred.
    
    Trace may shows:
    642389      sqloopenp entry [eduid 3901 eduname db2agent]
    642390      | sqloThreadLevelFileLockUnlock entry [eduid 3901
    eduname db2agent]
    642391      | sqloThreadLevelFileLockUnlock exit
    642392      | sqloflock entry [eduid 3901 eduname db2agent]
    642393      | sqloflock exit
    642394      sqloopenp exit
    642395      sqloseek entry [eduid 3901 eduname db2agent]
    642396      sqloseek exit
    642397      sqloread entry [eduid 3901 eduname db2agent]
    642398      | sqloSystemErrorHandler entry [eduid 3901 eduname
    db2agent]
    642399      sqloread errtrans [probe 60] [ OSERRNO = 22 -->  ZRC
    = 0x870F0002 = -2029060094 = SQLO_BPSE ]
    

Problem conclusion

  • Problem is first fixed in Version 9.7 Fix Pack 1
    

Temporary fix

  • n/a
    

Comments

APAR Information

  • APAR number

    IC63418

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    970

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2009-09-29

  • Closed date

    2009-12-21

  • Last modified date

    2009-12-21

  • 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 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • R970 PSY

       UP



Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

DB2 for Linux, UNIX and Windows

Software version:

9.7

Reference #:

IC63418

Modified date:

2009-12-21

Translate my page

Machine Translation

Content navigation