RE: DB2EUG: Switching the current database partition

[Fortier, Christi (USPC.PCT.Hopewell)]

Q1: To run at node nnn: db2_all "+nnn>>db2 command"
    To set your session to one node:
set db2node=%1%
db2 set client connect_node %db2node% attach_node %db2node%
(db2node is an environmental variable used by IBM, not a registry
variable(db2set) as some books state)

Q2:
db2_all should be used at all times now for EEE. 
rah can be used if you have 1 logical node on each of multiple physical
servers, however if you have multiple nodes on your physical servers, rah is
not sufficient since it will only pick up the 1st node.
db2_all  had a minor error in 5.2 EEE NT, where the path to it was not set
so we would make our own version of db2_all or use rah instead, this is
fixed in 7.1.
 

-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Friday, July 20, 2001 4:14 PM
To: [EMAIL PROTECTED]
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?

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?

Thanks.

Steve Westfall
Equifax, Inc.



This message contains information from Equifax, Inc. which may be
confidential and privileged.  If you are not an intended recipient, please
refrain from any disclosure, copying, distribution or use of this
information and note that such actions are prohibited.  If you have
received this transmission in error, please notify by e:mail
[EMAIL PROTECTED]


=====
To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED]
For other info (and scripts), see http://people.mn.mediaone.net/scottrmcleod



=====
To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED]
For other info (and scripts), see http://people.mn.mediaone.net/scottrmcleod