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 > db2 partition

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 10-31-08, 04:56
sgmane sgmane is offline
Registered User
 
Join Date: Jul 2005
Posts: 19
db2 partition

Iam into setting up db2 partition (either db2 v8 and above or db2 v9). (LUW)
Can anyone give me the following?

* Installation on windows
* Installation on unix (any flavour)
* Any documents that you can direct me. (any links, pdf's etc)

Do let me know, that will be much help to me.
thanks
Reply With Quote
  #2 (permalink)  
Old 10-31-08, 05:03
madhu_kaza madhu_kaza is offline
Registered User
 
Join Date: Apr 2008
Posts: 39
Try the following steps

Setting up DPF environment on Windows machines:
1. CREATE MPP INSTANCE
db2icrt MPP -s ese -u administrator,mypasswd -r 50000,50004
Format: db2icrt <instance-name> -s <type of instance which is ese for DPF> -u username,password -r <starting port number>,<ending port number>
These port numbers should not be listed in services file.
2. set DB2INSTANCE=MPP
Set it the instance just created;
3. Run following commands to create 3 nodes:
db2ncrt /n:1 /u:<username>,<passwd> /i:MPP /p:1
db2ncrt /n:2 /u:<username>,<passwd> /i:MPP /p:2
db2ncrt /n:3 /u:<username>,<passwd> /i:MPP /p:3
4. db2 terminate
5. db2stop force
6. db2start
This will show 3 nodes started successfully.

Thanks,
Madhavi
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