2510113 - Restore incremental backup hang -SAP IQ | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

2510113 - Restore incremental backup hang -SAP IQ

Symptom

Restore full backup is successful. Restore incremental backup hangs forever.

In utility_db.srvlog, you can see very verbose messages such as:

I. 08/03 08:07:29. Starting database "utility_db" (utility_db) at Thu Aug 03 2017 08:07
I. 08/03 08:07:29. Database "utility_db" (utility_db) started at Thu Aug 03 2017 08:07
I. 08/03 08:07:29. Stripe 0 OpenDevice mode 0
I. 08/03 08:07:29. Stripe 0, Open /var/sybase/dumps/1/IQ_InSF_20170718_0300.1 OK
I. 08/03 08:07:29. Stripe 1 OpenDevice mode 0
I. 08/03 08:07:29. Stripe 1, Open /var/sybase/dumps/2/IQ_InSF_20170718_0300.1 OK
I. 08/03 08:07:29. Stripe 2 OpenDevice mode 0
I. 08/03 08:07:29. Stripe 2, Open /var/sybase/dumps/3/IQ_InSF_20170718_0300.1 OK
I. 08/03 08:07:29. Stripe 3 OpenDevice mode 0
I. 08/03 08:07:29. Stripe 3, Open /var/sybase/dumps/4/IQ_InSF_20170718_0300.1 OK

....

I. 08/03 08:07:30. Stripe 15 OpenDevice mode 0
I. 08/03 08:07:30. Stripe 15, Open /var/sybase/dumps/15/IQ_InSF_20170718_0300.1 OK
I. 08/03 08:07:30. Starting database "a_restore" (/var/sybase/config/database.db) at Thu Aug 03 2017 08:07
I. 08/03 08:08:30. Database "a_restore" (database.db) started at Thu Aug 03 2017 08:08
I. 08/03 08:08:30. IQ Server utility_db.
I. 08/03 08:08:59. Database "a_restore" (database.db) stopped at Thu Aug 03 2017 08:08
I. 08/03 08:09:11. Starting database "a_restore" (/var/sybase/config/database.db) at Thu Aug 03 2017 08:09
I. 08/03 08:09:16. Starting database "a_restore" (/var/sybase/config/database.db) at Thu Aug 03 2017 08:09
I. 08/03 08:09:20. Database recovery in progress
I. 08/03 08:09:20. Last checkpoint at Thu Aug 03 2017 08:09
I. 08/03 08:09:20. Rollback log...
I. 08/03 08:09:20. Checkpointing...
I. 08/03 08:09:20. Recovery complete
I. 08/03 08:09:20. Database "a_restore" (database.db) started at Thu Aug 03 2017 08:09

From here restore incremental hangs.


Read more...

Environment

SAP IQ 16

Product

SAP IQ 16.0

Keywords

SYBDBG, $SYBDBG, verbose, utility_db.srvlog , 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.