Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2008
    Location
    Chennai
    Posts
    111

    Unanswered: db2 9.7 FP3a / win 2008 R2 - large TBS

    Hello,
    I just migrated the db2 8.2 to 9.7. FP3a
    One of my tablespace which contains ONLY INDEXES. It is a 4K page regular TBS. But it used nearly 16 million pages. (almost full).

    Now, I have converted to LARGE. Then added more pages to the containers.
    Then did the INDEX REORG. The REORG was successfull, but it put the HWM over 22million pages (before 15million pages).

    As this TBS was created using v8.2 I can not reduce the HWM, without recreating the TBS.

    So, I restored the database again with and converted to large again.
    This time I did the TABLE REORG and all the INDEXES were rebuilt (according to the diag.log) during the TABLE REORG. But the HWM did not changed. still same value (15million pages).

    Can some one give me some advise on this please.
    Can I leave this as it is? or do I need to do anything else?
    How can I check that this indexes will use the 6bit RID?

    Please remember, this TBS contain only INDEXES (No tables).

    Please advise.
    Thanks.

  2. #2
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified
    http://www.infocura.be

  3. #3
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,367
    Check large_rids and large_slots here:
    IBM DB2 9.7 for Linux, UNIX and Windows Information Center

Posting Permissions

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