Hai,

how can i rename the systems name of a local db2 v8.1 ?
i can change the hostname but i was unable to find out where to change the db2 system name. Configuration Assistant cannot change the local system. Changing the db2 registry DB2SYSTEM also have no effect.

thanks in advance
Adam AC

What platform are you running on? DB2 is very finicky so approach with caution.

Regards,
AC

We are running on windows 2000

Regards,
Adam AC

Are you thinking of renaming the instance or the database?

You may want to catalog the admin local node and uncatalog the original node.
E.g.
db2 catalog admin local node <node-name> SYSTEM <system-name>
db2 uncatalog node <original-node-name>

For more details try:
db2 ? catalog local node

Doing a little digging on db2 information center and
found the solution, it seem DAS configuration can only change from command line. That teach me not to rely on control center and configuration assistant to deeply.

Thank all for your help

Regards
Adam AC


UPDATE ADMIN CONFIGURATION Command

Modifies specified entries in the DB2 Administration Server (DAS) configuration file. The DAS is a special administrative tool that enables remote administration of DB2 servers.

When you install the DAS, a blank copy of the configuration file is stored on each physical partition. You must create entries in each copy. You can specify the following DAS configuration parameters to be used the next time you start the DAS:

* Name of the DB2 Server System - db2system
* DAS Administration Authority Group Name - dasadm_group
* Scheduler Mode - sched_enable
* Tools Catalog Database Instance - toolscat_inst
* Tools Catalog Database - toolscat_db
* Tools Catalog Database Schema - toolscat_schema
* Execute Expired Tasks - exec_exp_task
* Scheduler User ID - sched_userid
* Authentication Type DAS - authentication

The following DAS configuration parameters can be specified originally and then later changed while the DAS is online:

* DAS Discovery Mode - discover
* SMTP Server - smtp_server
* Java Development Kit Installation Path DAS - jdk_path
* Location of Contact List - contact_host
* DAS Code Page - das_codepage
* DAS Territory - das_territory