IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

How to verify Retention of a Vsam dataset


IBM Mainframe Forums -> JCL & VSAM
Post new topic   This topic is locked: you cannot edit posts or make replies.
View previous topic :: View next topic  
Author Message
upendrasri

Active User


Joined: 28 Sep 2017
Posts: 121
Location: India

PostPosted: Sat Jan 26, 2019 5:18 pm
Reply with quote

Hi,

In my environment we have some data sets which will be deleted after 45 days of non usage as per management class.

But even after 45 days few data sets are not deleted and they are not referred or used more than 45days.

As per management class data sets will not be deleted in case if their retention period mentioned more than 45 while created those data sets.

These data sets were created by various application developers.

Is there anyway to know the retention period of a Vsam dataset?

Thanks!
Back to top
View user's profile Send private message
steve-myers

Active Member


Joined: 30 Nov 2013
Posts: 917
Location: The Universe

PostPosted: Sat Jan 26, 2019 8:07 pm
Reply with quote

Retention period is not a data set attribute. The retention period specified in JCL or the IDCAMS DEFINE CLUSTER command is immediately converted to an expiration date that subsequently becomes a data set or cluster attribute.

This cluster does not have an expiration date.
Code:

 LISTCAT ALL ENT(XXXXXX.UCHECK.DB)
CLUSTER ------- XXXXXX.UCHECK.DB
     IN-CAT --- redacted
     HISTORY
       DATASET-OWNER-----(NULL)     CREATION--------2015.197
       RELEASE----------------2     EXPIRATION------0000.000
It is easier to obtain the expiration date for a VSAM cluster than a non-VSAM data set.

As we have no knowledge of the process that is supposed to delete expired VSAM clusters we cannot speculate about the reason these data sets are not being deleted.

This is annoying. Last ref date does not appear to be a VSAM attribute. though you can use the last ref date of the data set component of the data area of the of the data set.
Back to top
View user's profile Send private message
upendrasri

Active User


Joined: 28 Sep 2017
Posts: 121
Location: India

PostPosted: Sun Jan 27, 2019 10:56 pm
Reply with quote

Hi Steve,

Thanks for your clarification. Actually in our environment some of the data sets are not deleted even though their non usage days matching with their Management class

Ex :
Vsam dataset : REPT.PPPP.TST18221
Created on : 2005/03/19
Last referred on : 2018/08/09



Code:

CLUSTER ------- REPT.PPPP.TST18221                 
     IN-CAT --- USER.TEST.CATALOG                                 
     HISTORY                                                         
       DATASET-OWNER-----(NULL)     CREATION--------2005.078         
       RELEASE----------------2     EXPIRATION------0000.000         
     SMSDATA                                                         
       STORAGECLASS ---STANDARD     MANAGEMENTCLASS-TSTFILES         
       DATACLASS ---------KEYED     LBACKUP ---0000.000.0000


TSTFILES Management class attributes as below -


Code:

Expiration Attributes                       
                                           
  Expire after Days Non-usage  . : 35       
  Expire after Date/Days . . . . : NOLIMIT 
  Retention Limit  . . . . . . . : 0   


Dataset suppose to be deleted after 35 days of Non-usage.. But that dint happen..

Any suggestions?

Thanks.
Back to top
View user's profile Send private message
steve-myers

Active Member


Joined: 30 Nov 2013
Posts: 917
Location: The Universe

PostPosted: Sun Jan 27, 2019 10:59 pm
Reply with quote

steve-myers wrote:
...As we have no knowledge of the process that is supposed to delete expired VSAM clusters we cannot speculate about the reason these data sets are not being deleted. ...
Back to top
View user's profile Send private message
expat

Global Moderator


Joined: 14 Mar 2007
Posts: 8797
Location: Welsh Wales

PostPosted: Mon Jan 28, 2019 1:36 pm
Reply with quote

Go see the exact same post that you put into another area of the forum.

This version is locked.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   This topic is locked: you cannot edit posts or make replies. View Bookmarks
All times are GMT + 6 Hours
Forum Index -> JCL & VSAM

 


Similar Topics
Topic Forum Replies
No new posts Access to non cataloged VSAM file JCL & VSAM 18
No new posts FINDREP - Only first record from give... DFSORT/ICETOOL 3
No new posts Map Vols and Problem Dataset All Other Mainframe Topics 2
No new posts Allocated cylinders of a dataset DB2 12
No new posts Sort First/last record of a subset th... DFSORT/ICETOOL 7
Search our Forums:

Back to Top