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 ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.