Use IBM InfoSphere Optim Query Workload Tuner 3.1.1 to tune statements in DB2 for Linux, UNIX, and Windows, and DB2 for z/OS that reference session tables

Daniel Zilio is a Senior Software Developer in the IBM InfoSphere Optim Query Workload Tuner team. Previously he was on the IBM DB2 for Linux, UNIX, and Windows Optimizer and Autonomic Computing teams. He has worked on DB design algorithms, explain, DB simulation, self-tuning memory management, XML design selection, automatic statistics collection, the data mart advisor, workload statistical views advisor, collect actuals feature, workload index advisor, workload statistics advisor, access plan comparison, and what-if index analysis.

Cliff Leung is a Senior Technical Staff Member in the IBM Information Management organization at Silicon Valley Laboratory, San Jose. Cliff is the chief architect of the IBM InfoSphere Optim Query Tuner product since 2008, and is responsible for the overall product direction and strategy. Cliff has extensive experience in query compilation, optimization, and performance areas.

Gao Zhong Liang is a Software Engineer in the IBM InfoSphere Optim Query Workload Tuner team.

Guo Bin Zhao is a Software Engineer in the IBM InfoSphere Optim Query Workload Tuner team. He works on the core function part, including explainer, parser, configuration, and Workload Control Center components.

Cheung-Yuk Wu is a Senior Software Developer in the IBM InfoSphere Optim Query Workload Tuner team.

Bian Li is a Software Engineer in the IBM InfoSphere Optim Query Workload Tuner team.

Xin Wu is a Software Developer in the IBM InfoSphere Optim Query Workload Tuner team.

Rui Yang is a Software Engineer in the IBM InfoSphere Optim Query Workload Tuner team. He has worked on Access Plan Explorer, Workload Control Center, Workload Index Advisor, Capture from Explain tables/Event Monitor tables. Previously he was on the IBM DB2 Java Common Access team.