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.
SAP Knowledge Base Article - Preview