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 > Problem with creating node using db2ncrt

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 08-18-09, 19:05
WooKasZ WooKasZ is offline
Registered User
 
Join Date: Aug 2009
Posts: 2
Problem with creating node using db2ncrt

Hello !
I have a problem with creating node using db2ncrt tool.

I have two computers:
1. DB2: ESE V9.5
IP: 192.168.0.2
Name: db2ese001
Instance name: db2inst1
Windows XP, firewall is off
Instance created with instruction: db2icrt -s ese -r 50001,50005 -u db2admin,admin db2inst1

2. DB2: ESE V9.5
IP: 192.168.0.5
Name: db2ese004
Instance name: db2inst4
Windows XP, firewall is off

On both computers DBM is working and I have admin privileges.

I'm trying to create node on computer#2 by typing on computer #1:
Code:
db2ncrt /n:1 /u:db2admin,admin /i:db2inst4 /m:db2ese004 /p:0 /g:192.168.0.5
After that I am recieving following error:
Code:
DBI1924N. The computer name is not valid.
Ping is working perfectly and I don't know what is the problem. I tried many combinations of db2ncrt instruction with same result.
Is there something that I must do before i can create node ?

Thanks in advance for help!


Regards
WooKasZ
Reply With Quote
  #2 (permalink)  
Old 08-20-09, 02:42
przytula_guy przytula_guy is offline
Registered User
 
Join Date: Apr 2006
Location: Belgium
Posts: 1,159
according this sample
To add a new database partition server to the instance TESTMPP on the instance-owning computer SHAYER, where the new database partition server is known as database partition 2 and uses logical port 1, enter the following command:

db2ncrt /n:2 /u:QBPAULZ\paulz,g1reeky /i:TESTMPP /m:TEST /p:1 /oHAYER /h:TEST
/o is the computername and /m the instancename
see db2ncrt - Add Database Partition Server to an Instance
__________________
Best Regards, Guy Przytula
Database Software Consultant
DB2 UDB LUW Certified V7-V8-V9-V9.7 DB Admin - Dprop..
Information Server Datastage Certified
http://www.infocura.be
Reply With Quote
  #3 (permalink)  
Old 01-05-10, 18:24
WooKasZ WooKasZ is offline
Registered User
 
Join Date: Aug 2009
Posts: 2
So according to my configuration can you tell what should I type and on which machine ?
I've used db2ncrt command exactly like in manual and it didn't work.

Maybe there is a problem with network ports ? Did I miss something during instance creation ?

I noticed that when I trying to add partition, 'db2ese004' machine is receiving packets. I used command:
db2ncrt /n:1 /u:db2admin,admin /i:db2inst1 /p:0 /m:192.168.0.5 /h:192.168.0.5 /o:db2ese001
but still same error occurs
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