SAP Knowledge Base Article - Preview

2878588 - What to do in case of database corruption - SAP IQ

Symptom

*** To SAP Customers: Open an case and wait for instructions from SAP Support ***
*** To SAP Support engineers: Consult IQ engineering before proceeding to any of the steps outlined in this KBA ***

 

If "Incorrect page header read" errors or "Decompression error during read" are seen in IQMSG, then one or several database corruptions have occurred.

Examples:

main Bufman: Incorrect page header read; from slib/s_trycatch.cxx:3033 into buffer 0x7f39dbc87160
expected: btype=14,pbn=2255438998,txn=318030875,sp=6,nlb=16,npb=16,iscmp=0,uid=202237502,blk=2255438998,mn=1519,upmn=1519,flgs=0x80000008
head: btype=12,pbn=2211438900,txn=316265476,sp=32,nlb=16,npb=13,iscmp=1,ctr=136,cta=134,ver=1,pb=79,pus=35194
buffer: 0x0c0010000d00888696446f860000000004d4d9120000000020000000014f7a89
Expected Pad1: 150 (0x96), Pad2: 58942 (0xe63e)
Got Pad1: 79 (0x4f), Pad2: 35194 (0x897a)

main Bufman: Decompression error during Read; from slib/s_buf.cxx:1801 into buffer 0x7f39cca8abf0
expected: btype=7,pbn=1796053477,txn=318017859,sp=7,nlb=16,npb=12,iscmp=1,uid=168301663,blk=134,mn=503,upmn=503,flgs=0x80000018
head: btype=7,pbn=1796053455,txn=317373933,sp=9,nlb=16,npb=12,iscmp=1,ctr=136,cta=134,ver=1,pb=95,pus=134
buffer: 0x070010000c008886e5990d6b00000000edbdea120000000009000000015f8600
Expected Pad1: 95 (0x5f), Pad2: 134 (0x0086)
Got Pad1: 95 (0x5f), Pad2: 134 (0x0086)

A stack trace could also be printed (not always) with or without the SQL statement accessing data with those block numbers.


Read more...

Environment

SAP IQ 16.x

Keywords

"Incorrect page header read",  IPHR,  "blocks with multiple owners" , "unallocated blocks in use", multiple, owners, unallocated, blocks, corrupt, sp_iqcheckdb, allocation, CORE_Options157, CORE_Options158 , KBA , BC-SYB-IQ , Sybase IQ , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.