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
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.