Quick Beginnings for DB2 Universal Database for UNIX

Migrating from SCO OpenServer to SCO UnixWare 7

You cannot migrate databases or instances created using DB2 for SCO OpenServer to DB2 for SCO UnixWare 7. Instead you have to perform the following steps before installing DB2 for SCO UnixWare 7:

1. Install the db2ckmig command on DB2 for SCO OpenServer.

   The db2ckmig command is available in the /cdrom directory on the DB2 Universal Database for SCO UnixWare 7 CD-ROM. Verify that Databases Can Be Migrated describes how to use this command. Before proceeding to the next step, ensure that you correct any errors generated by the db2ckmig command.

2. Backup any databases that you want to migrate - see Pre-Migration.

3. Record instance-level information and drop any instances. Collect the following information using the command line processor:
   • Database manager configuration. Enter the following command:

        db2 get database manager configuration
     

   • Node directory. Enter the following command:

        db2 list node directory show detail
     

     You should note the following details:

     • TCP/IP service names and numbers; these will need to be mapped to /etc/services.

     • Any communications configurations which you will need to set up later.
   • DCS directory. Enter the following command:

        db2 list dcs directory
     

     You should note any communications configurations which you will need to set up later.

   • Database directory for database file systems/locations. Enter the following command:

        db2 list database directory
     

   • Database configuration for log file paths. Enter the following command:

        db2 get database configuration for database
     

   See Migrating Instances for further information.

4. Identify any stored procedures and User Defined Functions (UDFs). All stored procedures, UDFs and user exits must be recompiled and relinked after installing SCO UnixWare 7 and DB2 Version 5.2.

5. Drop all databases and DB2 instances on the SCO OpenServer machine by entering the db2idrop command. See Removing Instances for further information.

6. Install SCO UnixWare 7 and configure the operating system as described in the product documentation.

7. Install and configure DB2 for SCO UnixWare 7 using the recorded instance-level information - see Chapter 3. Installing and Configuring DB2.

8. Restore database backups. Refer to the Administration Guide for further information.
   

   Due to incompatibilities between file system layout and raw device names used in SCO OpenServer and those used in SCO UnixWare 7, Version 2 databases that use DMS tablespaces or SMS tablespaces with containers on absolute paths may need to be restored using the redirected restore command.

9. Verify the database manager and database configuration parameters are tuned for DB2 for SCO UnixWare 7. Refer to the Administration Guide for further information.

To install clients, see Chapter 7. Installing DB2 Clients.

[ DB2 List of Books | Search the DB2 Books ]