Results 1 to 4 of 4
  1. #1
    Join Date
    Jun 2004
    Posts
    12

    Unanswered: creating tablespace to store large table

    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

  2. #2
    Join Date
    Nov 2004
    Posts
    374

    create tablespace for large table

    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

  3. #3
    Join Date
    Jun 2004
    Posts
    12

    ok then

    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

  4. #4
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    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
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •