General » Introduction to HW & SW » TracksOperating systems » MVS - OS/390 - z/OS » UNIX - Linux - AIX » Windows » VMwareDatabases, transaction systems and middleware » DB2 for z/OS » DB2 UDB for Linux, UNIX and Windows » Oracle » SQL Server » MySQL » IMS » CICS » WebSphere MQ » WebSphere Application Server » Business intelligence and data warehouseApplication development » Methods and techniques » PRINCE2 » Programming languages » Internet development » Object Oriented systems » Java » IBM development tools » SAS » XML » SOA & web servicesSystems management » ITILPractical informationRegistration DB2 administrators and application designers who want to fine-tune DB2's optimisation strategies.
Sufficient knowledge of DB2 performance aspects (see courses DB2 for z/OS SQL performance and DB2 for z/OS database administration).
Peter Vanroose.
1 evening (2 hours).
This evening session is one in a series of six where we will bring you up-to-date on some selected topics related to DB2 for z/OS. The individual sessions can be followed independently, or you may sign up for the full series.
In this session you will learn how to setup optimisation hints to force the use of a certain access path. This can be useful in situations where the optimiser would otherwise select an inefficient implementation, or just to "freeze" the currently well behaving access path. Caveats, "do"s and "dont"s will also be treated, and alternatives will be mentioned as well.
To be announced.
