Skip to main content

Data Management for zOS Optimizing Query Performance

This demonstration shows how a developer and DBA at the fictional e-commerce company work together using IBM Data Studio to improve the performance and stability of their business-critical Web application that relies on IBM DB2 for z/OS customer data. By reducing software cycles and stabilizing data access, the team reduces software costs and improves the rate of completed customer orders, directly improving the business’s bottom line.

Optimizing Query Performance

The DBA and developer work together to quickly solve a critical query performance problem using DB2 Optimization Expert for z/OS.

Option Purpose Duration/size

View demo in new window

7 min 30 sec

View offline (Windows)

10.582 MB

View offline (other)

10.119 MB

Access text version

28.0 KB

Optimizing Existing JDBC Applications

The JK team uses pureQuery with their existing JDBC application to improve performance and stability of that application, with no code changes required.

Option Purpose Duration/size

View demo in new window

6 min 28 sec

View offline (Windows)

7.405 MB

View offline (other)

6.943 MB

Access text version

28.0 KB