Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
View the SAR output based on some column names

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> CA Products
View previous topic :: :: View next topic  
Author Message
Sumit.GHosh

New User


Joined: 31 May 2006
Posts: 5

PostPosted: Mon Jul 10, 2006 11:01 am    Post subject: View the SAR output based on some column names
Reply with quote

Hi,
I Need to Selectively view the SAR output based on some column names. Can you please tell me how to Specify the SAR INDEX and the value for that INDEX. I need it very urgently...

Thanks & Regards
Sumit.
Back to top
View user's profile Send private message

Sumit.GHosh

New User


Joined: 31 May 2006
Posts: 5

PostPosted: Mon Jul 10, 2006 6:28 pm    Post subject: Detailed Description of the problem
Reply with quote

Actually the System Activity Report SAR which shows the logs of the Running jobs:
This is the screen which we reach by typing on the command line "=v.b.j"
-------------------------------------------------------------------------------------
SYSOUT ID ===> <JOBNAME> SELECT BY ===> R (R, I, IL, or IR)
INDEX NAME ===> VALUE ===>
SELECTION CRITERIA:
GENERATION ===> *
DATE ===>
SELECTION OPTIONS:
EXCEPTIONS ===>
PERMANENT ===>
-------------------------------------------------------------------------------------
Here we only give the <jobname> in "SYSOUT ID" and R in "SELECT BY". It shows all the job logs of the given <jobname>. However I need to view the selective list based on page count in the SAR list. Hence I feel that I need to Specify the "INDEX NAME" and "VALUE" property with "SELECT BY" as I/IR/IL.
Back to top
View user's profile Send private message
sril.krishy

Active User


Joined: 30 Jul 2005
Posts: 183
Location: hyderabad

PostPosted: Mon Jul 10, 2006 11:49 pm    Post subject: Re: View the SAR output based on some column names
Reply with quote

Hi,
SAR is generally used to store the Reports kind of stuff in the mainframes.
Each job step is assigned a diffrent SAR id and using this ID ,we can view the reports or the o/p of the jobs for the defined period of time.

There are few BATCH JCL's which will be use ful to bring the o/p into a dataset if needed.

Thank you
Krishy
Back to top
View user's profile Send private message
Sumit.GHosh

New User


Joined: 31 May 2006
Posts: 5

PostPosted: Tue Jul 11, 2006 10:04 am    Post subject:
Reply with quote

Hi Krishy,

Actually I could get the sar output to a dataset but I could not get it based on some columns! So please post all the BATCH JCL's and please don't miss any.

While viewing the SAR I waned to get rows selectively! It can view all the reports not the selctive ones! Any idea on that?

Thanks,
Sumit
Back to top
View user's profile Send private message
Rameshs

New User


Joined: 15 Jun 2005
Posts: 53
Location: India, Chennai

PostPosted: Tue Jul 11, 2006 12:55 pm    Post subject:
Reply with quote

Hi Sumit,

can you plz give me the JCL to get the sar output to a dataset ?
Back to top
View user's profile Send private message
Sumit.GHosh

New User


Joined: 31 May 2006
Posts: 5

PostPosted: Tue Jul 11, 2006 2:22 pm    Post subject:
Reply with quote

Definately:
//STEP1 EXEC PGM=SARBCH
//SYSIN DD *
/DBASE NAME=POX.VIEWJCL
/LIST ID=**1,GEN=**2
//*
//REPORT DD DSN=**3, ...
//SYSOUT DD SYSOUT=*
//SYSPRINT DD SYSOUT=*

**1=JOB-Name or abc* where it gives all the SAR outputs of JOBs starting with abc.
**2=or 0 or -1 or -2 or ...
**3=Your DSN name
Back to top
View user's profile Send private message
Sumit.GHosh

New User


Joined: 31 May 2006
Posts: 5

PostPosted: Wed Jul 12, 2006 10:47 am    Post subject:
Reply with quote

Hi Krishy,

Where did yo post the JCL I could not Find them!

Thanks,
Sumit
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> CA Products All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts How to list data set names with diffe... murali.andaluri CLIST & REXX 8 Thu Apr 12, 2018 11:33 pm
No new posts Query to compare 2 values of 1 column... Poha Eater DB2 13 Fri Mar 09, 2018 10:45 am
No new posts Copy set of records based on condition krish.deepu SYNCSORT 2 Thu Mar 08, 2018 11:39 am
No new posts How to get the output from submit com... Joanna2016 CLIST & REXX 10 Tue Feb 06, 2018 7:26 am
No new posts How to select record x+7 or x+2 based... JoAnn Kulcyk SYNCSORT 6 Tue Jan 16, 2018 10:49 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us