Results 1 to 4 of 4
  1. #1
    Join Date
    May 2002
    Posts
    43

    Unanswered: Slow Create Index

    When I drop and recreate a 4Gig index, it is taking forever.

    I see low read I/O from the Data Tablespace Disk and low I/O to the Temp Tablespace Disk.

    I am running UDB 7.2 on a AIX server.

    If the Indexes are smaller then 2 Gig, it flies through... I am guessing there is a tunable parm that I may be able to increase to help...

    Any suggestions??????

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    Your tablespace for the index should be more than twice the size of the index to allow for sorting during the create index operation.
    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
    Nov 2002
    Location
    Delaware
    Posts
    186
    also make sure that your util_heap_sz is large enough, and if you can turn parallelism on, you can really speed it up even more.
    David Quigley

  4. #4
    Join Date
    Sep 2003
    Posts
    237
    SORTHEAP(database config) and indirectly SHEAPTHRES(db mgr config which limits SORTHEAP) have a direct bearing on sorting the indexes; bigger the SORTHEAP, bigger the chains during the SORT, and fewer I/O's to the disk(TEMPSPACE). TEMPSPACe should be on the fastest disk; local rather than a STORAGE system;no raid-5 etc;
    mota

Posting Permissions

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