1 Reply Latest reply on Aug 1, 2014 4:00 PM by shaulis

    Static SQL in DB2?

    awickham10

      It appears that the DB2 monitor is not collecting static SQL. The only calls we can see are dynamic SQL. Is there a way to do this? It sounds like DPA uses the GET SNAPSHOT commands to retrieve query performance, which does not include static SQL. Starting in DB2 9.7 they introduced a new interface to monitor dynamic and static SQL statements (MON_GET_PKG_CACHE_STMT). Is there anyway to switch it over to use this instead of GET SNAPSHOT?