Upgrading DB2® V7 to DB2 V9

By Frederick Rathweg
TxMQ Middleware Multi-Platform E-Commerce Specialist
If you’ve decided to upgrade your system to the newest version of DB2® keep in mind that it may require migration of your environment components.
Understanding what may go wrong in the installation is a big step in ensuring the upgrade is completed smoothly and successfully.
Below I have listed five high-level points to keep in mind while you’re upgrading your system to the newest version of DB2.

  1. Disk Space – The upgrade process will require additional disk space. Before beginning the process, make sure you have enough disk space to complete the process successfully. Here is a helpful reference for required disk space for DB2 v9.7 for Linux, UNIX, and Windows.
  2. Pre-requisites – As with any new installation, you will want to ensure that your system meets all the requirements for the upgrade. Check your software and operating systems and ensure that all other software interfacing with DB2 will be compatible. Refer to this article for the necessary prerequisites for successful installation.
  3. Test Environment – It’s always a good idea to upgrade DB2 servers in a test environment. This allows you to address any problems during the upgrade process and evaluate the impact of the changes on your system. Here is some information on test environments.
  4. Product Licensing – Before installing the new version of DB2, make sure you have licensed and registered your product with IBM®. Refer to this link for more information.
  5. Plan & Research – Give yourself time before the upgrade process to really research the newest version of DB2. Allow yourself to become familiar with the product and take time to explore the variety of new features it has to offer. Some of those features can be found here.


About Frederick James Rathweg

Fred is an independent consultant. He has many years of experience in security and network management, software development and systems programming, as a project leader, network communications designer and applications and systems architect.
This experience has led to his current passions, which include:

  • Cyber security and supply chain risk management
  • E-commerce
  • Cross platform integration of diverse businesses to build successful enterprises

His current technical focus is z/OS system migration, cross platform integration and migrating legacy SNA networks to TCP/IP, OSA and Enterprise Extender.
Rathweg is a retired US Army Infantry Officer. He has a BA in Business Management from St. Leo College. In addition he studied Law at Woodrow Wilson College of Law, and obtained an MBA from Webster University.
In his spare time, he is a part time Sivananda YOGA teacher. He is currently working towards the completion of his Ph.D  in Cyber Security at the Harris Institute for Assured Information, Florida Institute of Technology.
Rathweg has published a series of IBM red books about Communications Server (CS):

  1. IBM z/OS V1R11 Communications Server TCP/IP Implementation Volume 1: Base Functions, Connectivity, and Routing
  2. IBM z/OS V1R11 Communications Server TCP/IP Implementation Volume 2: Standard Applications
  3. IBM z/OS V1R11 Communications Server TCP/IP Implementation Volume 3: High Availability, Scalability, and Performance
  4. IBM z/OS V1R11 Communications Server TCP/IP Implementation Volume 4: Security and Policy-Based Networking

He also assisted in the publishing of ABCs of z/OS System Programming Volume 4: Communication Server, TCP/IP, and VTAM.

About TxMQ

Since its inception, TxMQ has specialized in Mainframe software and mainframe systems support offerings. As mainframe software and mainframe applications and subsystems like DB2, z/OS, CICS, MQ, and DB2 continued to grow in popularity, so too did TxMQ’s offerings.
These expanded to include technologies like virtualization solutions including Linux Virtualization, network Virtualization (Cloud Computing), and desktop Virtualization, as well as mainframe modernization.
As the web became more prevalent and a part of the enterprise, we followed IBM’s offerings and added skilled resources and SME’s in areas like WebSphere, BPM and SOA, including both Lombardi, and Metastorm (now a part of open text), as well as DataPower.
Contact us today at 716-636-0070 ext 29, or email [email protected].