Toad for DB2's memory usage is oddly high. When trying to use an insert select statement in the editor to move data from one table to another, there are spikes in memory and page files while Toad for DB2 tries to run the statement and eventually Toad will error out with a memory errors. But no data should be displayed and it just copying data from one table to another. Working outside of Toad, there does not seem to be any problem with memory usage when this sql is run.
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center