Download Up and Running with DB2 on Linux

Transcript
issued to the instance from the Control Center or the Configuration Assistant.
This design reduces the overhead that exists when one administrative
coordinator node is spread across multiple partitions in an instance and helps to
balance incoming connections. If you are running in a single partition, you still
have to migrate DAS to use the Control Center.
If you do not want to keep your existing configuration, you can just drop the DAS
and create a new one.
If you do not have a DAS in any database partition server, create a new one. You
can find more details about DAS creation in Chapter 2, “Installation” on page 25.
DAS migration
The following steps show how to migrate a DAS from Version 8 or 9.1 to DB2
9.5:
1. Log in as root user.
2. Go to $DB2DIR/instance.
3. Enter the command:
./dasmigr
Example 4-13 shows a dasmigr execution:
Example 4-13 The dasmigr command
mensa:/opt/ibm/db2/V9.5/instance # ./dasmigr
SQL4407W The DB2 Administration Server was stopped successfully.
SQL4406W The DB2 Administration Server was started successfully.
DBI1070I Program dasmigr completed successfully.
Tools catalog database migration
If you want to use your existing scripts and schedules that were created in
Version 8 or Version 9, you must perform the following steps:
1. Obtain the name of the instance and the tools catalog database through the
db2 get admin cfg command; see Example 4-14.
Example 4-14 Get tools catalog information
dpfusr1@gemini:~> db2 get admin cfg
Admin Server Configuration
...
Tools Catalog Database
(TOOLSCAT_DB) = TOOLSDB
Tools Catalog Database Instance
(TOOLSCAT_INST) = dpfusr1
Tools Catalog Database Schema
(TOOLSCAT_SCHEMA) = CC
Scheduler User ID
=
Chapter 4. Migration and fix packs
183