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.