Loading…
Attending this event?
THE BEST IBM i & POWER SYSTEMS EDUCATION.When you come to POWERUp, you’ll be able to customize your experience. Choose from 300 sessions, covering over 20 areas of IT, when you plan your schedule. Visit the largest Expo of its kind and meet the experts behind the solutions. Attend social events to meet renowned speakers and peers alike. This conference is structured to give you the pure education and professional connections needed to best enhance your career. Are you ready to POWERUp?

Exhibitor Hall: https://www.expocad.com/host/fx/common/s24/exfx.html

Exhibitor Hall Map Here 
Back To Schedule
Tuesday, May 21 • 2:45pm - 3:45pm
304: Run Away 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
EVALUATION
Having negative performance impacts from query tools like Query/400, QMF, Showcase, Tableau and others because of the "query from heck" eating up system resources? Is your system open to security exposures from wide-open ODBC type connections? This session will cover options including using the new-ish Db2 Query Supervisor to control and/or audit long-running queries.

Learning Objectives:
1. Learn about the Db2 Supervisor to control and/or audit long running queries.
2. Gain insight into the tools you can use to monitor, tune, and prune queries.
Speakers
avatar for John Westcott

John Westcott

Db2 for i Consultant and Team Lead, IBM
John Westcott is the Db2 for i Team Lead in IBM Technology Expert Labs. John is highyly skilled in SQL, RPG, Data Analytics, Rest API, and both database and application modernization. John has over 35 years of experience on IBM i and it's past family of names. John has a storied career... Read More →

304 Run Away Queries Got You Down pdf
Tuesday May 21, 2024 2:45pm - 3:45pm CDT
Meeting Room 201C 1508 Houston St, Fort Worth, TX 76102
  Database
  • Session Level Intermediate
  • Audience Anyone concened with managing system performance

Attendees (24)