Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2004

    Question 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.

  2. #2
    Join Date
    Mar 2004
    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,


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts