Query in GDG to delete the first 199 versions

nithivenkat · New User Joined: 15 Sep 2008 Posts: 22 Location: Mumbai

Hi All,

I have a GDG with 200 versions. There is a requirement in my project to delete the first 199 versions and to retain only the latest version. Kindly let me know the command to delete all the versions and to retain only the latest version alone.

Thanks in advance!

dick scherrer · Posted: Tue Feb 10, 2009 8:44 am

Hello,

Generations not versions. . .

There is no such command. . .

You could copy the one generation you want to keep to some other dataset name, delete all of the cataloged generations (that can be done with one dd statement), then copy the saved generation back to the proper dataset name.

I've never tried to rename a dataset into a gdg, so i'd use copy . . .

nithivenkat · New User Joined: 15 Sep 2008 Posts: 22 Location: Mumbai

Hi Dick,

Can you pls let me know how delete all the cataloged generations with one dd statement.

Thanks.

dick scherrer · Posted: Tue Feb 10, 2009 9:06 am

Hello,

You could use

nithivenkat · New User Joined: 15 Sep 2008 Posts: 22 Location: Mumbai

Hi Dick,

Just one more doubt,,

Should I mention the base name in the DSN parameter or any generation?

abhishek dadhichi · New User Joined: 19 Apr 2007 Posts: 37 Location: Bangalore

Hi nithivenkat,

Yes..according to the code given by Dick..the DSN parameter should have the GDG base name ,that's what is specified in his code 'the.gdg'.

Thanks,
Abhishek

gcicchet · Posted: Tue Feb 10, 2009 9:28 am

Hi Dick,

if any are migrated, they will be recalled, it might be best to use IDCAMS,
or alternatively change the limit to 1, this will roll off and delete all except the lastest GDG.

Gerry

dick scherrer · Posted: Tue Feb 10, 2009 10:04 am

Hi Gerry,

nithivenkat · New User Joined: 15 Sep 2008 Posts: 22 Location: Mumbai

Hi gcicchet,

Pls let me know how to set the limit to 1 using IDCAMS.

Thanks.

gcicchet · Posted: Tue Feb 10, 2009 1:56 pm

Hi,

here is an example

nithivenkat · New User Joined: 15 Sep 2008 Posts: 22 Location: Mumbai

Thank you Dick and gcicchet

Anuj Dhawan · Posted: Tue Feb 10, 2009 4:30 pm

I wonder what about the data in those 199 generations once limit is set to 1?

Gnanas N · Posted: Tue Feb 10, 2009 4:43 pm

Those 199 generations would be recataloged or uncataloged or deleted...

Anuj Dhawan · Posted: Tue Feb 10, 2009 5:06 pm

Hi Gnanas,

Gnanas N · Posted: Tue Feb 10, 2009 5:12 pm

Yes, Anuj!

expat · Posted: Tue Feb 10, 2009 5:16 pm

Anuj Dhawan · Posted: Tue Feb 10, 2009 5:36 pm

Well, my concern was - were those GDGs never needed? is it a production scenario? why did not they had a simple QSAM DSN instead of choosing GDGs at first place then? What benefit would they get "rolling" the GDGs on a later date..?