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 > Instance Owner creation error for DB2 V9.5

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 03-25-10, 11:35
navch navch is offline
Registered User
 
Join Date: Jan 2010
Posts: 19
Instance Owner creation error for DB2 V9.5

Hi,

I am trying to create the instance owner after installing DB2 V9.5 ESE 64 bits on VMWare ESX 3.5 server. I used the following steps.

1. Install DB2 V9.5 ESE (the message says it is successful)
2. Apply the latest fix pack 5 for DB2 V9.5. (it was successful)

Then tried to create the instance by issuing the following command.
/opt/ibm/db2/instance/db2icrt -u db2fence dwapinst

There was error in creating the instance. When I checked the log file it says

SQL6031N Error in the db2nodes.cfg file at line number "0". Reason code
"11".
Update DBM cfg SYSADM_GROUP errcode = 8
>>>>> Error message = SQL6031N Error in the db2nodes.cfg file at line number "0". Reason code
"11". <<<<<
DBI1703E No valid service name or port number found.

---

So I checked the services file and the tcp/ip ports were not entered at the end of this file. The SQLLIB is not also created.

Can someone please tell me how to fix this problem.

Thanks a lot

Nav
Reply With Quote
  #2 (permalink)  
Old 03-25-10, 11:44
ARWinner ARWinner is offline
Registered User
 
Join Date: Jan 2003
Posts: 3,575
I believe that in creating an instance on a DB server, you must specify the port with the -p option.

Andy
Reply With Quote
  #3 (permalink)  
Old 03-25-10, 11:49
navch navch is offline
Registered User
 
Join Date: Jan 2010
Posts: 19
I used the same steps to install DB2 V9.5 ESE on another physical server and used the same command to create instance.
Reply With Quote
  #4 (permalink)  
Old 03-25-10, 11:53
ARWinner ARWinner is offline
Registered User
 
Join Date: Jan 2003
Posts: 3,575
What port did it use for the server that worked?

Andy
Reply With Quote
  #5 (permalink)  
Old 03-25-10, 11:58
navch navch is offline
Registered User
 
Join Date: Jan 2010
Posts: 19
It is 6000. But I can not use db2 command on the server.
Reply With Quote
  #6 (permalink)  
Old 03-25-10, 12:11
ARWinner ARWinner is offline
Registered User
 
Join Date: Jan 2003
Posts: 3,575
My guess is that the same port on the other server is already in use. What do you mean when you say that you cannot use DB2 command on the server?

Andy
Reply With Quote
  #7 (permalink)  
Old 03-25-10, 12:25
navch navch is offline
Registered User
 
Join Date: Jan 2010
Posts: 19
These are 2 separate servers. For db2 command, for example if I use db2set or db2 get dbm cfg comand, these comands do not work.

Nav
Reply With Quote
  #8 (permalink)  
Old 03-25-10, 12:51
ARWinner ARWinner is offline
Registered User
 
Join Date: Jan 2003
Posts: 3,575
I am assuming the the DB2 commands are not working on the server you are having problems with. That is because you need to issue those commands as the instance owner, and you are having problems setting it up. What happens if you issue the db2icrt command with the -p 55000 option added?

Andy
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