3009042 - Errors when trying to restore an IQ server - SAP IQ

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

SAP IQ (all versions)

KBA , BC-SYB-IQ , Sybase IQ , How To