Auto Reorg

soundharya_s · #1 (**permalink**) 11-19-08, 00:01

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

JAYANTA_DATTA · #2 (**permalink**) 11-19-08, 01:04

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.

soundharya_s · #3 (**permalink**) 11-19-08, 09:24

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.