The 2022 IDUG North America Db2 Tech Conference will be IDUG's FIRST hybrid event and the FIRST event since the new release of Db2 13. You don't want to miss this! Check out the Presentations & Presenters we have lined up and take advantage of our first time attendee and hybrid discounts on registration. We can't wait to see you in Boston July 11-14!

IDUG President Iqbal Goralwalla shares his excitement for the upcoming IDUG 2022 North American Db2 Tech Conference July 9-14 in Boston, USA. Iqbal encourages readers to check out the Daily Schedule Grid, registration discounts, and to submit abstracts for the 2022 IDUG EMEA Db2 Tech Conference before the upcoming deadline.

Tuning SQL queries for optimal application performance is a key aspect of application development and administration. Proactive tuning of queries allows improved application throughput and reduces response times.

In this blog we will be discussing about the following key SQL performance tuning features: Capture SQL from statement cache, Visual Explain, Statistics advisor and Capture Query environment.

by Adrian Burke

Not all distributed workloads are well-behaved, predictable, uniform in execution, or should be treated equally. Most Db2 technicians are not able to calculate the total possible number of connections or even threads that could inundate their subsystem at any moment. In this API economy and ever-increasing Mobile workloads there are certain proactive measures which can be put in place to protect the security and availability of you Db2 for z/OS landscape.

Check out the IDUG Db2 Educational Channel on YouTube!