Running DB2 8.2 on AIX5.2
When a new application was installed, a consultant recommended that
large tablespaces be defined with just one container, given that the
container was striped into a raid10 array of discs.
There are 2 or 3 other heavy hit tablespaces that share that array.
In this type of raid10 environment, is there any performance advantage
to be gained by breaking up a heavy hit tablespace into separate
containers onto separate hdisks in that array?
Have checked a number of resources .i.e Database Performace Tuning on
AIX.
Is that the best resource possible for the data placement aspect of
tuning in reagrds to Raid arrays?
Thanks in advance.
Gerry
Eugene F - 15 Feb 2006 23:03 GMT
http://publib.boulder.ibm.com/infocenter/db2luw/v8/index.jsp?topic=/com.ibm.db2.
udb.doc/admin/t0004987.htm
-Eugene
datapro01@yahoo.com - 16 Feb 2006 00:19 GMT
Well thanks Eugene.
Typically, this documentation first recommends that only a single
container be declared for a ts on a raid device. Seems to anyway.
It then proceeds to a lenghty discussion of tablespaces with more than
one container defined....presumably still on a raid device as that is
the module heading.
We are constrained in our configuration settings as we are tied in with
Siebel, until Oracle drops support for DB2 anyway. That's why the
question. This documentation doesn't really answer the question so I've
opned an ETR with IBM and will see what they have to say.