Moving Warehous DB

Possible causes:

Desire to move location of database
Current location does not have enough room for database to grow

The Warehous DB can be moved (migrated) to a different location on the system. Here are the steps to do so.

NOTE: The paths and parameters used here are the defaults when install Tivoli Storage Manager Reporting and Monitoring.

1) Check to make sure the migration tool is installed. Check the directory "C:\IBM\itm\TMAITM6\" for the following files:
KHDENV_MIG
khdmig.jar
migratewarehouse.bat

Note: If these files do not exist under the TMAITM6 directory, the migration cannot be done.

2) Create the new warehouse db on a new drive:
Note: this example will use the D drive and use myware as the database name.

(a) Open a DB2 command window
(b) Run "db2" to enter DB2 command processor
(c) Run "list db directory" to show all databases. The default warehouse db is like the following:
db2 => list db directory
.........................
Database alias = WAREHOUS
Database name = WAREHOUS
Local database directory = C:
Database release level = b.00
Comment =
Directory entry type = Indirect
Catalog database partition number = 0
Alternate server hostname =
Alternate server port number =
.........................

(d) To create new database "myware" on drive "d:" issue the following command:
create db myware on d:

Example:
db2 => create db myware on d:
DB20000I The CREATE DATABASE command completed successfully.

(e) To show all the databases, issue the following command:
list db directory

Example:
db2 => list db directory

The new warehouse db is like the following:
.........................
Database alias = MYWARE
Database name = MYWARE
Local database directory = D:
Database release level = b.00
Comment =
Directory entry type = Indirect
Catalog database partition number = 0
Alternate server hostname =
Alternate server port number =
.........................

3) Edit the file "KHDENV_MIG", and input correct values for the following parameters:

*
* SOURCE WAREHOUSE DATABASE
*
KHD_SOURCE_JDBC_DRIVER=com.ibm.db2.jcc.DB2Driver
KHD_SOURCE_URL=jdbc:db2://localhost:50000/WAREHOUS
KHD_SOURCE_DATABASE_SCHEMA=ITMUser
KHD_SOURCE_DATABASE_USER=ITMUser
KHD_SOURCE_DATABASE_PASSWORD=??????
*
* TARGET WAREHOUSE DATABASE
*
KHD_TARGET_JDBC_DRIVER=com.ibm.db2.jcc.DB2Driver
KHD_TARGET_URL=jdbc:db2://localhost:50000/myware
KHD_TARGET_DATABASE_SCHEMA=ITMUser
KHD_TARGET_DATABASE_USER=ITMUser
KHD_TARGET_DATABASE_PASSWORD=??????
*

Replace ?????? with the correct password.
Edit the KHD_TARGET_URL as needed based on your configuration and database name.

4) Edit the file "migratewarehouse.bat". Uncomment the following lines, and change the value of the red line specifically:

set CLASSPATH=%CANDLE_HOME%\TMAITM6\khdmig.jar

set CLASSPATH=%CLASSPATH%;%CANDLE_HOME%\TMAITM6\tap_cli.jar
set CLASSPATH=%CLASSPATH%;%CANDLE_HOME%\TMAITM6\cnp_vbjorball.jar
set CLASSPATH=%CLASSPATH%;%CANDLE_HOME%\TMAITM6\util.jar
set CLASSPATH=%CLASSPATH%;%CANDLE_HOME%\TMAITM6\kjrall.jar
set CLASSPATH=%CLASSPATH%;%CANDLE_HOME%\TMAITM6\browser.jar

set CLASSPATH=%CLASSPATH%;C:\IBM\db2\java\db2jcc.jar;C:\IBM\db2\java\db2jcc_license_cu.jar

set TMP_FILE=khd_java_home.txt
call %CANDLE_HOME%\InstallITM\GetJavaHome.bat >%TMP_FILE%
set /p KHD_JAVA_HOME= < %TMP_FILE%
del %TMP_FILE%

5) Start the Tivoli Enterprise Monitoring Services, stop Warehouse Proxy, stop Warehouse Summarization and Pruning Agent.

6) Open a command window, navigate to "C:\IBM\itm\TMAITM6", and run "migratewarehouse.bat"

7) After step 6 is completed successfully, re-configure Warehouse Proxy.
Open the Tivoli Enterprise Monitoring Services, right click on Warehouse Proxy and choose Re-configure.

Enter the new warehouse database name like the following:



8) Re-configure Warehouse Summarization and Pruning Agent
Open the Tivoli Enterprise Monitoring Services, right click on Warehouse Summarization and Pruning Agent and choose Re-configure.

Enter the new warehouse database name like the following:



9) In the Tivoli Enterprise Monitoring Services, start Warehouse Proxy, start Warehouse Summarization and Pruning Agent.