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

    Arrow Unanswered: Tablespace Partition - Again!!!!!

    Guys thanks for the previous replies BUT:

    Let's say my primary key/index is made up of three different columns year, id, effective_date and I want to create a partition tablespace storing data according to year only.

    Do I have to create another index on top of mandatory one already needed to implement tablespace partition concept. My question; can be specify multiple columns as part of partition condition or how it works.

    Note: I am runing OS390 v7.1

    Dollar

  2. #2
    Join Date
    Feb 2002
    Location
    Germany
    Posts
    141

    Re: Tablespace Partition - Again!!!!!

    For OS390, you must define a cluster index with ALL columns that you want for partitioning your table. In this case, you'll have your primary key as NPI (non partitioned index) and you need to define another index for the partitions.

    HTH
    Rodney Krick

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

    see if this answers your question

    "Do I have to create another index on top of mandatory one already needed to implement tablespace partition concept"

    -- you can not create another partition index on top of the 'mandatory', you need to drop the table space and recreate everything, but this time create a partition index for the column that you need partitioned.


    "can be specify multiple columns as part of partition condition or how it works"

    -- yes, Create Index SAMPLEIDX on TEMP (COL1, COL2...) Cluster (Part 1 Values (value1, value2).....) ....

    HTH,
    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
  •