Advanced Functions and Administration on DB2 Universal Database for iSeries (0738422320)

Advanced Functions and Administration on DB2 Universal Database for iSeries
English | | | | epub | 5.77 MB

Dive into the details of DB2 Universal Database for iSeries advanced functions and database administration. This IBM Redbooks publication aims to equip programmers, analysts, and database administrators with all the skills and tools necessary to take advantage of the powerful features of the DB2 Universal Database for iSeries relational database system. It provides suggestions, guidelines, and practical examples about when and how to effectively use DB2 Universal Database for iSeries.
This book contains information that you may not find anywhere else, including programming techniques for the following functions:
- Referential integrity and check constraints
- DRDA over SNA, DRDA over TCP/IP, and two-phase commit
- DB2 Connect
- Import and Export utilities
This book also offers a detailed explanation of the new database administration features that are available with Operations Navigator in V5R1. Among the tools, you will find:
- Database Navigator
- Reverse engineering and Generate SQL
- Visual Explain
- Database administration using Operations Navigator
With the focus on advanced functions and administration in this fourth edition of the book, we moved the information about stored procedures and triggers into a new book -- "Stored Procedures and Triggers on DB2 Universal Database for iSeries", SG24-6503.