----- Original Message -----
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, July 20, 2001 1:13 PM
Subject: DB2EUG: Switching the current database partition
> The environment: DB2 EEE 7.1 on AIX version 4.
>
> Question 1: In a parallel database with multiple logical partitions on
the
> same physical machine, what DB2 command is used to change the logical
> partition to which subsequent DB2 commands will be directed?
1) Set the DB2NODE environment variable, as in:
db2 terminate
export DB2NODE=4
db2 connect to yourdb
Make sure you terminate any backend process if you change the setting
for DB2NODE otherwise the change won't take effect.
> Question 2: If all the partitions in a database are on the same physical
> machine, is use of the db2_all command still required in order to execute
a
> DB2 command on all partitions in the database? Or is db2_all only used
> when the partitions reside on different physical machines?
You don't need to, but db2_all is usually easier than manually setting
DB2NODE and running the command for each partition. Even with two
partitions:
db2_all "db2 update db cfg for yourdb using logfilsiz 2500"
or
db2 terminate
export DB2NODE=1
db2 update db cfg for yourdb using logfilsiz 2500
db2 terminate
export DB2NODE=2
db2 update db cfg for yourdb using logfilsiz 2500
db2 terminate
export DB2NODE=
Good luck,
Ian
=====
To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED]
For other info (and scripts), see http://people.mn.mediaone.net/scottrmcleod
