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
 

 

How to get the SQL Info in Strobe profile report

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> Compuware & Other Tools
View previous topic :: :: View next topic  
Author Message
ajaikumar

New User


Joined: 27 Jan 2007
Posts: 9
Location: Hyderabad

PostPosted: Fri Dec 02, 2011 4:44 pm    Post subject: How to get the SQL Info in Strobe profile report
Reply with quote

In an MVS Strobe, a batch run monitoring IKJEFT01 no longer shows the SQL statements.
Report identifiers #SUS, #SWS, #CSS & #WBS no longer appear.

SQL CPU USAGE SUMMARY . . . . . . . . . . . . . . . . . . . . . . . . . . . #SUS
SQL WAIT SUMMARY . . . . . . . . . . . . . . . . . . . . . . . . . . . . . #SWS
DL/I WAIT SUMMARY . . . . . . . . . . . . . . . . . . . . . . . . . . . . . #DWS
PROGRAM USAGE BY PROCEDURE . . . . . . . . . . . . . . . . . . . . . . . . #PUP
CPU USAGE BY SQL STATEMENT . . . . . . . . . . . . . . . . . . . . . . . . #CSS
WAIT BY SQL STATEMENT . . . . . . . . . . . . . . . . . . . . . . . . . . . #WBS
WAIT BY DL/I REQUEST . . . . . . . . . . . . . . . . . . . . . . . . . . . #DWR

I found the information in StrobeDB2 Manual, The Strobe SQL Agent must be active to collect SQL data.

•A user ID for the Strobe SQL Agent(i.e.STRSSA)will need to be defined to your security product(RACF,CA-Top Secret, CA-ACF2).

•The Strobe SQL Agent (i.e. STRSSA) will need to be granted MONITOR2 and TRACE user authorization for each subsystem on which you will be using Strobe. A new installation member, STRBGRNT, has been provided for your use.

•A new package will need to be bound for the Strobe SQL Agent (STRSSA) for each subsystem on which Strobe will be used. A new installation job, STRBPBND, has been added to perform this bind. This package is bound, along with the Strobe SQL Analysis packages, into collection STROBE41. The collection is then bound into the STRANANA plan after the Strobe SQL Analysis packages have been bound.

How to make the SQL Agent active in MVS Strobe and Is there any special settings for capturing these reports ?

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

Ed Goodman

Active Member


Joined: 08 Jun 2011
Posts: 556
Location: USA

PostPosted: Fri Dec 02, 2011 9:25 pm    Post subject:
Reply with quote

IF (<--Notice both capital letters!) it worked before, then your system folks have done an upgrade and one of two things happened.

Either the vendor did not include all of the licensed features for your shop, or your shop has decided not to continue using the features.

We had this happen once with Abend-Aid. The upgrade tape showed up, got installed, and all of the IMS sections of the report stopped appearing. We tried to figure it out for about a month before someone thought to call the vendor and ask what they sent. A replacement tape fixed the problem.

The shared libraries of that vendor caused a ripple effect into our STROBE reports too.
Back to top
View user's profile Send private message
Ed Goodman

Active Member


Joined: 08 Jun 2011
Posts: 556
Location: USA

PostPosted: Fri Dec 02, 2011 9:26 pm    Post subject:
Reply with quote

Hey! I just hit 100 posts!
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 -> Compuware & Other Tools All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts IMS Database backup info ashek15 IMS DB/DC 14 Wed Nov 16, 2016 5:29 am
No new posts Detailed Transaction History report f... Kyle Carroll CICS 5 Tue Oct 18, 2016 12:42 am
No new posts RACF profile access vasanthz All Other Mainframe Topics 11 Fri Sep 23, 2016 5:51 am
No new posts Easytrieve - Report writing - Only 1 ... Abhi Nature CA Products 2 Wed Sep 14, 2016 11:40 am
No new posts Daily report to be extracted from CA ... polymathtarun DFSORT/ICETOOL 5 Mon Jul 11, 2016 4:33 pm


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