Rexx to extract sequential dataset basis particular d & t



IBM's Command List programming language & Restructured Extended Executor

Rexx to extract sequential dataset basis particular d & t

Postby arya_starc » Wed May 20, 2020 5:09 pm

Hi All,

My requirement is to extract all the sequential datasets which is created between some particular time window on particular day.

Example - If the production batch is run daily then I need to extract all the datasets which is created between 12am - 3am of my system time.

Challenge here is that how I can pass this time constraint to my rexx utility. Any suggestion will be helpful.

Thanks.
arya_starc
 
Posts: 136
Joined: Mon Sep 21, 2015 1:39 pm
Has thanked: 5 times
Been thanked: 0 time

Re: Rexx to extract sequential dataset basis particular d &

Postby enrico-sorichetti » Wed May 20, 2020 5:22 pm

wondering what additional information You might be hiding ...

why do You think that
parse arg
cannot be used ?
cheers
enrico
When I tell somebody to RTFM or STFW I usually have the page open in another tab/window of my browser,
so that I am sure that the information requested can be reached with a very small effort
enrico-sorichetti
Global moderator
 
Posts: 2994
Joined: Fri Apr 18, 2008 11:25 pm
Has thanked: 0 time
Been thanked: 164 times

Re: Rexx to extract sequential dataset basis particular d &

Postby arya_starc » Wed May 20, 2020 5:34 pm

Hi Enrico,

I am not getting if I pass the system date and time in my rexx utility then and how in rexx program determine the existing sequential date and time.
This is show stopper as of now to me.
arya_starc
 
Posts: 136
Joined: Mon Sep 21, 2015 1:39 pm
Has thanked: 5 times
Been thanked: 0 time

Re: Rexx to extract sequential dataset basis particular d &

Postby enrico-sorichetti » Wed May 20, 2020 6:10 pm

what happened when You searched the forum with "dataset creation date time" ?
cheers
enrico
When I tell somebody to RTFM or STFW I usually have the page open in another tab/window of my browser,
so that I am sure that the information requested can be reached with a very small effort
enrico-sorichetti
Global moderator
 
Posts: 2994
Joined: Fri Apr 18, 2008 11:25 pm
Has thanked: 0 time
Been thanked: 164 times

Re: Rexx to extract sequential dataset basis particular d &

Postby steve-myers » Wed May 20, 2020 7:13 pm

The time of day a data set was created is not a data set attribute. It is not stored in the data set label.
steve-myers
Global moderator
 
Posts: 2105
Joined: Thu Jun 03, 2010 6:21 pm
Has thanked: 4 times
Been thanked: 243 times

Re: Rexx to extract sequential dataset basis particular d &

Postby willy jensen » Wed May 20, 2020 9:29 pm

The only place I'm aware of where the time of dataset creation is recorded is in the SMF record type 61, assuming that the dataset is cataloged too. As steve-meyers correctly says, it is not in the DSCB in the VTOC, nor is it in the catalog entry.
willy jensen
 
Posts: 455
Joined: Thu Mar 10, 2016 5:03 pm
Has thanked: 0 time
Been thanked: 69 times

Re: Rexx to extract sequential dataset basis particular d &

Postby sergeyken » Wed May 20, 2020 11:26 pm

The author is concerned about the only one simple problem:
Challenge here is that how I can pass this time constraint to my rexx utility. Any suggestion will be helpful.

Enrico gave the whole explanation of this issue.

So far, there is no need to investigate DSCB, or catalog, or SMF records, or whatever else.
Javas and Pythons come and go, but JCL and SORT stay forever.
User avatar
sergeyken
 
Posts: 408
Joined: Wed Jul 24, 2019 10:12 pm
Has thanked: 6 times
Been thanked: 40 times

Re: Rexx to extract sequential dataset basis particular d &

Postby willy jensen » Wed May 20, 2020 11:30 pm

Well, yes, but later the OP adds
how in rexx program determine the existing sequential date and time

So I was confused as to what the issue really is.
willy jensen
 
Posts: 455
Joined: Thu Mar 10, 2016 5:03 pm
Has thanked: 0 time
Been thanked: 69 times

Re: Rexx to extract sequential dataset basis particular d &

Postby sergeyken » Thu May 21, 2020 3:06 am

willy jensen wrote:Well, yes, but later the OP adds
how in rexx program determine the existing sequential date and time

So I was confused as to what the issue really is.

The term “existing sequential(?) date and time” does recall the “current date and time”, but not “dataset creation/reference/update/... date and time”
Javas and Pythons come and go, but JCL and SORT stay forever.
User avatar
sergeyken
 
Posts: 408
Joined: Wed Jul 24, 2019 10:12 pm
Has thanked: 6 times
Been thanked: 40 times

Re: Rexx to extract sequential dataset basis particular d &

Postby Pedro » Thu May 21, 2020 5:38 am

I think you need to look at SMF data for the time period in question. It should give you the name. Perhaps it is field SMF61ENM from record type 61. I think you need to get some test data to verify.
Given the name, you can issue LISTDSI in rexx to determine if it is a sequential data set.

See here: https://www.ibm.com/support/knowledgece ... ecords.htm

Note: you probably do not have access to read SMF data, so ask for permission first.
Pedro Vera
User avatar
Pedro
 
Posts: 684
Joined: Thu Jul 31, 2008 9:59 pm
Location: Silicon Valley
Has thanked: 0 time
Been thanked: 53 times

Next

Return to CLIST & REXX

 


  • Related topics
    Replies
    Views
    Last post