SAP Knowledge Base Article - Preview

1950376 - How to perform a recovery without .iqtmp files - SAP IQ


  • IQ_SYSTEM_TEMP is temporary dbspace for IQ database. The dbspace has one or more dbspace files that have .iqtmp as file extension.
  • If these files are lost by hardware trouble or miss operation, you can perform a recovery by hand.
  • Another alternative is to recover these files by restoring the database from clean backup.
  • Error messages may be similar to:
E. 04/26 12:36:07. Error: Error opening DBFILE 'G:\temp\mytempfile.iqtmp'.
-- (slib\s_trycatch.cxx 1827)



SAP IQ 15.x or later.


SAP IQ 16.0 ; SAP Sybase IQ 15.2 ; SAP Sybase IQ 15.4


IQ_SYSTEM_TEMP, .iqtmp, -iqnotemp, recovery , 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.