DB2 Connect Quick Beginnings for UNIX**

Migrating from Previous Versions of DB2 Connect

DB2 Connect Version 7 supports the migration of DB2 databases and instances created with DB2 Connect Version 5.x and Version 6. If you are migrating from one of these versions to DB2 Connect Version 7, you should prepare your databases and instances before installing DB2.
Note: The only databases that may exist within a DB2 Connect Enterprise Edition server instance is a DB2 transaction manager database. This database is used by DB2 to store transaction state information for DB2 coordinated transactions. For more information on transaction managers, refer to the DB2 Connect User's Guide.

Preparing Databases and Instances for Migration

This section describes how to prepare existing DB2 Version 5.x databases and instances for migration to a format usable by DB2 Version 7. If you want to migrate more than one instance, you must repeat these steps for each instance.

You must be logged in as the instance owner to complete these steps.

To prepare your databases for migration:

Ensure that there are no applications using any databases owned by the DB2 instance you are preparing to migrate. To get a list of all applications owned by the instance, enter the db2 list applications command. If all applications are disconnected, this command will return the following message:
```
   SQL1611W No data was returned by the Database System Monitor.
   SQLSTATE=00000
```
You can end a session by entering the db2 terminate command.
Ensure that all databases are cataloged. To view a list of all the cataloged databases in the current instance, enter the following command:
```
   db2 list database directory
```
Make a backup copy of all Version 5.x databases. You do not have to back up Version 6 databases. Refer to the Administration Guide for your DB2 product for information on making a backup copy of a database and to the Command Reference for the syntax of the backup command.
When all applications are complete and you have backed up your databases, stop all database server processes owned by the DB2 instance by entering the db2stop command.
Stop the DB2 license daemon by entering the db2licd -end command.
Stop all command line processor sessions by entering the db2 terminate command in each session that was running the command line processor.
Ensure that the db2profile (bash, Bourne, or Korn shells) or db2cshrc (C shell) instance environment setup script, under the instance's INSTHOME/sqllib/ directory, is of the proper shell syntax.
If necessary, ensure that each export statement is separated into different lines. For example:
```
   DB2INSTANCE=db2inst1       //bash, Bourne, or Korn shells
   export DB2INSTANCE
 
   set DB2INSTANCE=db2inst1   //C shell
```

Your Next Step

After you have determined that your system meets all hardware and software requirements, and after you have prepared any existing databases and instances for migration, you can now install DB2 Connect Version 7.

[ Top of Page | Previous Page | Next Page ]