Results 1 to 5 of 5
  1. #1
    Join Date
    Jan 2010
    Posts
    67

    Unanswered: create index in seperate tablespace with different page size

    Hi,

    due to lack of space, is it possible I create table in 8k tablespace and create its index in 4k tablespace? (db2 v7.2)

    Thank you for your help in advance.

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    Yes, if the tablespaces are DMS.


    Andy

  3. #3
    Join Date
    Jan 2010
    Posts
    67
    Yes it is ,

    Thank you Andy

  4. #4
    Join Date
    Nov 2011
    Posts
    87

    Yes.

    Yes, i did this other way around in our system.
    table is in 4k tbs and the indexes are in 8k tbs.
    But you need to create 8k page bufferpool if you dont have one already.

    FYI,
    Due to the small length of the row, i am wasting little bit space in each page.

  5. #5
    Join Date
    Jan 2010
    Posts
    67
    Thank you db2mtrk for your advise

Posting Permissions

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