SAP Knowledge Base Article - Preview

2768327 - IPHR in-memory tracing option to further investigate Incorrect Page Header Read issues - SAP IQ

Symptom

  • How to use the IPHR diagnostic in-memory tracing option to further investigate SAP IQ 16.x servers.
  • Which are reporting Incorrect Page Header Read related errors
  • Which do not match any existing known documented issues. 
  • The diagnostic options to be used are IQ startup switches:
    •  -iqiphrtracing 
    • -iq_thread_msg_buf_size in-memory tracing feature
    • These traces should only be used after first consulting with SAP Product Support.
  • The diagnostic tracing information produced will enable SAP IQ engineering to identify root causes of IPHR related issues
  • Without the need to provide custom-built instrumentation, there by speed up resolution times. 
  • The symptom characteristics associated with IPHR errors include... 

    • Queries intermittently failing with main Bufmain: Incorrect page header read errors (IPHR)
    • main Bufman errors from slib/s_trycatch.cxx or lib/s_dpidx.cxx
    • main Bufman: An error was detected on a database page. You may have a damaged index.
    • ErrID: 2100 (s_corruptdiskblkhdrexception); SQLCode: -1009039, SQLState: 'QSA39'
    • BArray header mismatch errors
    • Block count mismatch errors during DBCC checkdb consistency checks.  Specific s_bm errors (i.e., BM_BADCOUNT_ERROR, BM_BITSOFF_ERROR, BM_BITSON_ERROR), and Server aborts.


Read more...

Environment

The diagnostic tracing option is only available post:

  • SAP IQ 16.0 SP11 PL22
  • SAP IQ 16.1 SP02 PL14
  • SAP IQ 16.1 SP03 PL04
  • SAP IQ 16.0 SP04

Product

SAP IQ 16.1

Keywords

sybase, corruption, error, abort, failure, , sp_iqcheckdb, mpx, secondary, coordinator, exception, debug, 'in memory', inmemory, crash, corrupt , KBA , BC-SYB-IQ , Sybase IQ , How To

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.