Hi,
DB2 UDB V8.2 with FP 9 on AIX5.1
---------------------------------

Hi,
We have a critical requirement. We have a tablespace TS_DAT1. The current size of the TS is 490 GB.
Now we have to add some indexes to some existing TABLES. After calculating I found out the total size of the all the Indexes will be more than 20 GB.

As the Maximum allowable SIZE of a TS is 512 GB, we are in soup what should we do know. As there is no options to Add these new INDEXES to a Newly created TABLESPACE.

Please Suggest...

Jay

You need to create a tablespaces with a larger page size and then move the table to the new tablespace (maybe this time with a separate tablespace for the indexes).

You can run stats in sharemode and do a reorgchk to see if you can gain a lot of free pages by REORGing. Better solution is to MOVE the tables as suggested. Using db2look , you can create a destination table(DT) in another tablespace; export data in del format from source table(ST) and load the data to DT; after checking you can delete ST and rename DT to ST ; you have to rebind,reGRANT etc.While you are CREATING the DT(and only then), you can specify an alternate tablespace for indexes on the table.

Thanks guys,

I will create a the table on a New TS and and Index on a different TS.
We do periodic REORG..

Thx,
jayanta