Jobs coded with KEEPDICTIONARY option

gylbharat · Posted: Fri Aug 19, 2011 11:36 am

Hi,

We have most of the reorg jobs coded with KEEPDICTIONARY option. But now due to change in data we see that compression percentage is not that good.

Is there any catalog table where I can check - When the last compression dictionary was build for that table?

gylbharat · Posted: Mon Aug 22, 2011 10:18 am

does anybody has any idea on this?

sushanth bobby · Posted: Mon Aug 22, 2011 1:36 pm

I don't think there is a table with this information.

Thanks,
Sushanth

gylbharat · Posted: Mon Aug 22, 2011 6:28 pm

Thanks for the reply... but i think its an important information and it should be stored somewhere in the DB2.

dbzTHEdinosauer · Posted: Mon Aug 22, 2011 7:17 pm

lot of stuff on the web (google KEEPDICTIONARY DB2)
about this subject.

it appears that you need to know abit more about your db2 version, etc...
before you start making decisions based on some entry that may or maynot be in the catelog tables.

Robert Sample · Posted: Mon Aug 22, 2011 7:21 pm

sushanth bobby · Posted: Tue Aug 23, 2011 2:00 pm

Gylbharat,

Other ways of knowing the answer,
You can ask your seniors, why KEEPDICTIONARY was put and when it was changed. That's easy way of doing it.

If you have endevor, check it in there, when the JCL/PARM was changed.

Or just go to that library and see when the JCL/PARM was changed, this point is not an effective answer, but can be added as a last option.

Thanks,
Sushanth

gylbharat · Posted: Tue Aug 23, 2011 2:10 pm

Ok... Thanks Sushanth....