Skip to main content

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


Fixes are available

DB2 Version 9.7 Fix Pack 1 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 2 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows

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 





















	
	
	
	
	









	



























Copyright and trademark information



	
IBM, the IBM logo and ibm.com are trademarks of International Business Machines Corp., registered in many jurisdictions worldwide.  Other product and service names might be trademarks of IBM or other companies.  A current list of IBM trademarks is available on the Web at "Copyright and trademark information" at www.ibm.com/legal/copytrade.shtml.































Rate this page:






(0 users)Average rating









Add comments














Document information





	
DB2 for Linux, UNIX and Windows


	




	
Software version:

	9.7

	





	
Reference #:

IC63418






Modified date:

2009-12-21








Translate my page














































 



Content navigation