Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2009

    Lightbulb Unanswered: 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,


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

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


    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 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.

  2. #2
    Join Date
    Jul 2005
    What does your db2nodes.cfg file contain?
    It has to contain the partition details of the partition you are gonna use.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts