SAP Knowledge Base Article - Preview

1954383 - restore of IQ database hangs utility_db server

Symptom

A large SAP Sybase IQ database (larger than several Gb) is restored from a backup taken at an identical primary server. The utility database session "hangs" after it has restored all the blocks.

utility_db srvlog shows:

I. TIMESTAMP. Database "utility_db" (utility_db) started at TIMESTAMP
I. TIMESTAMP. Starting database "a_restore" (/PATH/IQ_DB.db) at TIMESTAMP
I. TIMESTAMP. Starting database "a_restore" (/PATH/IQ_DB.db) at TIMESTAMP
I. TIMESTAMP. Database recovery in progress
I. TIMESTAMP.     Last checkpoint at TIMESTAMP
I. TIMESTAMP.     Rollback log...
I. TIMESTAMP.     Checkpointing...
I. TIMESTAMP. Recovery complete
I. TIMESTAMP. Database "a_restore" (IQCLDW01.db) started at TIMESTAMP
I. TIMESTAMP. Database "a_restore" (IQCLDW01.db) stopped at TIMESTAMP
I. TIMESTAMP. Starting database "a_restore" (/PATH/IQ_DB.db) at TIMESTAMP

The restored IQ database will not startup after this. Srvlog show:

E. TIMESTAMP. Resource temporarily unavailable
I. TIMESTAMP. Database server shutdown due to startup error
I. TIMESTAMP. Database server stopped at TIMESTAMP


Read more...

Environment

SAP Sybase IQ 15.x
SAP Sybase IQ 16.x

Keywords

backup restore memory , KBA , BC-SYB-IQ , Sybase IQ , Problem

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.