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 !