SAP Knowledge Base Article - Preview

2625322 - Restore fails with "There must be at least one readwrite dbspace" -- SAP IQ

Symptom

Restore fails with following error message 

-------
(dba)> restore database '/tmp/iqdemo.db' from '/tmp/iqdemo.full'

Catalog restore complete
Could not execute statement.
There must be at least one readwrite dbspace
(/tmp/iqdemo.iqtmp).
--
(slib/s_trycatch.cxx 738)
SQLCODE=-1009160, ODBC 3 State="HY000"
-------

Running [ db_backupheader '/tmp/iqdemo.full.1' ] indicates that IQ_SYSTEM_TEMP has at least one readwrite dbfile but first dbfile is readonly.

-------
DB Space Record:

DBSpace Name: "IQ_SYSTEM_TEMP"
DBSpace ID: "16385"
Number of DBFiles: "2"
Is Readonly: "no"
Is Online: "yes"
Number of dbfile definitions in dbspace "IQ_SYSTEM_TEMP": 2

DB File Record:
File Name: "IQ_SYSTEM_TEMP"
File Path: "iqdemo.iqtmp"
File ID: "16385"
DBSpace ID: "16385"
Is Readonly: "yes"

DB File Record:
File Name: "IQ_SYSTEM_TEMP_2"
File Path: "IQ_SYSTEM_TEMP_2.iqtmp"
File ID: "16389"
DBSpace ID: "16385"
Is Readonly: "no"

-------


Read more...

Environment

 IQ 16 sp11+

Product

SAP IQ 16.0 ; SAP IQ 16.1

Keywords

IQ_SYSTEM_TEMP , restore database , "There must be at least one readwrite dbspace" , SQLCODE=-1009160 , KBA , BC-SYB-IQ , Sybase IQ , Bug Filed

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.