Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist 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: 8657
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: 10457
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: 6970
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 3270 Data stream error Benchwarmer CICS 6 Tue Apr 17, 2018 12:06 am
No new posts How to list data set names with diffe... murali.andaluri CLIST & REXX 8 Thu Apr 12, 2018 11:33 pm
No new posts Extract the records with a PD field's... sudhakar84 DFSORT/ICETOOL 11 Mon Apr 02, 2018 7:26 pm
No new posts Invalid XML character while producing... nikhil.bhole IBM Tools 4 Tue Mar 20, 2018 1:24 am
No new posts Get the list of data sets on DASD and... rakaitn JCL & VSAM 3 Thu Mar 08, 2018 12:38 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us