Select Option 2 to get the delay information, as shown in Figure7-35.
Figure 7-35 Delays for this user
Select Option 4 to get the DB2 information as shown in Figure7-36.
Figure 7-36 SQL analysis
258IBM Application Development Tools for z/OS and OS/390
You can view the SQL statement, as shown in Figure 7-37.
Figure 7-37 SQL statement
Or you can request an Explain panel, as shown in Figure 7-38.
Figure 7-38 Result of explain request
As this is a dynamic plan, you cannot get plan information (action P) ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month, and much more.
Karan Singh, Richard Davis, Anuja Deedwaniya, Michael Jägering, Redelf Janßen, Michael Morrissey, Neil O'Connor, Conrad Peche, Arunkumar Ramachandran, Richard Walton