/support/notes/service/sap_logo.png){kind=logo}
SAP Knowledge Base Article - PreviewSymptom
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.
/support/notes/service/facebook.svg)
/support/notes/service/twitter.svg)
/support/notes/service/youtube.svg)
/support/notes/service/linkedin.svg)
/support/notes/service/instagram2.svg)