470,636 Members | 1,468 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,636 developers. It's quick & easy.

Partition an existing table?

Can I partition an existing table?
I have a table which has started growing at a very fast pace and would
like to partition it.
Thanks.

Cheers,
San.

May 14 '06 #1
6 3946
shsandeep wrote:
Can I partition an existing table?
I have a table which has started growing at a very fast pace and would
like to partition it.


Which platform are you talking about and which sort of partitioning?

Cheers
Serge

--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab
May 14 '06 #2
Db2 V8.2 on AIX V5.3
Partitioning a table based on the partitioning keys.

May 15 '06 #3
"shsandeep" <sa**********@gmail.com> wrote in message
news:a8******************************@localhost.ta lkaboutdatabases.com...
Db2 V8.2 on AIX V5.3
Partitioning a table based on the partitioning keys.

You need DB2 ESE with Data Partitioning Feature, and you would have to
recreate the table.

DB2 V9 will support Range Partitioning as part of the standard offering (I
presume).
May 15 '06 #4
We do have DPF available.
So, will I have to create a new table using
'CREATE TABLE tablename ... PARTITIONING KEY (column)' and then import the
data from the previous table?

Thanks for your help.

cheers,
San.

May 15 '06 #5
"shsandeep" <sa**********@gmail.com> wrote in message
news:f4******************************@localhost.ta lkaboutdatabases.com...
We do have DPF available.
So, will I have to create a new table using
'CREATE TABLE tablename ... PARTITIONING KEY (column)' and then import the
data from the previous table?

Thanks for your help.

cheers,
San.


First you need to add database partitions, either on the same physical
machine, or on another machine (in which case you need to install DB2 on the
other machine). See the START DATABASE MANAGER and ADD DBPARTITIONNUM
command.

However, I would not try to create partitioned databases under DPF unless
you have had some training or get some consulting help, or unless you find a
very good book on the subject. DPF is not anything like range partitioning
in Oracle or DB2 for z/OS.
May 15 '06 #6
Mark A wrote:
"shsandeep" <sa**********@gmail.com> wrote in message
news:f4******************************@localhost.ta lkaboutdatabases.com...
We do have DPF available.
So, will I have to create a new table using
'CREATE TABLE tablename ... PARTITIONING KEY (column)' and then import the
data from the previous table?

Thanks for your help.

cheers,
San.

San,

How big is your table? How wide are your rows?
With 32K pagesize you can reach 512GB on 255 rows/page on DB2 V8.2
In DB2 Viper that gets you to 16TB without even looking at any sort of
partitioning.

Cheers
Serge

--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab
May 15 '06 #7

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

5 posts views Thread by sameer_deshpande | last post: by
1 post views Thread by Laurence | last post: by
3 posts views Thread by nbajrach | last post: by
debasisdas
reply views Thread by debasisdas | last post: by
debasisdas
reply views Thread by debasisdas | last post: by
1 post views Thread by Korara | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.