Verhoef Training

11 Kingsmead Square, Bath, BA1 2AB.
Tel: 01225 339705 Fax: 01225 339671




DB2 400 Administration using Operations Navigator




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.

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

© 2007 Verhoef Training, Ltd.