(Chris Eaton) Continuing in this series of postings on new administrative views in DB2 9, I’m going to show you a view that lists the top queries in the dynamic SQL cache. The view is called SYSIBMADM.TOP_DYNAMIC_SQL. This view shows you the most frequently executed dynamic SQL statements, how many
Read More - Register for Free Membership
SQL Server, Azure SQL Database, Amazon RDS & AWS, Oracle and IBM Help