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 partitioning in the local machine.

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 04-01-09, 05:23
JeevanEM JeevanEM is offline
Registered User
 
Join Date: Apr 2009
Posts: 2
Lightbulb Problem with partitioning in the local machine.

HI Guys,
I am working with DB2 partitioning feature in Linux 5.0 box.
First I wanted to perform partitioning in the local system.
For that I was running the following command in the console,

Query

db2 "dbpartitionnum 1 add dbpartitionnum hostname 172.17.4.147 port 1 without tablespaces"

After running this command i am getting the following error message,

Error

DB21034E The command was processed as an SQL statement because it was not a
valid Command Line Processor command. During SQL processing it returned:
SQL0104N An unexpected token "1 add dbpartitionnum hostname 172.17.4.147 por"
was found following "dbpartitionnum ". Expected tokens may include:
"<space>". SQLSTATE=42601



Please help me out guys,
I am not able to go ahead any single step.
I will b great-ful to any kind of help.
Thanks IN Advance,
Jeevan Edakkunnath Mana.
Reply With Quote
  #2 (permalink)  
Old 04-03-09, 04:51
sgmane sgmane is offline
Registered User
 
Join Date: Jul 2005
Posts: 19
What does your db2nodes.cfg file contain?
It has to contain the partition details of the partition you are gonna use.
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