By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,825 Members | 1,269 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,825 IT Pros & Developers. It's quick & easy.

What is node migration ?

P: n/a
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 !
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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 !

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.