SAP Knowledge Base Article - Preview

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

Symptom

  • 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)


Read more...

Environment

SAP IQ 15.x or later.

Product

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

Keywords

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.