We noticed that in our test environment which is using DB2 Version 10 that our batch program that utilizes Declared GTT is taking much longer to execute. We narrowed the issue to the GTT and then replaced the GTT with a permanent table to ensure it was indeed the issue. With permanent table, the batch program is taking normal time.
In production, where we have version 8, the batch program is running with GTT and is running fine in normal time.
Please let me know if u know abt it urgently as we have a version 8 to 10 conversion in production recently.