View previous topic :: View next topic
|
Author |
Message |
Ronny John
New User
Joined: 30 Mar 2010 Posts: 33 Location: USA
|
|
|
|
I have a JCL to extract SAR log into a flat file using SARBCH utility. The SAR log has the following:
Sel DDname Stepname Procstep
XXXXXX01 FFF0200 STEP030
XXXXXX01 FFF0200 STEP060
SYSUT2 FFF0200 STEP065
SYSUT2 FFF0200 STEP065A
SYSUT2 FFF0200 STEP075
XXXXXX01 FFF0200 STEP100
YYYYYYYYY FFF0200 STEP150
I need to extract only the details from "YYYYYY" into the flat file. If i give a simple "Load ID " parameter, it loads all XXXXXX01, SYSUT2 along with YYYYYYYYY. I need to extract YYYYYYYYY alone. Help needed, any idea? |
|
Back to top |
|
|
agkshirsagar
Active Member
Joined: 27 Feb 2007 Posts: 691 Location: Earth
|
|
|
|
If I understood your question correctly, the SAR output is superset of what you need. I would prefer SORT product to extract the information I needed.
Let us know if this not what you were looking for. |
|
Back to top |
|
|
Ed Goodman
Active Member
Joined: 08 Jun 2011 Posts: 556 Location: USA
|
|
|
|
Do you have the syntax of the command handy? I'm wondering if there is a parm to specify the DD names you want.
This almost looks like it took everything in the same sysout class. |
|
Back to top |
|
|
Ronny John
New User
Joined: 30 Mar 2010 Posts: 33 Location: USA
|
|
|
|
Yes, i am looking for a syntax to extract only the spcific DD name rather than the whole dump to a flat file. |
|
Back to top |
|
|
agkshirsagar
Active Member
Joined: 27 Feb 2007 Posts: 691 Location: Earth
|
|
|
|
I think SARPAGE is what you are looking for.
Code: |
/PRINT ID=JJJJJJJJ GEN=-0 PAGE=2 DDNAME=OUTPUT1 |
Above control card will extract the DDNAME belonging to SARPAGE 2. In your case, try with PAGE=7. |
|
Back to top |
|
|
Ronny John
New User
Joined: 30 Mar 2010 Posts: 33 Location: USA
|
|
|
|
//STEP1 EXEC PGM=SARBCH
//SYSUDUMP DD SYSOUT=*
//SYSPRINT DD SYSOUT=*
//REPORT DD DSN=TEST.RONNY,
// DISP=(NEW,CATLG,DELETE),
// DCB=(BLKSIZE=0,LRECL=152,RECFM=FB),
// SPACE=(CYL,(1,1),RLSE),UNIT=DISK
//SYSIN DD *
/DBASE NAME=SAR.XXX.YYY
/LOAD ID=XYZ0250A DDNAME=REPORT
Here the DDNAME parm is used to point into which file the SAR log should be unloaded. This was the JCL i used. It unloads the entire SAR log.
So I doubt if we can give a DDNAME parm as you mentioned. |
|
Back to top |
|
|
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006 Posts: 6966 Location: porcelain throne
|
|
|
|
Quote: |
So I doubt if we can give a DDNAME parm as you mentioned.
|
actually, the only doubts are if YOU can read and follow directions.
and you have been around long enough on this board to use BBCode
start using it. |
|
Back to top |
|
|
agkshirsagar
Active Member
Joined: 27 Feb 2007 Posts: 691 Location: Earth
|
|
|
|
Quote: |
So I doubt if we can give a DDNAME parm as you mentioned |
Did you give it a try? In my post, I meant the DDname on the SAR display.
Quote: |
Sel DDname Stepname Procstep |
In your case, SARPAGE 7 will correspond to YYYYYYYY. Best way to confirm is to open YYYYYYY in SAR and read the first line.
Please try -
Code: |
/LOAD ID=XYZ0250A PAGE=7 DDNAME=REPORT |
|
|
Back to top |
|
|
Ronny John
New User
Joined: 30 Mar 2010 Posts: 33 Location: USA
|
|
|
|
I tried PAGE option.
It gave
Code: |
SARBCH10 Invalid keyword name "PAGE" |
|
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19243 Location: Inside the Matrix
|
|
|
|
Hello,
If the manual is not sufficient, is there some reason you have not opened an issue with CA Support?
They can surely explain of what you want to do is available and if so how to do it. |
|
Back to top |
|
|
Ronny John
New User
Joined: 30 Mar 2010 Posts: 33 Location: USA
|
|
|
|
Do you have a manual? please share. |
|
Back to top |
|
|
Nic Clouston
Global Moderator
Joined: 10 May 2007 Posts: 2454 Location: Hampshire, UK
|
|
|
|
No - we do not have a manual and if we did we could not share as it is copyrighted. You can get the manual from your organisation as they would have received a set with the software or you can go to CA and ask for a new set. |
|
Back to top |
|
|
vasanthz
Global Moderator
Joined: 28 Aug 2007 Posts: 1744 Location: Tirupur, India
|
|
|
|
Hello,
I believe what you require cannot be done. I would love to be proved wrong in this case.
You could open a support ticket with CA to check if it is possible.
Skimmed the manuals but unable to find anything related to getting specific job step's output. You could also have a look at them from
support.ca.com/irj/portal/anonymous/DocumentationSearch
You can get the manuals after creating login credentials on the site, which is quite simple.
Hope it helps. |
|
Back to top |
|
|
agkshirsagar
Active Member
Joined: 27 Feb 2007 Posts: 691 Location: Earth
|
|
|
|
Why don't you try the PRINT command instead of load?
I tested the solution when I posted it.
Code: |
/PRINT ID=JJJJJJJJ GEN=-0 PAGE=2 DDNAME=OUTPUT1 |
I was able to get the content of a particular DDname indicated by page 2 in the OUTPUT1. |
|
Back to top |
|
|
vasanthz
Global Moderator
Joined: 28 Aug 2007 Posts: 1744 Location: Tirupur, India
|
|
|
|
agkshirsagar,
I agree your solution will work, but everytime the user has to go into the step output and look for the starting page number and ending pagenumbers and then code it in the SARBCH program.
I think this is the reason the TS was looking for an automated approach. |
|
Back to top |
|
|
agkshirsagar
Active Member
Joined: 27 Feb 2007 Posts: 691 Location: Earth
|
|
|
|
I respectfully disagree. For a job that is already implemented in production or a job that produces fixed number of output files, SARPAGE number will not change. SARPAGE is not equivalent to report page number. I mean all the report pages will be part of a single SARPAGE. At least, I haven't seen a report spanning multiple SARPAGES.
I see that the OP is trying to get a spooled report into a dataset and I think my solution fits.
Quote: |
The greatest pleasure in life is, doing what others say you cannot do |
Is it too early for me to feel this pleasure..? Let's wait for OP to confirm. |
|
Back to top |
|
|
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006 Posts: 6966 Location: porcelain throne
|
|
|
|
I believe the TS is too stubborn to change his 'thinking'.
you notice he only provided an error message.
I don't think that he provided the appropriate control cards in his job to do this.
actually, I think this topic should be locked and trimmed
leaving only agkshirsagar's post. |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19243 Location: Inside the Matrix
|
|
|
|
Hello,
Quote: |
Do you have a manual? please share. |
We are not permitted to share CA documentation - CA does not make all of their documentation available to the public.
If your organization is licensed to use the product, All of the material may be downloaded free from CA Support. You have to register, but that is rather painless. |
|
Back to top |
|
|
thesumitk
Active User
Joined: 24 May 2013 Posts: 156 Location: INDIA
|
|
|
|
TO Load any specific SYSOUT
you can use GEN parameter instead of JOBID, when you see in SAR PANEL there are 2 GEN parameter one is of 4 digits and another one is of three digits you need to take the four digit one and mention the sequence number with it .. Since the GEN parameter not unique alone however combination of GEN and SEQ is unique through out the report of any job...
Code: |
/LOAD ID=JOB GEN=2273 SEQ=1 PASSWORD= DDNAME=REPORT |
SO you do not need to use Relational number for GENS like -1,-2,-3 etc .. you can just use the value of GEN variable
THanks |
|
Back to top |
|
|
agkshirsagar
Active Member
Joined: 27 Feb 2007 Posts: 691 Location: Earth
|
|
|
|
I don't think the OP cares anymore; the topic's been inactive for over one year.. but good to see you are applying your learning to help others. |
|
Back to top |
|
|
thesumitk
Active User
Joined: 24 May 2013 Posts: 156 Location: INDIA
|
|
|
|
Thanks |
|
Back to top |
|
|
Srihith Bandaru
New User
Joined: 23 Dec 2020 Posts: 1 Location: India
|
|
|
|
I want to extract sysout based on user ID but, not able to find the attribute name that I have to use in order to extract based on user ID (gone through broadcom techdocs but, could not make it). any help would be highly appreacited.
Thank you |
|
Back to top |
|
|
Rohit Umarjikar
Global Moderator
Joined: 21 Sep 2010 Posts: 3076 Location: NYC,USA
|
|
|
|
Welcome!
Please start a new post instead of tailgating any years old posts. |
|
Back to top |
|
|
|