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

How to get the SQL Info in Strobe profile report


IBM Mainframe Forums -> Compuware & Other Tools
Post new topic   Reply to topic
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
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
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
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 View Bookmarks
All times are GMT + 6 Hours
Forum Index -> Compuware & Other Tools

 


Similar Topics
Topic Forum Replies
No new posts Copy a PDS to a new PDS - why do I ne... TSO/ISPF 8
No new posts Tivoli INFO/MANAGEMENT IBM Tools 1
No new posts Recreating VSAM cluster catalog info ... All Other Mainframe Topics 6
No new posts report on job scheduling details in Zeke IBM Tools 2
No new posts Print report for each record from mul... CA Products 1
Search our Forums:

Back to Top