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 ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.