SAP Knowledge Base Article - Preview

3228926 - Incremental backup and load in IQ

Symptom

  • Loading both full and incremental backups are failing. 
  • Load is asking to remove db files.  However,  the restore is on same server(source and target are same).
  • An example of the error is:
    dbisql -c "uid=DBA;pwd=xxx  ;eng=utility_db;dbn=utility_db" -nogui read restore.sql > restore.sql_out
    Could not execute statement.
      IQ store dbfile /dbdumps/iqmain1.iq exists. Restore will not be done.
      -- (dblib/db_backupCmds.cxx 3020)
      SQLCODE=-1012037, ODBC 3 State="HY000"
    /dbdumps/restore_1.sql:1
      RESTORE DATABASE '/dbdumps/iq/data/iq_db/test.db'
    You can continue executing or stop.
    1. Stop
    2. Continue
    Select an option:


Read more...

Environment

SAP IQ 16.1

Product

SAP IQ 16.1

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.