Oracle to DB2 UDB Conversion Guide2003
| < Day Day Up > |
|
3.3 MTK setup
MTK installation step is simple and requires minimum preparation. This section provides MTK installation procedures and the preparation tasks for each platform.
3.3.1 MTK environment preparation
Before installing MTK, you need to verify and set up the environment. Here we provide the procedure and commands you can use in each platform to have the installation environment prepared.
ALL environments
If you choose to manually create a database for migration, rather than let the IBM DB2 Migration Toolkit create it during deployment, then ensure that you execute the following DB2 commands before creating a database:
update database manager configuration using KEEPDARI NO db2stop force db2start
Note | These commands must be run each time that you manually create a new database. |
UNIX environments
You need to make sure that some DB2 related environment variables are set properly, and the needed libraries are included in the path variables. Please check the following:
-
Verify that the $INSTHOME environment variable is set to your DB2 instance directory and that it is properly exported when you start a new environment. For example, in Korn shell type this command:
echo $INSTHOME
The result should be equivalent to:
/home/db2inst1
-
Verify that you can access Java and that it is at least at level 1.3.0. The command is:
java -version
-
For Oracle migrations in UNIX environments, you must include the following libraries in the $CLASSPATH:
{ORACLE_HOME}/jdbc/lib/classes12.zip
Also, include the following entries in the $LIBPATH (AIX):
{ORACLE_HOME}/lib {ORACLE_HOME}/lib32
-
Do not attempt to install and run MTK in a shared environment (for example, /usr/local/mtk). If you want multiple users to run MTK on the same system, they should install and run their own copies, using projects and files local to their home directory. Sharing projects and logs will most likely result in conflicts and overwritten files.
-
Ensure the Netscape directory is in the $PATH. If Netscape is unavailable, MTK will view reports using a Java HTML viewer with limited capability.
-
For Linux, increase the message queue number to at least 128 using command:
sysctl -w kernel.msgmni=128.
Windows environments
To simplify the deployment step, we recommend that you run MTK while logged in with a system user ID that has system administrative authority to the DB2 database, for example, the user ID used to install DB2 UDB.
Note | For the installation and setup of the components to deploy SQL stored procedures to a UNIX or Windows system, please refer to the following IBM DB2 UDB publications:
|
3.3.2 MTK UNIX installation
Here are the steps to install MTK on UNIX:
-
Ensure you have the necessary hardware and software requirements, as listed in the preceding section.
-
Log in with the user ID under which you will install MTK.
-
Do not install MTK as root. If you are not going to deploy to DB2 UDB on this machine, use any user ID but root. If you are going to deploy to a DB2 database, install MTK using a user ID in the db2admin group.
-
Download MTK from the MTK download page into a newly created directory.
-
Expand the package:
Please note that the MTK distribution file name may vary in releases. The command to expand the package on each platform remains the same though.
AIX:
uncompress db2mtk_V1_1_a_aix.tar.Z using the command
tar -xvf db2mtk_V1_1_a_aix.tar
Solaris:
Uncompress db2mtk_V1_1_a_sun.tar.Z using the command:
tar -xvf db2mtk_V1_1_a_sun.tar
Linux:
Uncompress the file using command:
tar zxvf db2mtk_V1_1_a_linux.tar.GZ
-
Launch the IBM DB2 Migration Toolkit from the directory in which it was installed by typing:
./MTKMain
3.3.3 MTK Windows installation
Here are the steps to install MTK on Windows:
-
Ensure you have the necessary hardware and software requirements, as listed in the preceding section.
-
Download MTK from the MTK Download page into any directory.
-
Unzip and extract the package contents.
-
Run Setup.exe
The installation will default to the C:\MTK directory.
-
To launch the IBM DB2 Migration Toolkit, click:
Start -> Programs -> DB2 Migration Toolkit -> Toolkit
| < Day Day Up > |
|