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
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.