2548428 - It takes so long time to complete backup database. | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

2548428 - It takes so long time to complete backup database.

Symptom

It usually takes 3 ~ 4 hours to back up the IQ database, but It suddenly took more than 8 hours to complete the backup database and it had to be stopped.
The backup is done by the feature SAP IQ provide, not by a 3rd party backup software.

backup database CRC OFF BLOCK FACTOR 25 to 'Y:\CDW\Databases\Sybaseiq\Backup\cdw.bak' SIZE 20000000

According to the message log and the srvlog, it has something to do with the backup device.
One writing operation took 2~2.5 minutes in average on 10/4 as below.

[10/04]
I. 10/04 23:00:04. Stripe 0 OpenDevice mode 1
I. 10/04 23:00:04. Stripe 0, OpenDiskDev mode 1
I. 10/04 23:02:12. Stripe 0 Switching Media (mode 1)
I. 10/04 23:02:12. Stripe 0 Writing EOV labels

I. 10/05 01:57:00. Stripe 0 OpenDevice mode 1
I. 10/05 01:57:00. Stripe 0, OpenDiskDev mode 1
I. 10/05 01:59:27. Stripe 0 Switching Media (mode 1)
I. 10/05 01:59:27. Stripe 0 Writing EOV labels

On the contrary, it took 2~3 minutes at the beginning, but took sometimes more than 10 minutes on Oct/8 and Oct/9.

[10/08]
I. 10/08 23:00:17. Stripe 0 OpenDevice mode 1
I. 10/08 23:00:17. Stripe 0, OpenDiskDev mode 1
I. 10/08 23:03:51. Stripe 0 Switching Media (mode 1)
I. 10/08 23:03:51. Stripe 0 Writing EOV labels

I. 10/09 05:01:13. Stripe 0 OpenDevice mode 1
I. 10/09 05:01:13. Stripe 0, OpenDiskDev mode 1
I. 10/09 05:16:43. Stripe 0 Switching Media (mode 1)
I. 10/09 05:16:43. Stripe 0 Writing EOV labels

[10/09]
I. 10/09 23:00:23. Stripe 0 OpenDevice mode 1
I. 10/09 23:00:23. Stripe 0, OpenDiskDev mode 1
I. 10/09 23:02:56. Stripe 0 Switching Media (mode 1)
I. 10/09 23:02:56. Stripe 0 Writing EOV labels

I. 10/10 05:01:43. Stripe 0 OpenDevice mode 1
I. 10/10 05:01:43. Stripe 0, OpenDiskDev mode 1
I. 10/10 05:12:15. Stripe 0 Switching Media (mode 1)
I. 10/10 05:12:15. Stripe 0 Writing EOV labels


Read more...

Environment

SAP IQ 16.0 SP11.06
windows 2012

Product

SAP IQ 16.0

Keywords

SAP IQ, IQ, backup database, backup, back up, long time , 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.