A customer reporting seeing a significant increase in the amount of I/O read writes on their IQ Main dbfiles since upgrading some customer systems. The issue has been seen on IQ 16.1 after upgrading from SP02.08 to SP02.11 and also on IQ 16.0 SP11 systems recently upgraded to PL20. Workload and data load volumes have not changed.
They urgently need to find out what's causing this as it is blocking roll out of their IQ upgrades. The main issue is that its affecting
their SAN snapshot retention period. The increases in I/O activity means the they are only able to retain the last 5 hours of activity ,
a significantly smaller window than before posing a great risk to their recovery capabilities.
- Read Write volumes are about the same
- Grab Dirty is a little lower.
- Hit% rates are fine
We are awaiting further more detailed comparison data to analyse.
SAP IQ 16.1
KBA , BC-SYB-IQ , Sybase IQ , How To
About this pageThis 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.