2262244 - Difference between sp_iqfile and -iqstart 5 Physical block numbers - SAP IQ | SAP Knowledge Base Article

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 ONE Support launchpad (Login required).

Search for additional results

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