Results 1 to 4 of 4
  1. #1
    Join Date
    Sep 2002
    Posts
    456

    Arrow Unanswered: Tablespace with partitions and partition key

    Can anybody provide me with an example of how to create a tablespace with 10 partitions. Each partition will contain data for one year only starting from 2002 to 2012. Any example with create tablespace and create table will be greatly appreciated.

    Dollar

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650

    Re: Tablespace with partitions and partition key

    http://www7b.software.ibm.com/dmdd/l...209rielau.html

    http://www7b.software.ibm.com/dmdd/l...202zuzarte.pdf



    Originally posted by dollar489
    Can anybody provide me with an example of how to create a tablespace with 10 partitions. Each partition will contain data for one year only starting from 2002 to 2012. Any example with create tablespace and create table will be greatly appreciated.

    Dollar

  3. #3
    Join Date
    Jan 2002
    Location
    Manila, Philippines
    Posts
    71

    if you're referring to MVS...

    you can not do it with 10 partition since 2002 to 2012 is 11 years inclusive.

    ***partitioned table space
    Create Tablespace xxx Numparts 11 ...

    ***TEMP table
    Create Table TEMP (...,Year Int,...) in xxx ...

    ***partitioning index
    Create Index yyy on TEMP (Year) Cluster (Part 1 Values (2002), ... Part 11 Values (2012))....

    *******************************

    Partitioning using UNION ALL in DB2V8 is very interesting. Thanks Sathyaram_S !!!

    Regards,
    Oliver

  4. #4
    Join Date
    Sep 2002
    Posts
    456

    Arrow Tablespace

    Thanks Sathyaram and Oliver.

Posting Permissions

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