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
 
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 Profile changed to NUMBER ON STD (fro... Martylin TSO/ISPF 1 Thu Aug 03, 2017 9:14 am
No new posts Need info on EIBCPOSN value in IBM FA... subratarec CICS 11 Wed Jul 12, 2017 3:45 pm
No new posts Report cost in CA-dispatch Nileshkul CA Products 3 Wed Jun 07, 2017 10:32 pm
No new posts Splitting of single report to seperat... abdulrafi TSO/ISPF 7 Mon Mar 27, 2017 3:59 pm
No new posts Easytrieve report shalem CA Products 4 Sun Feb 26, 2017 9:08 am

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