Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Automate sequence of TSO commands & screen scraping

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> CLIST & REXX
View previous topic :: :: View next topic  
Author Message
Appu

New User


Joined: 26 Apr 2010
Posts: 74
Location: India

PostPosted: Fri Jun 25, 2010 4:42 pm    Post subject: Automate sequence of TSO commands & screen scraping
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: 8593
Location: Back in jolly old England

PostPosted: Fri Jun 25, 2010 4:52 pm    Post subject:
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: 74
Location: India

PostPosted: Fri Jun 25, 2010 9:03 pm    Post subject:
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

Site Director


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

PostPosted: Fri Jun 25, 2010 9:21 pm    Post subject:
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: 2150
Location: At my coffee table

PostPosted: Fri Jun 25, 2010 9:45 pm    Post subject:
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: 8593
Location: Back in jolly old England

PostPosted: Sat Jun 26, 2010 11:41 am    Post subject:
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: 74
Location: India

PostPosted: Sun Jun 27, 2010 10:34 pm    Post subject:
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

Global Moderator


Joined: 14 Mar 2007
Posts: 10256
Location: italy

PostPosted: Sun Jun 27, 2010 10:42 pm    Post subject: Reply to: Automate sequence of TSO commands & screen scr
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
http://www.redbooks.ibm.com/abstracts/sg247419.html

and a click on the additional material link
to
ftp://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: 74
Location: India

PostPosted: Tue Aug 24, 2010 3:49 pm    Post subject:
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.
http://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    IBMMAINFRAMES.com Support Forums -> CLIST & REXX All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Fileaid 2 commands instream work. In ... descann Compuware & Other Tools 2 Tue May 16, 2017 3:31 pm
No new posts how to send just 10 rows in a CICS sc... Megha Gupta CICS 5 Thu Feb 23, 2017 6:57 pm
No new posts Execute TSO ACF commands from COBOL-I... supreethi.srid TSO/ISPF 0 Tue Feb 21, 2017 5:19 pm
No new posts IMS DC screen Access sivasaras IMS DB/DC 3 Fri Nov 18, 2016 6:38 pm
No new posts FTP - JCL failed while passing FTP co... Suneetha1612 JCL & VSAM 12 Wed Nov 16, 2016 7:33 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us