467,923 Members | 1,778 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 467,923 developers. It's quick & easy.

instance creation problem

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
  • viewed: 5989
Share:
1 Reply

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.

Similar topics

6 posts views Thread by Dmitry Karneyev | last post: by
18 posts views Thread by Steve Barnett | last post: by
5 posts views Thread by JH | last post: by
13 posts views Thread by JohnQ | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.