var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
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?
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...