Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
Database Servers
DB2InformixIngresMS SQLOraclePervasive.SQLPostgreSQLProgressSybase
Desktop Databases
FileMakerFoxProMS AccessParadox
General
General DB TopicsDatabase Theory
Related Topics
Java Development.NET DevelopmentVB DevelopmentMore Topics ...

Database Forum / DB2 Topics / February 2006

Tip: Looking for answers? Try searching our database.

Question on data placement re Raid10

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
datapro01@yahoo.com - 15 Feb 2006 16:03 GMT
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.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.