Results 1 to 4 of 4
  1. #1
    Join Date
    Oct 2004
    Location
    DELHI INDIA
    Posts
    338

    Unanswered: Adding an Index to a TS with Size 490 GB

    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

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    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).
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  3. #3
    Join Date
    Sep 2003
    Posts
    237
    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.
    mota

  4. #4
    Join Date
    Oct 2004
    Location
    DELHI INDIA
    Posts
    338
    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

Posting Permissions

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