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

Automate sequence of TSO commands & screen scraping


IBM Mainframe Forums -> CLIST & REXX
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
Appu

New User


Joined: 26 Apr 2010
Posts: 73
Location: India

PostPosted: Fri Jun 25, 2010 4:42 pm
Reply with quote

Hello Team,

I need to develop an application which will take the job logs from Spool( in my case it is the job archive ASAR) and analyze its contents. For this purpose , I need to automate a sequence of mainframe instructions like to traverse from the ISPF start menu to reach the job log screen. Once I reach the job log screen i need to traverse through the logs to get the necessary error information which I want. Could you please let me know whcih language should I use for this ( like REXX or i have heard about ISPF edit macros also). Can any one give me the advice which way should I go.
Back to top
View user's profile Send private message
expat

Global Moderator


Joined: 14 Mar 2007
Posts: 8797
Location: Welsh Wales

PostPosted: Fri Jun 25, 2010 4:52 pm
Reply with quote

It totally depends on exactly what it is that you want to extract from the job logs as to the best method.

Perhaps if you gave us some real detail to work with we could suggest something.
Back to top
View user's profile Send private message
Appu

New User


Joined: 26 Apr 2010
Posts: 73
Location: India

PostPosted: Fri Jun 25, 2010 9:03 pm
Reply with quote

Hi expat,
Thanks for the reply. The job writes some specific results to certain output datasets inside the job log ( like SYSPRINT ) and I want to read that information from a set of jobs and combine the result in to a single dataset which can be mailed.
Back to top
View user's profile Send private message
dick scherrer

Moderator Emeritus


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

PostPosted: Fri Jun 25, 2010 9:21 pm
Reply with quote

Hello,

You need to re-read what Expat has posted. . .

You have to describe precisely (not generically) what you want to do and then implement a process to accomplish this.

We can possibly help but not until the exact details are posted. There are no "do what i want" utilities. . .
Back to top
View user's profile Send private message
CICS Guy

Senior Member


Joined: 18 Jul 2007
Posts: 2146
Location: At my coffee table

PostPosted: Fri Jun 25, 2010 9:45 pm
Reply with quote

Check out Lionel B. Dyck. he has a great little tool, SDFSEXT, a generalized SDSF batch tool to extract all or part of your sysout into a dataset that you could do whatever you want with.
Back to top
View user's profile Send private message
expat

Global Moderator


Joined: 14 Mar 2007
Posts: 8797
Location: Welsh Wales

PostPosted: Sat Jun 26, 2010 11:41 am
Reply with quote

What I want to know is what information you want from the sysouts.

In your original post you mentioned error information. Then perhaps if you talk to your capacity and performance group they probably already disect SMF data and will usually have what you need available without you having to subscribe to the wheel reinvention society.
Back to top
View user's profile Send private message
Appu

New User


Joined: 26 Apr 2010
Posts: 73
Location: India

PostPosted: Sun Jun 27, 2010 10:34 pm
Reply with quote

Hello all,
Sorry that my explanation was so generic. Here is exactly what I want to do. My programs will write details to SYSOUT like "Processing failed for customer number - nnnn', where nnnn is the customer number. This is not at all a system error but the error happened due to some data problem. I want to extract this statements ( in quotes above ) to a new result dataset which will have all the customer numbers for which my processing failed. The thing is that I need to automate the commands to go from the Start screen to the job log screen and then do the scraping of the output dataset so that I can extract the above information. I have to repeat the same procedure for around 12 jobs.
Please let me know the tools or languages which I should use.


@Cics guy : Thanks for the suggestion. But I am looking for an option without changing the existing jobs.

Regards,
Appu
Back to top
View user's profile Send private message
enrico-sorichetti

Superior Member


Joined: 14 Mar 2007
Posts: 10872
Location: italy

PostPosted: Sun Jun 27, 2010 10:42 pm
Reply with quote

the most reasonable tool for Your requirement would be a batch execution of SDSF

a quick and dirty search for ibm redbooks sdsf rexx will take You

to
www.redbooks.ibm.com/abstracts/sg247419.html

and a click on the additional material link
to
www.redbooks.ibm.com/redbooks/SG247419/

were You can download the sources of the samples
Back to top
View user's profile Send private message
Appu

New User


Joined: 26 Apr 2010
Posts: 73
Location: India

PostPosted: Tue Aug 24, 2010 3:49 pm
Reply with quote

Hello Team,

Thanks all for your suggestions. Finally I am able to achieve what I want using vbscript. Posting the link here so that somebody else can also make use if it. I am not very sure as whether it is the best approach but my script works perfectly fine to send commands to the PCOM session and extract the data which appears in the screen.
publib.boulder.ibm.com/infocenter/pcomhelp/v5r9/index.jsp?topic=/com.ibm.pcomm.doc/books/html/host_access08.htm
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> CLIST & REXX

 


Similar Topics
Topic Forum Replies
No new posts Cobol program with sequence number ra... COBOL Programming 5
No new posts Find missing sequence for every key DFSORT/ICETOOL 3
No new posts Console Commands All Other Mainframe Topics 4
No new posts commands missing in JESMSGLG JCL & VSAM 3
No new posts GDG all in sequence order JCL & VSAM 9
Search our Forums:

Back to Top