var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: SQL6031N when creating an instance
SQL6031N Error in db2nodes.cfg file at line number "0". Reason code "11". Update DBM cfg SYSADM_GROUP errcode = 8
DBI1703E No valid service name or port number found.
Explanation: No valid service name or port number for this instance can be found in the TCP/IP services file. This information is either missing or invalid.
Got this error when creating an instance (v8.1) on AIX 5.2.
The service name and port number entry was created after we ran the create instance command:
./db2icrt -u db2fencp db2p
Also checked on the /etc/services file. No other service is using the same port number. Since the instance was not created successfully, no db2nodes.cfg file was found in $HOME/sqllib directory.
Any suggestions or recommendations would be greatly appreciated.
Thanks in advance.
Try to use that
1. First create an entry into the /etc/services file
./db2icrt -a SERVER -p <name in service file> -u <fence_user> <instance_owner>
or use any port that are not in use wiht out changing the services file
./db2icrt -a SERVER -p <port_no> -u <fenceowner> <instance_owner>
regards & thanks,