入左 TVB 做臨記…
o係 TVB 既 canteen 食左幾餐 lunch，今日終於都見到 D 高級少少既小生、姐仔.... 有方中信，譚小環等；有個妹妹仔仲走去問小環姐影相同攞簽名 tim...
放工時食蕉哥哥唔俾我搭廠車，仲趕左我出門口... 玩左一陣既荒島飄流，好在有高人指路教我去揾拾荒者之家 298E，唔係都唔知點返屋企 lu...
Anyway, 飄流之際有著落日、藍天為伴，特然間覺得自己好似去左旅行一樣。回想起，不知多久以前和某同事入 AA，都有著同樣既感覺...
剛過去既公司聚會
為興祝同事、舊同事既生日，於同一日內飲茶、Bowling、BBQ，完全無 buffer 既一日；再加上 0500 至 1100 既工作，倦透了。
還在忙碌中，相先出一張。
DB2 Change Server Hostname How To
A step by step guide for updating your db2 server after a server hostname update.
Checklist of item to change:
- 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 - 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 - 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!!
