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

data set reference date of greater than the specified days


IBM Mainframe Forums -> JCL & VSAM
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
dineshm123

New User


Joined: 19 Feb 2009
Posts: 4
Location: india

PostPosted: Tue Feb 24, 2009 11:30 am
Reply with quote

I want to have a list of datasets which have reference date of greater than the specified days.

Suppose data set TTT.A000X00.ONE creation date is 2002/04/01 and last referenced date is 2009/02/20
data set TTT.A000X00.TWO creation date is 2002/04/01 and last referenced date is 2002/04/01
and few more..

I got the list of datasets whose creation date is greater than the specified no of days by the following

//LISTCAT EXEC PGM=IDCAMS
//SYSOUT DD SYSOUT=*
//SYSPRINT DD DSN=TTT.DUMMY.OUTPUT,
// DISP=(NEW,CATLG,DELETE),
// DCB=(DSORG=PS,BLKSIZE=23476,LRECL=125,RECFM=VBA),
// UNIT=DISK,SPACE=(TRK,(01,01),RLSE)
//SYSIN DD *
LISTCAT LEVEL(TTT.A000X00) CREATION(0090)
/*

Running the above, I got answer for creation date, which is both of the above 2 files.
I want to have a list of datasets which have reference date of greater than the specified days by using IDCAMS if possible. i.e. I want only TTT.A000X00.TWO to be appearing in the output file since it has been last referenced more than 90 days.
Back to top
View user's profile Send private message
expat

Global Moderator


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

PostPosted: Tue Feb 24, 2009 12:37 pm
Reply with quote

With IDCAMS, not possible.

Look at DFdss, of the ISMF option from whereever it is on your ISPF main menu.
Back to top
View user's profile Send private message
dineshm123

New User


Joined: 19 Feb 2009
Posts: 4
Location: india

PostPosted: Tue Feb 24, 2009 1:45 pm
Reply with quote

Thanks! can we do this in a jcl only without IDCAMS?
Back to top
View user's profile Send private message
enrico-sorichetti

Superior Member


Joined: 14 Mar 2007
Posts: 10873
Location: italy

PostPosted: Tue Feb 24, 2009 4:52 pm
Reply with quote

Quote:
Thanks! can we do this in a jcl only without IDCAMS?


please review Your understanding of zOS job flow

jcl does nothing nothing nothing,
to achieve any useful result You must execute something,
IDCAMS, DFDSS, IKJEFT01 with batch ISMF commands
are samples of programs that will list datasets according to some criteria

jcl alone will not do it
Back to top
View user's profile Send private message
rahulbank

New User


Joined: 25 Sep 2008
Posts: 66
Location: Bengaluruuuuuu

PostPosted: Fri Jun 12, 2009 3:04 pm
Reply with quote

Hi,

I am having the same reqt. too(to find giles having last ref. date greater than 180 days and having a particular mgmt class).
I however achieved the result first using SAS. Now I am trying to see if there is any other option as my managers feel that the VSAM may be giving wrong results for VSAM last referenced date.
Back to top
View user's profile Send private message
dbzTHEdinosauer

Global Moderator


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

PostPosted: Fri Jun 12, 2009 3:19 pm
Reply with quote

Quote:
that the VSAM may be giving wrong results for VSAM last referenced date


what date do they want you to use? maybe they realize that a reorg might modify the date.

of course you can scan SMF,
if the type of records are generated
which contain the info necessary
to make a decision of whether they are 'really referenced'.
Back to top
View user's profile Send private message
rahulbank

New User


Joined: 25 Sep 2008
Posts: 66
Location: Bengaluruuuuuu

PostPosted: Fri Jun 12, 2009 3:26 pm
Reply with quote

Thanks for the response.

what date do they want you to use? maybe they realize that a reorg might modify the date.


Its not like what date they want me to use, they just want me to cross check my findings from what I generated in SAS with some other methodology.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> JCL & VSAM

 


Similar Topics
Topic Forum Replies
No new posts How to save SYSLOG as text data via P... All Other Mainframe Topics 1
No new posts Replacing 'YYMMDD' with date, varying... SYNCSORT 3
No new posts Store the data for fixed length COBOL Programming 1
No new posts Modifying Date Format Using DFSORT DFSORT/ICETOOL 9
No new posts Data set Rec-Cnt and Byte-Cnt Testing & Performance 2
Search our Forums:

Back to Top