Summary

Audience

iSeries/i5 operators, administrators and programmers who wish to take advantage of the database component of Operations Navigator.

Prerequisites

A good familiarity with the iSeries/i5 and its database is required together with a basic knowledge of SQL.

Duration

2 days. Hands on.

Course Objectives

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

Course Content

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