Results 1 to 6 of 6
  1. #1
    Join Date
    Nov 2003
    Location
    Jakarta, Indonesia
    Posts
    32

    Unanswered: DB2 Local Systems Rename

    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

  2. #2
    Join Date
    Jan 2004
    Location
    San Antonio, Texas
    Posts
    47

    Talking Re: DB2 Local Systems Rename

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

    Regards,
    AC

    Originally posted by adam_ac
    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

  3. #3
    Join Date
    Nov 2003
    Location
    Jakarta, Indonesia
    Posts
    32

    Re: DB2 Local Systems Rename

    Originally posted by DBAgirl
    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

  4. #4
    Join Date
    Mar 2003
    Posts
    343
    Are you thinking of renaming the instance or the database?

  5. #5
    Join Date
    Jan 2004
    Location
    Canada
    Posts
    12

    Re: DB2 Local Systems Rename

    Originally posted by adam_ac
    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
    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

  6. #6
    Join Date
    Nov 2003
    Location
    Jakarta, Indonesia
    Posts
    32

    UPDATE ADMIN CONFIGURATION

    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •