Ansicht
Dokumentation

12593 - Balancing data with new disks

12593 - Balancing data with new disks

rdisp/max_wprun_time - Maximum work process run time   TXBHW - Original Tax Base Amount in Local Currency  
This documentation is copyright by SAP AG.
SAP E-Book

Balancing data with new disks

Hi all,



This weekend we are installing 20 new disks in our AS400 and we would
like to balance all data in order to improve the performance.

We think that we have 3 different ways to balance the data:



1.- Capacity balance. All data will be shared between disks depending on
the capacity. However, we think that is possible that all data of a
table will be in a single disk.

2.- Usage balance. All data will be shared depending on a set of
statistics. Using this system we could obtain a small disk full of data
while the new big disks will be rather empty.

3.- Apply a backup and restore of the R3<SID>DATA library. In this case
all the data will be shared among the disks in a most equilibrate way,
where the data of all the tables will be shared in different disks.



Is it true?. Do you know other ways to balance the data? Is the 3rd
solution the best one?. What will you do in our case? (The database is
400 GB)



Thanks for your comments.



Best regards,

Juan Mir











[Non-text portions of this message have been removed]


Durban Tours - Südafrika Safari

BAL_S_LOG - Application Log: Log header data   TXBHW - Original Tax Base Amount in Local Currency  
This documentation is copyright by SAP AG.

Length: 1597 Date: 20240427 Time: 060939     sap01-206 ( 3 ms )