View previous topic :: View next topic
|
Author |
Message |
dineshm123
New User
Joined: 19 Feb 2009 Posts: 4 Location: india
|
|
|
|
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 |
|
|
expat
Global Moderator
Joined: 14 Mar 2007 Posts: 8797 Location: Welsh Wales
|
|
|
|
With IDCAMS, not possible.
Look at DFdss, of the ISMF option from whereever it is on your ISPF main menu. |
|
Back to top |
|
|
dineshm123
New User
Joined: 19 Feb 2009 Posts: 4 Location: india
|
|
|
|
Thanks! can we do this in a jcl only without IDCAMS? |
|
Back to top |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007 Posts: 10873 Location: italy
|
|
|
|
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 |
|
|
rahulbank
New User
Joined: 25 Sep 2008 Posts: 66 Location: Bengaluruuuuuu
|
|
|
|
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 |
|
|
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006 Posts: 6966 Location: porcelain throne
|
|
|
|
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 |
|
|
rahulbank
New User
Joined: 25 Sep 2008 Posts: 66 Location: Bengaluruuuuuu
|
|
|
|
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 |
|
|
|