SAP Knowledge Base Article - Preview

2262244 - Difference between sp_iqfile and -iqstart 5 Physical block numbers - SAP IQ

Symptom

The output of sp_iqfile, sp_iqstatus and start_iq with -iqstart 5 all can show the disk block start and end numbers for each IQ dbspace.
The physical start and end block numbers match between sp_iqstatus and sp_iqfile.
However these numbers show a discrepancy with the output of -iqstart 5

 

Example:

DBFile  sp_iqstatus numbers    sp_iqfile Start  sp_iqfile End  -iqstart 5 Match?
IQ_DBSPACE DB Blocks: 1851046656-1867830779  1851046656  1867830779  6146013952  NO


Read more...

Environment

SAP IQ 16

This is issue is reported on Linux. It might be found on other OS.

Product

SAP IQ 16.0

Keywords

-iqstart 5, sp_iqstatus, sp_iqfile, physical, block, numbers, discrepancy , 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.