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
 

 

Few queries with GDGs here

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

Active User


Joined: 25 Apr 2007
Posts: 205
Location: Bangalore

PostPosted: Fri Aug 10, 2007 2:56 pm    Post subject: Few queries with GDGs here
Reply with quote

Few queries with GDGs here:

1. I want to know whether EMPTY uncatalogues all the previous generations including current one or all the generations excluding current when limit is exceeded.

2. I had specified EMPTY NOSCRATCH LIMIT(2). After adding third generation, when i did 3.4, i found it showing all the 3 generations still catalogued whereas actually it should be showing latest 2 only.
I ran pgm=IEHLIST with LISTVTOC Option for the first Generation G0001V00. I found it residing on SMS managed volume.
In SMS case, what is the purpose of LIMIT when still all the datasets are catalogued?


That is my doubt?

Thanks
Ajay
Back to top
View user's profile Send private message

expat

Global Moderator


Joined: 14 Mar 2007
Posts: 8593
Location: Back in jolly old England

PostPosted: Fri Aug 10, 2007 4:48 pm    Post subject:
Reply with quote

It may be the combination of NOSCRATCH and EMPTY.

What status is G0001V00 from LISTCAT
Back to top
View user's profile Send private message
stodolas

Active Member


Joined: 13 Jun 2007
Posts: 632
Location: Wisconsin

PostPosted: Fri Aug 10, 2007 5:02 pm    Post subject:
Reply with quote

The first generation will roll off, it just doesn't happen right away. Check back the next day. I have noticed at my shop the GDGs all start to roll out at a certain time of day.
Back to top
View user's profile Send private message
Ajay Baghel

Active User


Joined: 25 Apr 2007
Posts: 205
Location: Bangalore

PostPosted: Fri Aug 10, 2007 5:59 pm    Post subject: Re: Few queries with GDGs here
Reply with quote

I got the answer here. I had specified EMPTY NOSCRATCH LIMIT(2) while defining GDG Base catalog.

After adding two generations I do LISTCAT for first and second generation.
The sysprint shows - STATUS------------ACTIVE

Code:

//IEHL01   EXEC PGM=IDCAMS                           
//SYSPRINT DD   SYSOUT=*                             
//SYSOUT   DD   SYSOUT=*                             
//SYSIN    DD   *                                   
  LISTCAT  ENTRIES( UPR4.TEST.GDG.G0001V00 ) ALL     
/*       


Now I add third generation and then do a LISTCAT for all 3 generations one by one. Though i still can see all the 3 generations in 3.4 dslist option panel.

Running LISTCAT again first and second generations gives me :
STATUS--------ROLLED-OFF

While against 3rd it is STATUS------------ACTIVE .

So, conclusion is : when limit exceeds, EMPTY causes all the generations ( whichever were present there prior to the offending generation was added) are rolled off i.e uncatalogued. However NOSCRATCH avoids getting them deleted.

Thanks everyone for your help,
Ajay
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 How to make REXX process different GDGs? venksiv CLIST & REXX 15 Thu Sep 24, 2015 5:35 pm
No new posts Running queries against OLTP Database A_programmers DB2 3 Tue Jul 14, 2015 4:51 pm
No new posts Selective execution of a queries Delip DB2 9 Fri Jan 16, 2015 3:51 pm
No new posts Re-write queries to minimize the effe... Anil Khanna DB2 6 Mon Aug 04, 2014 1:49 pm
No new posts Running multiple queries in a PS file... nikhil_bansal04 JCL & VSAM 12 Wed Dec 18, 2013 12:06 pm


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