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 for Me (Login required).

Search for additional results

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