home 
 
 
 
nlfr
 
Home
About ABIS
Services
Courses
Resources
Contact
MyABIS
All CoursesbalkjeGeneral » Introduction to HW & SW » TracksOperating systems » MVS - 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 » TOGAF » PRINCE2 » Programming languages » Internet development » Object Oriented systems » Java » IBM development tools » SAS » XML » SOA & web servicesSystems management » ITILbalkjePractical informationRegistration 
Visual Explain and the Optimisation Service Center

Intended for

DB2 developers and database administrators who want to improve their productivity when using EXPLAIN for performance analysis and tuning.

Background

Sufficient knowledge of DB2 performance aspects (from either of the two courses Using DB2 for z/OS or 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 install, setup and use the Visual Explain graphical front end to DB2's EXPLAIN functionality. Also VE's successor, the OSC, will be treated, together with a brief introduction into the many new EXPLAIN tables that were introduced in version 9 of DB2 for z/OS and retrofitted to v8.

Main topics

To be announced.