SAP Knowledge Base Article - Preview

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

    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)


SAP IQ 16.0 ; SAP IQ 16.1 ; SAP Sybase IQ 15.2 ; SAP Sybase IQ 15.4


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.