Results 1 to 5 of 5
  1. #1
    Join Date
    Mar 2005
    Posts
    108

    Unanswered: DB2 V9 bug - REORG pending?

    Hi All,
    I am using "DB2 v9.1.0.2" in a development environemnt. Ever since we migrated to V9, I have seen tables in REORG pending frequently. I am not talking about issues related to "Reorg recommended" ALTER statements. Sometime changing a column from VARCHAR(5) to VARCHAR(10) can cause REORG pending. Sometimes it occurs without any DDL change.

    Does anybod have the same experience? Is this a known bug of DB2 V9?

    Thanks for you advice.

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Do you have automatic maintenance enabled?
    ---
    "It does not work" is not a valid problem statement.

  3. #3
    Join Date
    Mar 2005
    Posts
    108
    AUTO_MAINT = ON
    AUTO_TBL_MAINT = OFF

    Did you imply I needed to turn it on?

  4. #4
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    If it were enabled it could explain the situation. By the way,
    changing a column from VARCHAR(5) to VARCHAR(10)
    _is_ a "Reorg recommended" ALTER statement, so no surprise here.
    Last edited by n_i; 10-22-08 at 13:13.
    ---
    "It does not work" is not a valid problem statement.

  5. #5
    Join Date
    Jan 2003
    Posts
    1,605
    @n_i, you are correct. After altering column it is recommended to execute reorg because of performance benefits. DB2 places new data related to "altering column" to the end of pages. Not the best thing if huge number of rows are in table.

    @DBA-Jr, try to reorg table. Has problem disappeared?

Posting Permissions

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