3/24/2007

db2icrt error

Just now,met with a DBI1703E error when issuing db2icrt command.
I checked the db2nodes.cfg, hostname, /etc/hosts, /etc/services and found no problem.
after a short difficult time, customer said they changed the host name...
then, reboot, everything is OK...
some material I get from Internet, also FYI in comments...

2 comments:

Yonghang Wang 说...

Program name = db2idbm
Instance home dir = /home/db2inst1, Sysadm group = db2iadm1
Instance type = 1, Auth type = server
SQL6031N Error in the db2nodes.cfg file at line number "1". Reason code "10".
Update DBM cfg SYSADM_GROUP errcode = 8

>>>>> Error message = SQL6031N Error in the db2nodes.cfg file at line
number "1". Reason code "10". <<<<<

DBI1703E No valid service name or port number found.

checklist:
1) db2nodes.cfg
2) /etc/hosts 664
3) hostname,uname -a

----------------------------------------------------------------------------
Program name = db2idbm
Instance home dir = /home/db2inst1, Sysadm group = db2iadm1
Instance type = 1, Auth type = server
SQL6031N Error in the db2nodes.cfg file at line number "1". Reason code "11".
Update DBM cfg SYSADM_GROUP errcode = 8

>>>>> Error message = SQL6031N Error in the db2nodes.cfg file at line
number "1". Reason code "11". <<<<<

DBI1703E No valid service name or port number found.

checklist:
0. db2nodes.cfg
1. /etc/nsswitch.conf 644
2. /etc/nsswitch.conf include row: "services: files"

Yonghang Wang 说...

AIX hostname change
---------------------
1. smit tcpip > Minimum Configuration & Startup > en0 > HOSTNAME
2. vi /etc/hosts

chdev -l inet0 -a hostname=NEW_HOSTNAME