姥姥石窟

A step by step guide for updating your db2 server after a server hostname update.

Checklist of item to change:

1. DB2 Profile Variable
   
   /> db2set -all
   
   [e] DB2PATH=C:\Program Files\IBM\SQLLIB
   [i] DB2ACCOUNTNAME=PRETTY_GIRL\db2admin
   [i] DB2INSTOWNER=PRETTY_GIRL
   [i] DB2PORTRANGE=60000:60003
   [i] DB2_GRP_LOOKUP=LOCAL
   [i] DB2INSTPROF=C:\PROGRA~1\IBM\SQLLIB
   [i] DB2COMM=TCPIP,NPIPE
   [g] DB2_EXTSECURITY=NO
   [g] DB2SYSTEM=PRETTY_GIRL
   [g] DB2PATH=C:\Program Files\IBM\SQLLIB
   [g] DB2INSTDEF=DB2
   [g] DB2ADMINSERVER=DB2DAS00

2. Admin Local Node Information
   
   /> db2 list admin node directory show detail
   
   Node Directory
   
   Number of entries in the directory = 1
   
   Node 1 entry:
   
   Node name = GENERATE
   Comment = Local Workstation
   Protocol = LOCAL
   Instance name = DB2DAS00
   Remote instance name =
   System = PRETTY_GIRL
   Operating system type = WIN
   
   * make sure you have backup the above information

3. db2nodes.cfg
   
   File Detail:
   
   0 PRETTY_GIRL 0
   

Detail Steps for Renaming the Hostname to HANDSOME_BOY:

/> db2admin stop

/> db2 uncatalog node GENERATE

/> db2 catalog admin local node GENERATE instance DB2DAS00 system HANDSOME_BOY ostype WIN with “New Comment”

Check the node detail:
/> db2 list admin node directory show detail

Node Directory

Number of entries in the directory = 1

Node 1 entry:

Node name = GENERATE
Comment = New Comment
Protocol = LOCAL
Instance name = DB2DAS00
Remote instance name =
System = HANDSOME_BOY
Operating system type = WIN

If okay, then move on:

/> db2 terminate

/> db2set -g DB2SYSTEM=HANDSOME_BOY

Edit the db2nodes.cfg file to the following:

0 HANDSOME_BOY 0

*To locate the db2nodes.cfg
– in Windows, go to DB2_INSTALL_DIR\SQLLIB\DB2\
– in AIX, go to DB2_INSTALL_DIR/SQLLIB/

/> db2admin start

DONE!!