ADD DBPARTITIONNUM fails on Linux

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Dan van Ginhoven - 02 Jun 2007 16:52 GMT

Hi.

When I try adding a new partion to a database instance on a 4 processer
Linux server I get a time out and a message like "host did not respond
within ...".
When I use the Control Center Wizard, the command runs thru after quite a
while but nothing is changed.

Does DB2 depend on rsh being active?
My SYSOP guys are very reluctant to activate rsh (security breech).
Is there any way I can circumvent rsh.
What happens if I do
* db2stop
* update db2nodes.cfg manually
* db2start
* REDISTRIBUTE DATABASE PARTITION GROUP

\dg

Reply to this Message

Artur - 03 Jun 2007 00:28 GMT

> Hi.
>
[quoted text clipped - 14 lines]
>
> \dg

Dan,

check if you have valid DPF license.

If so, check if rsh daemon is running (as instance owner just try
rlogin to the same machine and check if you can login without
providing a password). By default is it required. If rsh is not
configured (installed, eg. on Suse 10) you can configure DB2 with ssh:

http://www.ibm.com/developerworks/db2/library/techarticle/dm-0506finnie/index.html

-- Artur Wronski

Reply to this Message

Dan van Ginhoven - 04 Jun 2007 17:26 GMT

Hi!

Thanks!

The link was just what I needed. Great link too. Accurate and neat.
Strange that there is no reference to rsh/ssh in the manual.
/dg

> If rsh is not
> configured (installed, eg. on Suse 10) you can configure DB2 with ssh:

http://www.ibm.com/developerworks/db2/library/techarticle/dm-0506finnie/index.html

> -- Artur Wronski

Reply to this Message

Ian - 04 Jun 2007 18:20 GMT

> Hi.
>
[quoted text clipped - 12 lines]
> * db2start
> * REDISTRIBUTE DATABASE PARTITION GROUP

FYI, you can use SSH instead of RSH, by setting the DB2RSHCMD registry
variable. Search for 'DB2RSHCMD' in the documentation.

Reply to this Message