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
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
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.
db2 "dbpartitionnum 1 add dbpartitionnum hostname 172.17.4.147 port 1 without tablespaces"
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: