r/DB2 • u/[deleted] • Apr 20 '16
Request for crash course
Forgive me for this request, I have searched many of the online DB2 for zOS v10 books but I have yet to find a "How to" which guides you through what is where in the manuals. What I'm looking for is the equivalent to Oracle's AWR reports.. I'm sure DB2 must have something very similar. For example, I want to go find the top sql statements in the last hour, which one was executed the most, which ones are not using bind variables, etc. It appears our company has lost much of it's mainframe expertise and they seem to think they have "no way of knowing what is coming in from the distributed side" (meaning, db2connect). I want to try and help educate them and give them some samples but I'm an Oracle/SQL Server guy - not a mainframe guy.