The largest IBM i-related conference event in the world, bringing together the community of users, IBM, industry experts and solution providers.
Back To Schedule
Thursday, April 27 • 8:00am - 9:00am
319: Run Away ODBC or Query/400 Queries Got you Down?

Sign up or log in to save this to your schedule, view media, leave feedback and see who's attending!

Pretty much on a weekly basis we get calls from clients concerned about the negative performance impacts and security exposure from query tools like Query/400, QMF, Showcase, Tableau and others - because they've experienced the "query from hell" eating up system resources. This session will cover aspects such as the new-ish Db2 Supervisor to control/audit long running queries, ACS' Plan Cache and index advice information along with modernizing those tools into a CONTROLLED Ad-Hoc query environment.

Learning Objectives:
1. Learn about the Db2 Supervisor to govern and/or audit long running queries
2. Gain insight into the tools you can use to monitor, tune, and prune queries
3. Hear about the value of moving to a CONTROLLED AD-HOC query solution and the benefits it provides around controlling performance and securing your data

avatar for Doug Mack

Doug Mack

Consultant LAB Services, IBM
Doug Mack is a DB2 for i Analytics Consultant in IBM’s Power Systems Lab Services organization, employed by IBM in the United States. Doug currently leads the Analytics team for the DB2 for i Lab Services team delivering Query/400 modernization, DB2 Web Query, Data Warehouse design... Read More →

Thursday April 27, 2023 8:00am - 9:00am MDT
Plaza Court 4
  • Session Level All
  • Audience System administrators, developers, and end users that run a lot of queries. Management too, of course!