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.

On 7 Cze, 09:50, Woody Ling <woodyl...@gmail.com> wrote:
> 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

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 <artur.wronski@gmail.com> writes:

> On 7 Cze, 09:50, Woody Ling <woodyl...@gmail.com> wrote:
>> 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