SAP Knowledge Base Article - Preview

2965770 - Feature request to rebalance data usages in all dbfiles for better performance - SAP IQ

Symptom

  • A request for a new feature to rebalance data usages in all the dbfiles after new dbfiles are added. 
  • Allowing free space in all of the dbfiles. 
  • Thus allowing loads and queries to run using all spaces in parallel. 
  • For example:
    • All the dbfiles are almost full.
    • 2 new dbfiles are added.
    • Performance could become slow as new data are stored only in the 2 new dbfiles.
    • Loads can run in parallel on only 2 dbfiles instead of on tens of dbfiles.
    • Queries affecting new data stored on the 2 new dbfiles could run slow.
    • Performance could degrade.


Read more...

Environment

SAP IQ 16.1

Product

SAP IQ 16.1

Keywords

CR822681; CR#822681; 822681reorg , KBA , BC-SYB-IQ , Sybase IQ , Product Enhancement

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.