Symptom
- Start the utility_db program to restore a database:
restore database '/app/sybase/MYIQ/MY_IQ/MY_IQ.db'
from '/db_dumps/MYIQ/MY_IQ.full'
rename IQ_SYSTEM_MSG to '/newlocation/MY_IQ/log/MY_IQ.iqmsg'
rename main00 to '/newlocation/MY_IQ/dev/main00'
rename main01 to '/newlocation/MY_IQ/dev/main01'
rename main02 to '/newlocation/MY_IQ/dev/main02'
rename main03 to '/newlocation/MY_IQ/dev/main03'
rename main04 to '/newlocation/MY_IQ/dev/main04'
rename main05 to '/newlocation/MY_IQ/dev/main05'
rename temp22a to '/newlocation/MY_IQ/dev/temp22a'
rename temp23a to '/newlocation/MY_IQ/dev/temp23a'
rename temp24a to '/newlocation/MY_IQ/dev/temp24a'
rename temp25a to '/newlocation/MY_IQ/dev/temp25a'
rename temp27a to '/newlocation/MY_IQ/dev/temp27a'
rename temp28a to '/newlocation/MY_IQ/dev/temp28a'
- One or more of the following errors are returned from the *.iqmsg file:
Exception Thrown from s_db.cxx:4945, Err# 1, tid 3 origtid 3
O/S Err#: 0, ErrID: 2071 (s_dbextexception); SQLCode: -1009100, SQLState: 'QSB00', Severity: 14
Database segment '/newlocation/MY_IQ/dev/main00' is not valid. It is of type '0'. Type BTYPE_DBEXT was expected. This segment cannot be used.
File /newlocation/MY_IQ/dev/main00 of dbspace IQ_SYSTEM_MAIN could not be opened.
Exception Thrown from s_trycatch.cxx:897, Err# 34, tid 3 origtid 3
O/S Err#: 0, ErrID: 2071 (s_dbextexception); SQLCode: -1009086, SQLState: 'QSA86', Severity: 14
Error opening DBFILE '/newlocation/MY_IQ/dev/main00'.********************************************************
**
** Non-Fatal IQ Internal Error Detected
** at /cm/iqa/include/s_unitList.h:466 on thread 34 (TID 3)
**
** Please report this to Sybase IQ support
** with the following diagnostic information,
** and, if possible, with the user's command.
**
** Error from IQ connection:
** Time of error: 20XX-12-25 17:23:35
** IQ Version: Sybase IQ/15.2.0/110530/P/ESD 3
** OS info: IQ built on: Sun_Sparc/OS 5.10, Executed on: SunOS/pns06d-4007b/5.10/IDR141098-02/sun4v
** Command status when error occured: COMMAND ACTIVE
** Command text: - stderrfile:
**************************************************
*** Sybase IQ Abort:
*** From: s_db.cxx:3573
*** PID: 13145
*** Exception Location: 0xffffffff0f47c138
*** Error ID: 533, Exception Type: hos_assertexception
*** Thread: 314 (TID: 3, Original TID: 3)
*** Error #: 3, O/S Error #: 0
**************************************************DBSpaceID: 16387 DBSpaceName: 'IQ_USER_MAIN' FileName: "****/main01"
IQFileName: "dev/main01 IQLogicalFileName: "main01" ServerID: "0"
SegmentType: Main ServerType: IQ StartBlock: 12554496 NBlocks: 27246974
CreateTime: 2010-06-01 11:05:49.000 Offset: 65536 Allocated: 1
DBSPAWN ERROR: -80
Unable to start database server - OS message file:
SQLAnywhere(pnyeqagr1806_iq): [ID 702911 user.error] Error opening DBFILE '/newlocation/dev/MY_IQ/main00'.
Read more...
Environment
SAP IQ (all versions)
Product
Keywords
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.