Table partition

[Rajesh Chowdhury]

Hi !

Q1.i need to partition tables in db2 ...can somebody explain me how to go about it ...in the sense what strategy should i adopt when i am partitioning the table should it be a range partitioning ?we are using data stage as our ETL .

Q2.i am creating a database that is of size 600 gb .what strategy should ii adopt while creating tablespaces like how many tablespaces should i have and how containers should they have ? should they be sms or dms ? i will be creating these tablespaces on san.. what strategy should i adopt ?

Q3. should the log files be placed on the local machine ? or on the san ?

[Blair Kenneth Adamache]

Q1. 600 GB is not a lot of data, and does not on its own justify
partitioning. Use hash partitioning if the performance of SELECTs is
most important. Use MDC or Range partitioning if you do lots of roll
in/roll out, and want to have control (and have the time to set up) MDC
and/or ranges. See http://www.redbooks.ibm.com/abstracts/SG247467.html?Open

Q2. Use automatic storage (DMS on the file system).

See:

http://publib.boulder.ibm.com/infocenter/db2luw/v9/index.jsp?topic=/com.ibm.db2.udb.admin.doc/doc/c0012278.htm

Post by Rajesh Chowdhury
Hi !
Q1.i need to partition tables in db2 ...can somebody explain me how to go about it ...in the sense what strategy should i adopt when i am partitioning the table should it be a range partitioning ?we are using data stage as our ETL .
Q2.i am creating a database that is of size 600 gb .what strategy should ii adopt while creating tablespaces like how many tablespaces should i have and how containers should they have ? should they be sms or dms ? i will be creating these tablespaces on san.. what strategy should i adopt ?
Q3. should the log files be placed on the local machine ? or on the san ?

[Rajesh Chowdhury]

Hi Thanks for your reply ! i am using db2 DB2 8.2.3 the document you suggested about partitioning is for DB2 9.can i adopt the same strategy suggested in it ?
Thanks & Regards

[Blair Kenneth Adamache]

You can use MDC and table partitioning in v8.2.3. You need v9 for range
partitioning.

Post by Rajesh Chowdhury
Hi Thanks for your reply ! i am using db2 DB2 8.2.3 the document you suggested about partitioning is for DB2 9.can i adopt the same strategy suggested in it ?
Thanks & Regards