July 25, 2008

DB2 Production (DSNP) and Data Warehouse (DSNW) Upgrade to Version 8

DB2 Production (DSNP) and Data Warehouse (DSNW) Upgrade to Version 8

CIT is upgrading DB2 to version 8.  The final phase of the DB2 development subsystem (DSND) was completed on July 7, 2008.  The upgrades of production (DSNP) and data warehouse (DSNW) will be done in two phases: compatibility mode and production mode. 

In compatibility mode, the subsystem will be migrated to the new release without new functions for DB2 version 8.  Customers should test their applications after this phase to ensure that their applications continue to function properly.  Once the upgrade to production mode occurs, fallback to DB2 version 7 will be prohibited.

In production mode the use of new DB2 version 8 functions is allowed.

DB2 production subsystem (DSNP)

On Monday, August 11, 2008, from 8:00 p.m. to 2:00 a.m., the DB2 production subsystem (DSNP) will be migrated to compatibility mode.  Customers should complete their testing by August 21.

On Monday, August 25, 2008, from 8:00 p.m. to 2:00 a.m., the DB2 production subsystem (DSNP) will be migrated to production mode. 

DB2 data warehouse subsystem (DSNW)

On Saturday, August 16, 2008, from 8:00 a.m. to 2:00 p.m., the DB2 data warehouse subsystem (DSNW) will be migrated to compatibility mode. Customers should complete their testing by September 3.

On Saturday, September 6, 2008, from 8:00 a.m. to 2:00 p.m., the DB2 data warehouse subsystem (DSNW) will be migrated to production mode.

The DSNP and DSNW subsystems will be unavailable during each phase of their respective upgrades.

Need more information?

Known issues and additional information regarding the upgrade, including enhancements available with version 8 and access to DB2 version 8 manuals, are available at http://silk.nih.gov/silk/DB2/VERSION8.

If you have any questions or need assistance, please call the Database Technologies staff at 301-496-9158.