DB2 LUW: Table/Tablespace Partitioning v8 vs v9

Brian Stewart

DB2 LUW: Table/Tablespace Partitioning v8 vs v9
Hello -

I am investigating an approach where I would like to partition a table
based on region and have DB2 place each region in a different
tablespace. I have a few questions I have been researching for answers
and would like to pose these to the group for feedback - any and all
is welcome.

1. I believe DB2 v9 allows me to do this based on my understanding of
CREATE TABLE syntax - I can partition on range (which would be only
one value - the region ID) and associate each partition to a different
tablespace. As new regions are added, I can add a partition to the
table using ALTER TABLE and associate that partition to a newly
created tablespace for the region. Please correct me if I am wrong
here. I cannot seem to find a similar capability in DB2 v8 - is that
correct?

2. Given the scenario above, would an IMPORT of a single region's data
into the table lock all of the tablespaces or just the affected one?

3. I understand that the IMPORT utility can be configured to allow
read and write access to the table during import - how much of an
impact on OLTP-type applications have you seen in this regard?

4. Are there any caveats, land mines etc. that I need to be aware of?

Much thanks in advance -

Brian

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Rodney Krick

DB2 LUW: Table/Tablespace Partitioning v8 vs v9
(in response to Brian Stewart)



Brian,

I believe you can find some answers for your questions in this tutorial:

DB2 9 table partitioning
Improved large database management
(on developerWorks)
http://www-128.ibm.com/developerworks/edu/dm-dw-dm-0612read-i.html

HTH.

Mit freundlichen Grüßen / Best regards,

Rodney Krick
Senior Consultant
____________________________
aformatik Training & Consulting GmbH & Co. KG
Tilsiter Str. 8, D-71065 Sindelfingen, Germany
Tel.: +49 (0)7031-23 807-0
Fax: +49 (0)7031-23 807-19

mailto:[login to unmask email]
___________________________________________
ECIS, Education Center for IBM Software, Websphere and DB2
---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm