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
 

 

if Meets the limit of GDG , transfer the oldest one

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM
View previous topic :: :: View next topic  
Author Message
shanth555

New User


Joined: 17 Aug 2012
Posts: 35
Location: India

PostPosted: Thu May 09, 2013 12:30 pm    Post subject: if Meets the limit of GDG , transfer the oldest one
Reply with quote

Hi All,

I have a base file and it contains 14 GDG versions. The GDG versions are creating daily basis, since the limit is 14 we are losing the before 14 days files.

Note: i dont want to increase the GDG limt.

Whenever the JCL runs, it needs check the GDG limit. if its 14 we need to NDM the oldest file ( Means the first file in GDG) to DB.

Is there any way to check the GDG limit in JCL?

i would be thankful for your help.

Regards,
Iniyavan
Back to top
View user's profile Send private message

Gnanas N

Active Member


Joined: 06 Sep 2007
Posts: 785
Location: Chennai, India

PostPosted: Thu May 09, 2013 12:42 pm    Post subject:
Reply with quote

GDG Generations Vs Versions?

Ok. IDCAMS LISTCAT on GDG Base.
Back to top
View user's profile Send private message
Gnanas N

Active Member


Joined: 06 Sep 2007
Posts: 785
Location: Chennai, India

PostPosted: Thu May 09, 2013 1:03 pm    Post subject:
Reply with quote

Again, if GDG base's LIMIT is 14, LIMIT from LISTCAT is always 14 only.

You may need to check ASSOCIATIONS information from LISTCAT listing, to know the number of active generations as well as the oldest generation DS name.
Back to top
View user's profile Send private message
enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10202
Location: italy

PostPosted: Thu May 09, 2013 1:11 pm    Post subject: Reply to: if Meets the limit of GDG , transfer the oldest on
Reply with quote

I wonder why people like to make things more difficult that they should be.

for what reason You don' t just NDM the file as soon as it is created and let the older generations vaporize at rolloff time ???
Back to top
View user's profile Send private message
Anuj Dhawan

Senior Member


Joined: 22 Apr 2006
Posts: 6258
Location: Mumbai, India

PostPosted: Thu May 09, 2013 1:55 pm    Post subject: Re: Reply to: if Meets the limit of GDG , transfer the oldes
Reply with quote

enrico-sorichetti wrote:
I wonder why people like to make things more difficult that they should be.

for what reason You don' t just NDM the file as soon as it is created and let the older generations vaporize at rolloff time ???
Thinking is a tough business business under the sun, perhaps, that's why very few people indulge in it.

shanth555 - The idea from Enrico seems best for what you've described.
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Thu May 09, 2013 7:51 pm    Post subject:
Reply with quote

Hello,

Your process sounds like it will be problematic.

If the process runs one day and there are 14 generations the oldest would be "sent". If the process is run the next day and nothing has changed, the oldest will be sent again. Is this ok? What is to prevent this?

Why is the data not sent until it is the oldest?

I do not understand what this is to accomplish. The places i support typically want the most current info in the database. They do not want it to "age" before loading.

Possibly i am missing something.
Back to top
View user's profile Send private message
enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10202
Location: italy

PostPosted: Thu May 09, 2013 8:05 pm    Post subject: Reply to: if Meets the limit of GDG , transfer the oldest on
Reply with quote

even if the approach is clumsy I guess that the TS wants
( before the rest of the <procedure> runs )

<RUN WHATEVER PROCESS> on the <gdg_base_name>(-13) if it exists
Back to top
View user's profile Send private message
Ed Goodman

Active Member


Joined: 08 Jun 2011
Posts: 556
Location: USA

PostPosted: Mon May 13, 2013 7:39 pm    Post subject:
Reply with quote

You could listcat the gdg, then strip the names from that result. Run that through another listcat with a count(14). Based on that result, run the NDM with the -13.

I would add a step to delete the -13 so that you don't end the same one multiple times.

Not the craziest requirement I've ever heard.
Back to top
View user's profile Send private message
Anuj Dhawan

Senior Member


Joined: 22 Apr 2006
Posts: 6258
Location: Mumbai, India

PostPosted: Mon May 13, 2013 9:05 pm    Post subject:
Reply with quote

But still crazy though not craziest ! icon_smile.gif
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 -> JCL & VSAM All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Limit duplicate records in the SORT pshongal SYNCSORT 6 Mon Nov 21, 2016 12:54 pm
No new posts Commit limit for Delete query through... mf_karthik DB2 10 Thu Dec 17, 2015 12:56 am
No new posts How to transfer file password protect... chetanambi TSO/ISPF 8 Thu Apr 30, 2015 10:05 am
No new posts Array overflow on Internal table - An... scdinesh COBOL Programming 13 Thu May 22, 2014 2:55 am
No new posts Using FTP Pro to transfer files to ma... Jay Villaverde TSO/ISPF 1 Thu May 01, 2014 8:05 pm


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