Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Jobs coded with KEEPDICTIONARY option

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
gylbharat

Active Member


Joined: 31 Jul 2009
Posts: 565
Location: Bangalore

PostPosted: Fri Aug 19, 2011 11:36 am    Post subject: Jobs coded with KEEPDICTIONARY option
Reply with quote

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?
Back to top
View user's profile Send private message

gylbharat

Active Member


Joined: 31 Jul 2009
Posts: 565
Location: Bangalore

PostPosted: Mon Aug 22, 2011 10:18 am    Post subject:
Reply with quote

does anybody has any idea on this?
Back to top
View user's profile Send private message
sushanth bobby

Senior Member


Joined: 29 Jul 2008
Posts: 1013
Location: India

PostPosted: Mon Aug 22, 2011 1:36 pm    Post subject:
Reply with quote

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

Thanks,
Sushanth
Back to top
View user's profile Send private message
gylbharat

Active Member


Joined: 31 Jul 2009
Posts: 565
Location: Bangalore

PostPosted: Mon Aug 22, 2011 6:28 pm    Post subject:
Reply with quote

Thanks for the reply... but i think its an important information and it should be stored somewhere in the DB2.
Back to top
View user's profile Send private message
dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6966
Location: porcelain throne

PostPosted: Mon Aug 22, 2011 7:17 pm    Post subject:
Reply with quote

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.
Back to top
View user's profile Send private message
Robert Sample

Global Moderator


Joined: 06 Jun 2008
Posts: 7931
Location: Bellevue, IA

PostPosted: Mon Aug 22, 2011 7:21 pm    Post subject:
Reply with quote

Quote:
but i think its an important information and it should be stored somewhere in the DB2.
Unless you work for the DB2 development team at IBM, I suspect what you think should be done probably won't matter very much to IBM.
Back to top
View user's profile Send private message
sushanth bobby

Senior Member


Joined: 29 Jul 2008
Posts: 1013
Location: India

PostPosted: Tue Aug 23, 2011 2:00 pm    Post subject:
Reply with quote

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
Back to top
View user's profile Send private message
gylbharat

Active Member


Joined: 31 Jul 2009
Posts: 565
Location: Bangalore

PostPosted: Tue Aug 23, 2011 2:10 pm    Post subject:
Reply with quote

Ok... Thanks Sushanth....
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts BWO option in VSAM blayek CICS 3 Sat Nov 05, 2016 10:47 am
No new posts Regarding COBOL Stored Procedure opti... selvamsrinivasan85 DB2 4 Fri Nov 04, 2016 8:57 pm
No new posts Syncsort - Hard coded Value in output PORYES SYNCSORT 1 Thu Nov 03, 2016 9:23 am
No new posts How to show message using batch jobs madprasy TSO/ISPF 7 Fri Sep 09, 2016 6:55 pm
No new posts Don't allow CICS to submit batch jobs prino JCL & VSAM 5 Mon Jul 25, 2016 3:26 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us