If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > DB2 > SQL6031N when creating an instance

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 10-07-04, 13:27
pinecone pinecone is offline
Registered User
 
Join Date: Apr 2004
Posts: 58
Question 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.
Reply With Quote
  #2 (permalink)  
Old 10-07-04, 14:10
bmujeeb bmujeeb is offline
Registered User
 
Join Date: Mar 2004
Posts: 448
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,

Mujeeb
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On