When PA agent is collecting SQL statements from memory, if a Stored Procedure (Routine) runs the SQL statement then the DB2 memory segments only show the coordinates of the compiled routine that just got executed. PA agent captures these coordinates and then later, on Middleware agent, attempts to isolate the SQL statement text from the Routine full text that the Middleware Dictionary Refresh service collected. If the coordinates are not found in the text of the Routine, then PA DB2 agent does not know the SQL statement text and hence the display in the Client.
Rerun the report after a day and see if the statement appears normally.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center