Results 1 to 5 of 5

Thread: DB2 Reorg / HWM

  1. #1
    Join Date
    Nov 2011
    Posts
    87

    Unanswered: DB2 Reorg / HWM

    Hi,
    DB2 9.7 fp 3a /Win 2008 R2

    I have two tablespaces TBS1 and TBS2. TBS1 contain only tables and TBS2 contain only Indexes for the TBS1 tables.

    I want to reorg one big table (around 40GB). If I do the offline TABLE reorg using TEMP, the HWM of the TBS2 will be effected ?

    What is the best way to reorg this table without effecting any HWM?

    Thanks.

  2. #2
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,367
    As far as I know:

    HWM can go up (or down) during offline table reorg if TEMP is not used. When TEMP is used, TBS1's HWM should not be affected. When indexes are rebuilt, db2 will use TEMP (if needed). So, TBS2's HWM should not be affected during index rebuild.

  3. #3
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    If the tablespace was created in 9.7, HWM can be lowered, so it is not a big issue. If created before 9.7, even if db is upgraded to 9.7, then you may have to worry about HWM.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  4. #4
    Join Date
    Nov 2011
    Posts
    87
    Thanks for your comments.
    Marcus, I migrated the db from v8.2. So the TBS was not created in v9.7.
    I am thinking to create new TBS and move all the tables/indexes. But its a big job as we have very limited maintenance time.

    The perticular table in a REGULAR TBS but the INDEXES are in LARGE TBS.
    When I reorg using TEMP, the TEMP TBS should be LARGE or REGULAR or it doesnt matter?

    Thanks

  5. #5
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,367
    Quote Originally Posted by db2mtrk View Post
    When I reorg using TEMP, the TEMP TBS should be LARGE or REGULAR or it doesnt matter?
    I believe LARGE is only for permanent data and DMS.

Posting Permissions

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