Database Migration Using Standard Data Unload and Load Procedures On z/OS Platform

Database migration is the process of upgrading database management system to a more current release. There are situations when the regular migration method cannot be used. Problems occur when a large amounts of data needs to be transferred from one system to the target system, when there is a big release difference between them and when time is limiting factor. In that case an alternative method must be used. In this paper we are proposing a methodology for database migration. This methodology is focused on data migration from one system to the new target system. Standard unload and load procedure is used for data migration. The solutions available on the market are expensive and needs to be properly adapted to meet the customer situation. We have developed DBA 2007 program package containing thirteen programs inside. The program package implements our methodology which is verified on z/OS operating system using DB2 as database management system.