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 Performance profile report

 
Post new topic   This topic is locked: you cannot edit posts or make replies.    IBMMAINFRAMES.com Support Forums -> CA Products
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:22 pm    Post subject: How to get the SQL Info in Performance 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

dick scherrer

Site Director


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

PostPosted: Fri Dec 02, 2011 10:38 pm    Post subject:
Reply with quote

Hello,

Suggest you talk with whoever installed/supports Strobe.

The last time i had an account, there were various components and not all were licensed on every lpar.

If this is a class, the instructor should be able to provide the needed informaton.
Back to top
View user's profile Send private message
Bill Woodger

DFSORT Moderator


Joined: 09 Mar 2011
Posts: 7315

PostPosted: Fri Dec 02, 2011 10:43 pm    Post subject: Reply to: How to get the SQL Info in Performance profile rep
Reply with quote

Seems to be a duplicate of topic in the Compuware forum.
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 Dec 02, 2011 11:13 pm    Post subject: Reply to: How to get the SQL Info in Performance profile rep
Reply with quote

Hi Ed,

Yup, locked. . .

d
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   This topic is locked: you cannot edit posts or make replies.    IBMMAINFRAMES.com Support Forums -> CA Products 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 CONTIG for performance? JPVRoff JCL & VSAM 8 Fri Jun 09, 2017 8:39 am
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

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