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; 822681; reorg , 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 for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.