3513918 - Full backup is very slow in Large Database - SAP IQ

Symptom

Large database Full Backup is very slow saving 1TB per hour when using high-speed disks.
What is wrong with the server configuration that is causing this problem?

IQMSG extract:

------

I. 07/14 03:08:38. 0001581313 Connect: SA connHandle: 451410 SA connID: 136 IQ connID: 0001581313 User: iqloader

...

I. 07/14 04:18:23. 0001581313 TeamBase: db_IQbackup::team W 225; G 144

I. 07/14 04:18:23. 0001581313 Total blocks to backup: 6126263826

I. 07/14 04:18:23. 0001581313 Write boundary - %d1

I. 07/14 04:18:23. 0001581313 [20949]: Number of IQ blocks backed up: 50000
------

Environment

SAP IQ 16.1

Product

SAP IQ 16.1

Keywords

sybase backup poor performance , KBA , BC-SYB-IQ , Sybase IQ , BW-SYS-DB-IQ , BW on HANA with Sybase IQ Near-line Storage , 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.