View online
More options
Others who downloaded this publication also downloaded ...
Abstract
DB2 UDB for iSeries Database Navigator allows database administrators to see, in graphic detail, the database that they are trying to administer. This redpaper explains the new Navigator features that provide the ability to view pictorial representations of your entire database (or parts of it) using the new "Map your database" function. This redpaper also explains the complex relationships between tables, indexes, constraints, etc.
Within Database Navigator, a new function allows a table, index, constraint, etc., to be re-engineered using SQL. This can also be done for some non-SQL created objects. Non-SQL created objects are objects created using DDS (for example, physical and logical files, constraints, etc.).
There are also many new database administration functions and enhancements that affect the look and feel of Operations Navigator.
This redpaper introduces Database Navigator and answers the following questions:
- What is Database Navigator?
- How do you find relationships in databases prior to V5R1?
- How do you use Database Navigator?
- How do you use the SQL sample database supplied in V5R1?
- How do you reverse engineer an existing database using the new Generate SQL function?
Table of contents
Chapter 1. Database Navigator
Chapter 2. Using Database Navigator
Chapter 3. Reverse engineering and Generate SQL