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.
SAP Knowledge Base Article - Preview