Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2011

    Unanswered: Creating index - temp space getting full

    db2 9.7 fp 3 /windows 2008

    Hi please advise me.

    I have created two large tablespace one for table and one for index.

    created a table and loaded 500 million rows successfully. Now i am trying to create an index but, the tempspace is getting full all the time.

    the table size is around 55GB.

    The tempspace is database managed system temporary TBS. it has two containers each 60GB (total 120GB).

    How can i resolve this issue please?

  2. #2
    Join Date
    Jul 2013
    Moscow, Russia
    Provided Answers: 55
    Is it possible to use range partitioning with partitioned index for your table?
    If not, you must provide more system temporary space.

    Another option is to use DPF, but ... it's better to choose one of the options specified above firstly...

Posting Permissions

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