By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,589 Members | 2,276 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,589 IT Pros & Developers. It's quick & easy.

instance creation problem

P: n/a
Hi, All

I have trouble with db2 instance creation (DB2 9.1.2 on AIX 5.3)

When i run command for instance creation :

../db2icrt -a SERVER -p 50000 -s ese -u db2fenc1 db2inst1

a reciveve error in generated log file db2icrt.log.118872 :

Program name = db2idbm
Instance home dir = /home/db2inst1, Sysadm group = db2grp1
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.

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 is invalid.

If you installed "DB2 Extended Server Edition" product, a
service name must be specified for the instance before using this
command.

User Response:

Specify valid service name and port number for this instance and
enter this command again.

DBI1079I Output is saved in the log file /tmp/db2icrt.log.118872.

Explanation:

All processed and failed operations have been saved into this log
file.

User Response:

Do not modify this file in any way. This file is for IBM
Technical Support reference.

In my /etc/services file the string

db2c_db2inst1 50000/tcp

is presented.

And in /etc/hosts file the string

172.x.x.x aix2

is presented

# uname -a
AIX aix2 3 5 00056B88D700
Where may be a problem ?
Thanks and sorry for my bad english.

Sep 7 '07 #1
Share this Question
Share on Google+
1 Reply


P: n/a

mitrofu...@gmail.com:
Hi, All

I have trouble with db2 instance creation (DB2 9.1.2 on AIX 5.3)
Sorry, All. It's my mistake. Hostname have been wrong.

Sep 7 '07 #2

This discussion thread is closed

Replies have been disabled for this discussion.