home 
 
 
 
enfr
 
Home
Over ABIS
Diensten
Cursussen
Resources
Contact
MyABIS
Alle CursussenbalkjeAlgemeen » Introductie HW & SW » TrajectenOperating Systems » MVS - z/OS » UNIX - Linux - AIX » Windows » VMwareDatabases, transactiesystemen en 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 en data warehouseApplicatieontwikkeling » Methoden en technieken » TOGAF » PRINCE2 » Programmeertalen » Internet development » Object Oriented systems » Java » IBM development tools » SAS » XML » SOA & web servicesSysteembeheer » ITILbalkjePraktischInschrijven 
Deze pagina is niet beschikbaar in het Nederlands.
DB2 for z/OS optimisation hints: theory and practice

Intended for

DB2 administrators and application designers who want to fine-tune DB2's optimisation strategies.

Background

Sufficient knowledge of DB2 performance aspects (see courses DB2 for z/OS SQL performance and DB2 for z/OS database administration).

Course leader

Peter Vanroose.

Duration

1 evening (2 hours).

Schedule

No public sessions are currently scheduled. We will be pleased to set up an on-site course or to schedule an extra public session (in case of a sufficient number of candidates). Interested ? Please contact ABIS.

Objectives

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.

Main topics

To be announced.