Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2006
    Location
    Columbus, OH
    Posts
    69

    Unanswered: Reorg performance on large table

    DB2 8.2 Fp7
    Linux 2.4

    I have a large table (30 million rows) which the application is constantly reading and writing to. I need to be able to Reorg it, unfortunately it seems like it is taking forever. I even tried an offline reorg and it took hours to complete and not even sure if it did complete. I'm looking for advice, tuning, strategy for maintainance of a table of this size.


    Thanks,

    Charlie

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    You either need at least of much free space in the same tablespace as is being used in the table to be reorged, or specify that a system temporary tablespace be used in the reorg (with plenty of space available).

    You should really get off of FP7 and install FP14. FP7 is the first release of 8.2 and has more bugs than an ant farm.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

Posting Permissions

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