Hi,

Is there anyone out there who can give me an example of how to create a partitioned tablespace so I can store a table of size > 64GB? From all of the reading I've done, that's what needs to be done, but I can't find any examples.

A few issues:

a) Do I have to create a container of pre-allocated size?
b) What parameters do I have to worry about (i.e. DSSIZE, LARGE, NUMPARTS...)

Thanks very much.

VX

creating a partitioned database is not as simple as 123
you have to modify the db2nodes.cfg
this will create a second instance on the same or different machine
you have to define a partition node group over these instances
create the tablespace in this group and reload the data
if needed define a partitioning key
Have a look at admin guide (or have some search on eee as it was called)
on db2 developer work site
Best Regards, Guy Przytula

Ok then, in terms of simplicity, would it be easier to define a new tablespace with a pagesize of 32KB instead of 4KB? This would allow me to store 512GB in the table instead of 64GB, right?

Can someone confirm that for me?

Thanks,

VX

I think the original poster is talking about OS/390 which is vastly different than DB2 for LUW with regard to partitioned tablespaces.

Here are the size limits (per partition) for partitioned tablespaces in DB2 for OS/390:

For table spaces that are not defined with LARGE or a DSSIZE greater than 2G:
- 4 gigabytes, for 1 to 16 partitions
- 2 gigabytes, for 17 to 32 partitions
- 1 gigabyte, for 33 to 64 partitions

For table spaces that are defined with LARGE:
- 4 gigabytes, for 1 to 254 partitions

For table spaces that are defined with a DSSIZE greater than 2G:
- 64 gigabytes, for 1 to 254 partitions