Results 1 to 5 of 5
  1. #1
    Join Date
    Feb 2009
    Posts
    5

    Unanswered: Problem while implementing Database Partitioning Feature

    Hi guys,
    I'm trying to implement DPF and these are the steps that I have implemented.


    Step 1:

    Taken two Linux V5 boxes with DB2 UDB Enterprise Server Edition (ESE) V8.1
    • First Linux box with hostname xxxx
    • Second Linux box with hostname yyyy

    Both the Linux boxes have same username, password and instance.
    It also has same DAS user(dasusr).

    Step 2:

    Force interpartition communication to be performed in memory by setting the DB2 registry variable DB2_FORCE_FCM_BP to YES.

    db2set DB2_FORCE_FCM_BP=YES

    The above variable is set in both of the Linux boxes.

    Step 3:

    Configuring db2nodes.cfg (/home/miracle/sqllib/db2nodes.cfg) as follows on both the Linux boxes.

    0 xxxx 0
    1 xxxx 1
    2 yyyy 0
    3 yyyy 1

    Step 4:

    After implementing these steps when I start the DB2 (db2start) on my first Linux box(xxxx),
    I face the error as

    SQL6031N Error in the db2nodes.cfg file at line number "3". Reason code "10".


    Can anyone tell me where I'm going wrong. Thanks in advance.

  2. #2
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    A non-root installation of a DB2 database product does not support database partitioning. As a result, an add node operation cannot be run. You should not manually update the db2nodes.cfg file. A manual update will result in the display of a SQL6031N error.
    or line 3 : invalid hostname yyyy
    is it contactable - can you ping ??
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified
    http://www.infocura.be

  3. #3
    Join Date
    Feb 2009
    Posts
    5
    Hi przytula, thanks for your response.

    I have done my db2 installation in the root itself. And yes I manually updated the db2nodes.cfg file.

    But I tried it by commands also, as show below

    db2 add dbpartitionnum like dbpartitionnum 1

    Then I faced the error as such
    SQL2032N The "TABLESPACE NODE" parameter is not valid.

    And I tried to ping my 'yyyy' hostname, it was not pinging. Now I have replaced hostnames with IP addresses. With Ips, its pinging.

    Now when I run db2start, this the error I face

    03/19/2009 20:52:33 0 0 SQL6048N A communication error occurred during START or STOP DATABASE MANAGER processing.
    03/19/2009 20:53:04 1 0 SQL6048N A communication error occurred during START or STOP DATABASE MANAGER processing.
    03/19/2009 20:53:35 2 0 SQL6048N A communication error occurred during START or STOP DATABASE MANAGER processing.
    03/19/2009 20:54:06 3 0 SQL6048N A communication error occurred during START or STOP DATABASE MANAGER processing.
    SQL1032N No start database manager command was issued. SQLSTATE=57019

  4. #4
    Join Date
    Apr 2009
    Posts
    2

    Lightbulb

    Hi Guys,
    I am facing the problem while doing DPF,
    THe same step I followed as explained by nagapradeep.But the query for the partitioning has bit change.I am giving the query and the error message I got.PLease help me out.

    Query

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

    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 172.17.4.147 por"
    was found following "dbpartitionnum ". Expected tokens may include:
    "<space>". SQLSTATE=42601



    Thanks in Advance,
    Jeevan Edakkunnath Mana.

  5. #5
    Join Date
    Jul 2005
    Posts
    19
    Hi nagapradeep,
    What does your log file say?
    Can you check the same and post the error message here?
    thanks

Posting Permissions

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