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
 

 

data set reference date of greater than the specified days

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM
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    Post subject: data set reference date of greater than the specified days
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: 8593
Location: Back in jolly old England

PostPosted: Tue Feb 24, 2009 12:37 pm    Post subject:
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    Post subject: Reply to: data set reference date of greater than the specif
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

Global Moderator


Joined: 14 Mar 2007
Posts: 10274
Location: italy

PostPosted: Tue Feb 24, 2009 4:52 pm    Post subject: Reply to: data set reference date of greater than the specif
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    Post subject: I have the same reqt too.
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: 6968
Location: porcelain throne

PostPosted: Fri Jun 12, 2009 3:19 pm    Post subject:
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    Post subject:
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    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 copying data without knowing location arunsoods DFSORT/ICETOOL 6 Thu Jul 20, 2017 1:03 pm
This topic is locked: you cannot edit posts or make replies. Fetching data from BAI File arunsoods JCL & VSAM 1 Wed Jul 19, 2017 4:28 pm
No new posts Loading data to table gives wrong for... Raghu navaikulam DB2 18 Thu Jul 13, 2017 2:11 pm
No new posts How to add header with Date(YYMMDD) i... Rajan Moorthy DFSORT/ICETOOL 2 Thu Jul 06, 2017 11:44 pm
No new posts StreamWeaver language reference chetanambi Compuware & Other Tools 1 Wed Jul 05, 2017 12:50 pm


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