DB2 Express-C Global Temporary Table Performance on vista

[DB2]

After I have istalled express version of DB 9.5 on Vista.
I create a stored procedure(used global temporary table),
When i try to execute this procedure, it's very very slow,
even if there is only one row can be fetched.
But I try this on XP instead, it's ok.
Does it Needs addtional setting for global temporary table on Vista?

Thanks in advance.

[Larry]

Re: DB2 Express-C Global Temporary Table Performance on vista

How much RAM is on the machine? Do you think it's possible that it's
Vista that is usurping the memory?

Larry E.

DB2 wrote:

After I have istalled express version of DB 9.5 on Vista.
I create a stored procedure(used global temporary table),
When i try to execute this procedure, it's very very slow,
even if there is only one row can be fetched.
But I try this on XP instead, it's ok.
Does it Needs addtional setting for global temporary table on Vista?
>
Thanks in advance.