Web 1. Special Consideration for DB2 Version 6

IN THIS CHAPTER

• Type 1 Indexes

• Shared Read Only Data

• RECOVER INDEX

• Host Variables Without Colons

• Dataset Passwords

• Stored Procedure Registration

• Synopsis

DB2 Version 6 was officially released in June 1999. This release included many new features such as large objects, triggers, user-defined functions, user -defined data types, and more. However, the item that is most important for every DB2 shop to understand is what is not in DB2 V6. For the first time, IBM removed features from DB2. As such, your organization must prepare its DB2 subsystems for V6 by removing the soon-to-be-unsupported features from your installation.

At this late date, this information is included here for those few shops that still need to migrate to Version 6, as well as for posterity for folks investigating obsolete DB2 features.

Let's examine each of the features that were removed from DB2 as of Version 6.