SAP Knowledge Base Article - Preview

2760504 - IQ unresponsive while parallel "alter table move" between dbspaces - SAP IQ

Symptom

Customer is upgrading from IQ 16 sp11 to IQ 16.1 sp02.
In addition moving tables from 100 Gb dbfiles ( dbspace1 ) to 500 Gb dbfiles ( dbspace2 ).

1. CPU gets quite loaded with single table relocation operation and mostly unresponsive if customer starts 3 tables at once.

2. lsof shows 100 fold increase in file handles. 600000 file handles vs. 6000 in older release.


Read more...

Environment

SAP IQ 16.1

Keywords

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.