iSeries Navigator for IBM i5/OS and OS/400 is the graphical interface to manage your IBM eServer iSeries runtime environment. V5R3 iSeries Navigator contains major functions and interface enhancements over previous releases.

This IBM Redbooks publication presents an overview of all V5R3 iSeries Navigator functions to manage and administer DB2 Universal Database (UDB) for iSeries. It serves as a companion guide for the database administrator to use DB2 UDB for iSeries. This book includes the latest announced features in V5R3 that iSeries Navigator provides for the database administrator of DB2 UDB for iSeries.

This book includes the new graphical interface provided for database in V5R3. In addition, it covers the following topics.

• Definition of tables, indexes, views, and other database objects

• Constraint definition and management

• Database Navigator maps

• Reverse engineering and Generate SQL

• Run SQL Script center

• Visual Explain

Part 1. Basic concepts

Chapter 1. Introducing DB2 Universal Database for iSeries

Chapter 2. Introducing iSeries Navigator

Part 2. Database administration

Chapter 3. Working with databases using iSeries Navigator

Chapter 4. Defining and managing constraints

Chapter 5. Database Navigator maps

Chapter 6. Reverse engineering and Generate SQL

Chapter 7. Run SQL Script Center

Chapter 8. Visual Explain