
|
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.
|