Installing and Configuring DB2 Clients

Migrating Instances

This procedure describes how to migrate DB2 instances that were created using a previous version of a DB2 product.

Before you can migrate an instance to use the latest version of DB2, you must install DB2 Version 5 on your system.

If there are several DB2 instances using previous versions of DB2 products, you do not need to migrate all of these instances at this time. Instances, that are not migrated, will continue to use previous versions of DB2 products.

Each DB2 instance must be migrated separately. To successfully migrate a DB2 instance, you need to perform the following steps:

• Prepare the DB2 instance for migration.

• Migrate the DB2 instance.

Prepare the DB2 Instance for Migration

Before you can migrate a DB2 instance, all applications using any databases, owned by this instance, must be completed or terminated. To prepare a DB2 instance for migration, you need to perform the following steps:

1. Log in as the DB2 instance.

2. Stop all command line processor sessions by issuing a db2 terminate command in each session that was running the command line processor.

   The DB2 instance is now ready for migration.

3. Log out as the DB2 instance.

Migrate the DB2 Instance

After an instance is ready for migration, use the db2imigr command to migrate the instance. You need to perform the following steps:

1. Log in as root.

2. Run the db2imigr command as follows:

      DB2DIR/instance/db2imigr [-d] [-a AuthType] [-u fencedID] InstName
   

   
   

   where	DB2DIR	= /usr/lpp/db2_05_00	on AIX
   		= /opt/IBMdb2/V5.0	on HP-UX or Solaris

   and where:

   -d

   Sets the debug mode that you can use for problem determination

   -a AuthType

   Is an optional parameter that specifies the authentication for the instance. Valid authentication types are SERVER, CLIENT, and DCS. If the -a parameter is not specified, the authentication type defaults to SERVER, if a server product is installed. Otherwise, the AuthType is set to CLIENT.

   Notes:

   1. The authentication type of the instance applies to all databases owned by the instance.

   2. Authentication type, DCE, is valid. However, it is not valid to choose DCE as an AuthType for this command. To enable DCE authentication for a DB2 instance, refer to the Administration Guide.

   -u fencedID

   Is the user under which the fenced user-defined functions (UDFs) and Stored Procedures will execute.

   InstName

   Is the login name of the instance owner.

[ DB2 List of Books | Search the DB2 Books ]