Results 1 to 5 of 5

Thread: Auto Reorg

  1. #1
    Join Date
    May 2002
    Posts
    30

    Unanswered: Auto Reorg

    DB2 9.5 FP2 Windows 2003

    Getting the following error in db2diag when auto reorg is enabled on the db.


    2008-11-10-14.08.09.444000+240 I1963318H360 LEVEL: Warning
    PID : 9112 TID : 11708 PROC : db2fmp.exe
    INSTANCE: db2 NODE : 000
    APPID : *LOCAL.db2.081118004410
    EDUID : 11708
    FUNCTION: DB2 UDB, Policy, sqlpiGetReorg, probe:20
    DATA #1 : String, 47 bytes
    Warning: Unable to read reorg policy. Error: -1


    Anyone come across this?

    Thanks
    Soundh

  2. #2
    Join Date
    Oct 2004
    Location
    DELHI INDIA
    Posts
    338
    I hope you ensured the following:

    AUTO_MAINT, AUTO_TBL_MAINT and AUTO_REORG parameters must all have a value of ON.

    Any other observation you have apart from the Diag.log Warning? Was it working fine earlier in your test environment? Or you are getting the error first time during the time of implementing it.

  3. #3
    Join Date
    May 2002
    Posts
    30
    Thanks Jayanta.
    This is the first time I am trying out auto configs. Yes, the parameters are set.


    Quote Originally Posted by JAYANTA_DATTA
    I hope you ensured the following:

    AUTO_MAINT, AUTO_TBL_MAINT and AUTO_REORG parameters must all have a value of ON.

    Any other observation you have apart from the Diag.log Warning? Was it working fine earlier in your test environment? Or you are getting the error first time during the time of implementing it.

  4. #4
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Chances are the automatic maintenance configuration became corrupted. You may want to try running the automatic maintenance wizard again.
    ---
    "It does not work" is not a valid problem statement.

  5. #5
    Join Date
    Oct 2011
    Posts
    1
    This appears to be a known bug affecting versions lower than Fix Pack 5.
    Check here for more info and to get the fix:
    IBM JR31934

Posting Permissions

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