Loading…
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!

Tweet Share
Session Evaluation
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
Speakers
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
  Database
  • Session Level All
  • Audience System administrators, developers, and end users that run a lot of queries. Management too, of course!

Attendees (30)