Maximum size of table is 512G??

[Woody Ling]

I am now using db2 v8.2 64bits without DPF. I want to create a very
large table which is about 1000G and the record length is suitable for
32K page size. I find in the manual that the maximum size for 32K page
size container is 512G only. Does it mean that the maximum size for 1
tablespace is also limited by 512G or I can create a tablespace with 2
containers (512G each) to support 1000G table? Thanks.

[Artur]

On 7 Cze, 09:50, Woody Ling <[e-mail]:

I am now using db2 v8.2 64bits without DPF. I want to create a very
large table which is about 1000G and the record length is suitable for
32K page size. I find in the manual that the maximum size for 32K page
size container is 512G only. Does it mean that the maximum size for 1
tablespace is also limited by 512G or I can create a tablespace with 2
containers (512G each) to support 1000G table? Thanks.

With version 8 the maximum size for a non partitioned tablespace is
512 G.

You have 2 options:

1. Create tablespace which spans multiple DPF partitions -- is that
case maximum size is: 512 G multiplied by number of partitions, or

2. Use version 9 and Large tablespaces (the default in version 9) --
for 32 K page the max size is 16 T

-- Artur Wronski

[Haider Rizvi]

A 3rd option (workaround) is to partition the data on some column
easily partitionable (such as date), and then create a union all view
on top. Each of the sub-tables should be in separate tablespaces and
therefore could go over the 512GB limit.

Artur <ar***********@gmail.comwrites:

On 7 Cze, 09:50, Woody Ling <[e-mail]:

>I am now using db2 v8.2 64bits without DPF. I want to create a
very large table which is about 1000G and the record length is
suitable for 32K page size. I find in the manual that the
maximum size for 32K page size container is 512G only. Does it
mean that the maximum size for 1 tablespace is also limited by
512G or I can create a tablespace with 2 containers (512G each)
to support 1000G table? Thanks.

With version 8 the maximum size for a non partitioned tablespace
is 512 G.

You have 2 options:

1. Create tablespace which spans multiple DPF partitions -- is
that case maximum size is: 512 G multiplied by number of
partitions, or

2. Use version 9 and Large tablespaces (the default in version 9)
-- for 32 K page the max size is 16 T

-- Artur Wronski

--
Haider