Ansicht
Dokumentation
12596 - Balancing data with new disks
General Data in Customer Master rdisp/max_wprun_time - Maximum work process run timeThis documentation is copyright by SAP AG.
Balancing data with new disks
Hi JuanWhen we put in new disks we balance by capacity then we take a weeks
worth of traces, command TRCASPBAL. We do the traces during peak periods
of usage to balance the disks when they are used the most. Then we
balance by usage. This seems to give us the best performance on our
disks. I hope this helps.
ThankYou
Don Osinski
SAP Basis Administrator
DOsinskiZplastipak.com
-----Original Message-----
From: Joan Mir Rubio [mailto:jmirZcamper.es]
Sent: Thursday, January 15, 2004 7:21 AM
To: DoNotReply@consolut.eu
Subject: 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]
Have a look to our homepage at: http://www.consolut.net
DoNotReply@consolut.eu
consolut Links
To visit your group on the web, go to:
http://groups.consolut.net/group/SAP on System i/
To unsubscribe from this group, send an email to:
DoNotReply@consolut.eu
Your use of consolut is subject to:
http://www.consolut.net
Durban Tours - Südafrika Safari
SUBST_MERGE_LIST - merge external lists to one complete list with #if... logic for R3up SUBST_MERGE_LIST - merge external lists to one complete list with #if... logic for R3up
This documentation is copyright by SAP AG.
Length: 3426 Date: 20240425 Time: 061251 sap01-206 ( 3 ms )