DB2 Version 9.7 for Linux, UNIX, and Windows

Upgrading the DB2 Administration Server (DAS)

Upgrading your DB2® Administration Server (DAS) is only necessary to keep your existing DAS configuration. If your DAS is running on DB2 UDB Version 8, upgrading your DAS is necessary to use the Control Center for administrating instances running on DB2 Version 9.1 or later, task management, and task scheduling.

Otherwise, you can drop your existing DAS and create a new DAS in DB2 Version 9.7.

On Windows operating systems, if you choose to automatically upgrade your pre-Version 9.7 copy and you have a DAS running under this copy, the DAS is also upgraded along with your instances.

The DB2 administration tools and the DAS have been deprecated in DB2 Version 9.7 and might be discontinued in a future release. If you plan to use the Data Source Explorer in IBM® Data Studio to perform database administration tasks, you do not have to upgrade the DAS. Also, you can drop the DAS and the tools catalog database.

About this task

Restrictions

You can have only one DAS per computer.

Before you begin

Ensure that you have SYSADM authority, and root access on Linux and UNIX operating systems or Local Administrator authority on Windows operating systems.

Procedure

To upgrade the DAS:

Log on to the DB2 server as root on Linux and UNIX operating systems or Local Administrator authority on Windows.
Upgrade your existing DAS by running the dasmigr command:
Operating system Command syntax

Linux and UNIX $DB2DIR/instance/dasmigr

Windows %DB2PATH%\bin\dasmigr

Where DB2DIR and DB2PATH indicate the location that you specified during DB2 Version 9.7 installation.

If the DAS is running, the dasmigr command stops the DAS before upgrade and starts the DAS after upgrade.
If you created a tools catalog database and want to use your existing scripts and schedules on the Version 9.7 DB2 Control Center, perform the following steps:
- Upgrade the instance that owns the tools catalog database.
- Upgrade the tools catalog database.
- If you are upgrading to DB2 Version 9.7 from DB2 Version 9.1 or earlier, log on to the DB2 server as a user with SYSADM authority and run the db2tdbmgrcommand. This stops the scheduler before upgrading the tools catalog database and restarts it after the upgrade. If you run this tool from a remote client, you must stop the scheduler at the server before running this command and restart it after running this command.
- Verify that the DAS is configured to access the upgraded tools catalog database by running the GET ADMIN CFG command to display the current configuration settings for the tools catalog database:
```
   db2 GET ADMIN CFG

            Admin Server Configuration
    ...
    Tools Catalog Database                    (TOOLSCAT_DB) = toolsdb
    Tools Catalog Database Instance         (TOOLSCAT_INST) = db2inst1
    Tools Catalog Database Schema         (TOOLSCAT_SCHEMA) = cc
    Scheduler User ID                                       =
```
  Use the UPDATE ADMIN CFG command if you need to change any configuration settings for the tools catalog database.
You should upgrade your tools catalog whether you decide to upgrade your DAS or not.
If you do not upgrade or do not have a tools catalog database, you can create one in a Version 9.7 instance to use the task scheduling capability.

Operating system	Command syntax
Linux and UNIX	`$DB2DIR/instance/dasmigr`
Windows	`%DB2PATH%\bin\dasmigr`

Results

You can now use the Control Center for remote administration of DB2 Version 9.7 instances, as well as pre-Version 9.7 instances.