What is node migration ?

redeye42@yahoo.com · *nix forums beginner Joined: 18 Feb 2005 Posts: 1

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, schoubal@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
Sad

1) What is node migration ?
Sad

2) What are the components that could be impacted by node migration
:and in what way ?
Sad

3) Does the tablespace for temporary tables and that used internally
:for queries (system and user temporary) get impacted by node migration
Confused

:
:Thanks in advance !

sac · *nix forums beginner Joined: 13 Feb 2005 Posts: 6

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 !

Google