What is node migration ?

[sac]

I am using DB2 v8.1 on UNIX.
A few weeks ago the DBAs carried out node migration activity on the
database.
After the node migration I observed that the queries that execute on
temporary tables show extreme poor performance. One of the query was
partly optimized by declaring a partitioning key on the temporary
table. However it still takes longer than before the node migration.

I would appreciate if I could get information on the following
(1) What is node migration ?
(2) What are the components that could be impacted by node migration
and in what way ?
(3) Does the tablespace for temporary tables and that used internally
for queries (system and user temporary) get impacted by node migration
?

Thanks in advance !

[redeye42]

since no one's replied you might want to try the unix db2eug group at
www.herethey.com
On 13 Feb 2005 07:01:59 -0800, sc******@gmail.com (sac) wrote:

:I am using DB2 v8.1 on UNIX.
:A few weeks ago the DBAs carried out node migration activity on the
:database.
:After the node migration I observed that the queries that execute on
:temporary tables show extreme poor performance. One of the query was
:partly optimized by declaring a partitioning key on the temporary
:table. However it still takes longer than before the node migration.
:
:I would appreciate if I could get information on the following
:(1) What is node migration ?
:(2) What are the components that could be impacted by node migration
:and in what way ?
:(3) Does the tablespace for temporary tables and that used internally
:for queries (system and user temporary) get impacted by node migration
:?
:
:Thanks in advance !