DB2 1 Administration using Navigator for 1

Duration: 
2 days
Codes: 
DB2
Versions: 
NULL

Overview

After attending delegates will, using Operations Navigator, be able to:

  • Create and manage tables and other database objects.
  • Create and manage libraries and journals.
  • Create and manage SQL.
  • Run and debug SQL scripts.
  • Analyse SQL script performance.
  • Display the SQL running in an iSeries/i5 job.

Audience

This course is well suited to iSeries/i5 operators, administrators and programmers who wish to take advantage of the database component of IBM's Navigator for i (Operations Navigator).

Prerequisites

A good familiarity with the iSeries/i5, and its database, is necessary to attend this course. A basic knowledge of SQL is also required.

Course Outline

  • Libraries and collections.
  • SQL Scripting.
  • Query attributes.
  • Current Job SQL.
  • Performance monitoring.
  • Visual explain.

Thinking about Onsite?

If you need training for 3 or more people, you should ask us about onsite training. Putting aside the obvious location benefit, content can be customised to better meet your business objectives and more can be covered than in a public classroom. It's a cost effective option.

Submit an enquiry from any page on this site, and let us know you are interested in the requirements box, or simply mention it when we contact you.

Upcoming Dates

  • GREEN This class is Guaranteed To Run.
  • SPVC - Self-Paced Virtual Class.
  • Click a Date to Enroll.
Course Location Days Cost Date
Glasgow
Glasgow2 3750 £3750 2019-09-16
Midlands
Birmingham2 6250 £6250 2019-09-16
Manchester
Manchester2 2500 £2500 2019-09-16