Page 1 of 2
Searching and producing report from SDSF
Posted:
Mon Mar 08, 2021 6:46 pmby Misha786
Hi All -
I have a requirement where I need to search a string "
$HASP150' from spool and if found need to pickup that line to produce a report.
SDSF OUTPUT DISPLAY M958R2 JOB02114 DSID 2 LINE 0 COLUMNS 02- 81
COMMAND INPUT ===> SCROLL ===> CSR
********************************* TOP OF DATA ********************************
J E S 2 J O B L O G -- S Y S T E M S I 0 0 -- N
08.10.49 JOB02114 ---- MONDAY, 08 MAR 2021 ----
08.10.49 JOB02114 $HASP373 M958R2 STARTED - INIT 48 - CLASS 4 - SY
08.10.49 JOB02114 ACF9CCCD USERID M958 IS ASSIGNED TO THIS JOB - M958R2
08.10.49 JOB02114 IEF403I M958R2 - STARTED - TIME=08.10.49
08.10.50 JOB02114 JOB-M958R2 STEP-PDFINFO.TUPTRF PGM-AOPBATCH R.C.-0000
08.10.50 JOB02114 JOB-M958R2 STEP-PRINT.TUPTRF PGM-IEBGENER R.C.-0000
08.10.50 JOB02114 IEF404I M958R2 - ENDED - TIME=08.10.50
08.10.50 JOB02114 $HASP395 M958R2 ENDED - RC=0000
So, do I have to read the SYSLOG ? If so, how can this be done. Any suggestion wold be helpful please
Re: Searching and producing report from SDSF
Posted:
Mon Mar 08, 2021 7:05 pmby sergeyken
Since you are able to read SDSF log, you can use the SE line command (next to the desired job), and then - to copy the log to any dataset.
When done, you can use any of ISPF tools, or any batch utility, to find or to extract from this dataset whatever you want.
Re: Searching and producing report from SDSF
Posted:
Mon Mar 08, 2021 7:16 pmby Misha786
thanks Sergeyken .. that would have been great if it was related to only my job. Our requirement is such that we do not know how many user would be running this kind of job (related to print ) and when. So, reading the sdsf log to search for "$HASP150" string would help us pickup the all the job information from sdsf related to "$HASP150' . Hence, I am looking for some kind of batch job or any other utility to get this done. Please let me know if could convey my requirement clearly. Thanks in Advance !!
Re: Searching and producing report from SDSF
Posted:
Mon Mar 08, 2021 7:19 pmby sergeyken
The simplest way “to find and to extract this line to produce a report” is, using a SORT utility (also 100500 other methods are available)
INREC IFTHEN=(WHEN=(1,50,SS,EQ,C’ $HASP150 ‘),
BUILD=(1,121))
Or similar code, depending on you (unspecified) requirements.
Re: Searching and producing report from SDSF
Posted:
Mon Mar 08, 2021 7:24 pmby sergeyken
Misha786 wrote:thanks Sergeyken .. that would have been great if it was related to only my job. Our requirement is such that we do not know how many user would be running this kind of job (related to print ) and when. So, reading the sdsf log to search for "$HASP150" string would help us pickup the all the job information from sdsf related to "$HASP150' . Hence, I am looking for some kind of batch job or any other utility to get this done. Please let me know if could convey my requirement clearly. Thanks in Advance !!
In this case you need to automate the scanning process of all available SDSF logs in the output queue.
Such tools are available for use within ISPF, as well as for batch processing (mainly from REXX). I did it several times in my life, but do not keep those details in my mind. I’m pretty sure I can find it again if needed. Hope you can do this search by yourself, or maybe you’ll get more detailed answer from those who has such examples on hand right now.
Re: Searching and producing report from SDSF
Posted:
Mon Mar 08, 2021 7:44 pmby Misha786
Thanks Sergeyken for your quick response. Unfortunately, I do not have something handy to serve my purpose. I am not a mainframe expert either to quickly buildup something like this and hence looking forward to this forum for help if anyone has it, that would be great.
Thanks once again Sergeyken !!
Re: Searching and producing report from SDSF
Posted:
Mon Mar 08, 2021 8:22 pmby sergeyken
Misha786 wrote:Thanks Sergeyken for your quick response. Unfortunately, I do not have something handy to serve my purpose. I am not a mainframe expert either to quickly buildup something like this and hence looking forward to this forum for help if anyone has it, that would be great.
Thanks once again Sergeyken !!
OK,
At this moment I’m quite busy to make this searching for examples. If nobody else would provide some directions soon, I may be able to do this within a week, or so, whenever I have enough time.
Re: Searching and producing report from SDSF
Posted:
Tue Mar 09, 2021 2:26 pmby willy jensen
Sounds to me that it really the syslog you need to search rather than opening SDSF. How is your syslog saved? I'm sure that you must have either datasets (GDS most likely) or just using the system logger. In either case you can easily put together a SORT job to pull the $HASP150 messages. Let us know how syslog is saved.
Re: Searching and producing report from SDSF
Posted:
Tue Mar 09, 2021 6:59 pmby Misha786
Hi Willy -
We are not saving the syslogs anywhere. So, I am looking for something that can autoread/autoscan the syslogs and pickup $HASP150 message related records.
Thats all I need a batach job or rexx utility to run in bacth to collect those records and dump those in a ps file. Any help would be great !!
Thanks.
Re: Searching and producing report from SDSF
Posted:
Tue Mar 09, 2021 8:47 pmby sergeyken
These are two useful links on how to deal with SDSF log from REXX code. AFAIR I also used those two in my former projects.
Using SDSF with the REXX programming language Implementing REXX Support in SDSF They should help