IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

SARBCH- Extract specific sysout


IBM Mainframe Forums -> CA Products
Post new topic   This topic is locked: you cannot edit posts or make replies.
View previous topic :: View next topic  
Author Message
Ronny John

New User


Joined: 30 Mar 2010
Posts: 33
Location: USA

PostPosted: Mon Jul 09, 2012 10:08 pm
Reply with quote

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
View user's profile Send private message
agkshirsagar

Active Member


Joined: 27 Feb 2007
Posts: 691
Location: Earth

PostPosted: Tue Jul 10, 2012 6:59 pm
Reply with quote

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
View user's profile Send private message
Ed Goodman

Active Member


Joined: 08 Jun 2011
Posts: 556
Location: USA

PostPosted: Tue Jul 10, 2012 7:23 pm
Reply with quote

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
View user's profile Send private message
Ronny John

New User


Joined: 30 Mar 2010
Posts: 33
Location: USA

PostPosted: Tue Jul 10, 2012 9:31 pm
Reply with quote

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
View user's profile Send private message
agkshirsagar

Active Member


Joined: 27 Feb 2007
Posts: 691
Location: Earth

PostPosted: Tue Jul 10, 2012 10:51 pm
Reply with quote

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
View user's profile Send private message
Ronny John

New User


Joined: 30 Mar 2010
Posts: 33
Location: USA

PostPosted: Wed Jul 11, 2012 1:46 am
Reply with quote

//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
View user's profile Send private message
dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6966
Location: porcelain throne

PostPosted: Wed Jul 11, 2012 2:26 am
Reply with quote

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
View user's profile Send private message
agkshirsagar

Active Member


Joined: 27 Feb 2007
Posts: 691
Location: Earth

PostPosted: Wed Jul 11, 2012 2:39 am
Reply with quote

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
View user's profile Send private message
Ronny John

New User


Joined: 30 Mar 2010
Posts: 33
Location: USA

PostPosted: Thu Jul 12, 2012 5:10 am
Reply with quote

I tried PAGE option.
It gave
Code:
SARBCH10  Invalid keyword name "PAGE"
Back to top
View user's profile Send private message
dick scherrer

Moderator Emeritus


Joined: 23 Nov 2006
Posts: 19243
Location: Inside the Matrix

PostPosted: Thu Jul 12, 2012 8:13 am
Reply with quote

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
View user's profile Send private message
Ronny John

New User


Joined: 30 Mar 2010
Posts: 33
Location: USA

PostPosted: Thu Jul 12, 2012 9:01 am
Reply with quote

Do you have a manual? please share.
Back to top
View user's profile Send private message
Nic Clouston

Global Moderator


Joined: 10 May 2007
Posts: 2454
Location: Hampshire, UK

PostPosted: Thu Jul 12, 2012 11:43 am
Reply with quote

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
View user's profile Send private message
vasanthz

Global Moderator


Joined: 28 Aug 2007
Posts: 1744
Location: Tirupur, India

PostPosted: Thu Jul 12, 2012 12:42 pm
Reply with quote

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
View user's profile Send private message
agkshirsagar

Active Member


Joined: 27 Feb 2007
Posts: 691
Location: Earth

PostPosted: Thu Jul 12, 2012 6:38 pm
Reply with quote

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
View user's profile Send private message
vasanthz

Global Moderator


Joined: 28 Aug 2007
Posts: 1744
Location: Tirupur, India

PostPosted: Thu Jul 12, 2012 6:55 pm
Reply with quote

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
View user's profile Send private message
agkshirsagar

Active Member


Joined: 27 Feb 2007
Posts: 691
Location: Earth

PostPosted: Thu Jul 12, 2012 7:10 pm
Reply with quote

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..? icon_biggrin.gif Let's wait for OP to confirm.
Back to top
View user's profile Send private message
dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6966
Location: porcelain throne

PostPosted: Thu Jul 12, 2012 7:25 pm
Reply with quote

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
View user's profile Send private message
dick scherrer

Moderator Emeritus


Joined: 23 Nov 2006
Posts: 19243
Location: Inside the Matrix

PostPosted: Thu Jul 12, 2012 9:28 pm
Reply with quote

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
View user's profile Send private message
thesumitk

Active User


Joined: 24 May 2013
Posts: 156
Location: INDIA

PostPosted: Wed Aug 14, 2013 10:45 pm
Reply with quote

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
View user's profile Send private message
agkshirsagar

Active Member


Joined: 27 Feb 2007
Posts: 691
Location: Earth

PostPosted: Thu Aug 15, 2013 12:03 am
Reply with quote

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
View user's profile Send private message
thesumitk

Active User


Joined: 24 May 2013
Posts: 156
Location: INDIA

PostPosted: Thu Aug 15, 2013 10:51 am
Reply with quote

Thanks icon_smile.gif
Back to top
View user's profile Send private message
Srihith Bandaru

New User


Joined: 23 Dec 2020
Posts: 1
Location: India

PostPosted: Wed Dec 23, 2020 3:49 pm
Reply with quote

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
View user's profile Send private message
Rohit Umarjikar

Global Moderator


Joined: 21 Sep 2010
Posts: 3076
Location: NYC,USA

PostPosted: Wed Dec 23, 2020 4:27 pm
Reply with quote

Welcome!
Please start a new post instead of tailgating any years old posts.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   This topic is locked: you cannot edit posts or make replies. View Bookmarks
All times are GMT + 6 Hours
Forum Index -> CA Products

 


Similar Topics
Topic Forum Replies
No new posts Extract the file name from another fi... DFSORT/ICETOOL 6
No new posts Need help for File Aid JCL to extract... Compuware & Other Tools 23
No new posts optim extract file - SAS DB2 2
No new posts How to extract the data for current y... DFSORT/ICETOOL 8
No new posts Extract record using 2 input file int... JCL & VSAM 2
Search our Forums:

Back to Top