What's New

Migration

Version 5

Migrating to Version 5

Support is provided to allow back-level DB2 databases and directories to be converted to a format usable by DB2 Universal Database Version 5. The following is a list of DB2 database releases that are supported in the DB2 Universal Database Version 5 database migration process:

• DB2 for OS/2 Version 1.x and Version 2.x
• DB2 for AIX Version 1.x and Version 2.x
• DB2 for HP-UX Version 2.x
• DB2 for Solaris Operating Environment Version 2.x
• DB2 for Windows NT Version 2.x
• DB2 for Windows 95 Version 2.x
• DB2 Parallel Edition for AIX Version 1.x to Version 5

See the Quick Beginnings manuals for details.

With the addition of all the new features in this release, some incompatibilities have been introduced. They are described in the Quick Beginnings manuals.

Version 5.2

Migrating to Version 5.2

Support is provided to allow back-level DB2 databases and directories to be converted to a format usable by DB2 Universal Database Version 5.2. The following is a list of DB2 database releases that are supported in the DB2 Universal Database Version 5.2 database migration process:

• DB2 for OS/2 Version 1.x and Version 2.x
• DB2 for AIX Version 1.x and Version 2.x
• DB2 for HP-UX Version 2.x
• DB2 for Solaris Operating Environment Version 2.x
• DB2 for Windows NT Version 2.x
• DB2 for Windows 95 Version 2.x
• DB2 Parallel Edition for AIX Version 1.x

See the Quick Beginnings manuals for details.

With the addition of all the new features in this release, some incompatibilities have been introduced, including:

• SQLCODE -311 will be returned when the length value of a varying length string is found to be greater than the maximum length allowed (the SQLLEN value). Prior to Version 5.2, SQLCODE -804 was returned.
• SQLCODE -804 will be returned if the SQLLEN value associated with a particular variable is negative. Prior to Version 5.2, SQLCODE -311 was returned.

For more information on incompatibilities see the Quick Beginnings manuals.

Note:

No migration is required for DB2 Universal Database Version 5 customers moving to Version 5.2. However you should run the db2upd52 command to enable Version 5.2's new functionality for your catalogs and existing databases. See the Quick Beginnings manuals for details.

[ DB2 List of Books | Search the DB2 Books ]