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.

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

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

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.

Hi nagapradeep,
What does your log file say?
Can you check the same and post the error message here?
thanks