Helpful folks,
Platform: DB2 UDB v7.2, Win2000, KEEPDARI=YES
I am trying to reduce memory usage of our SP's. We only have 80 or so
SP's but in the Task Manager/Processes display, there are over 200
entries for DB2DARI.EXE. Interestingly, there are many sets of these
entries which have the exact same memory usage size. It would appear
that for many of the SP's, there are multiple copies in memory.
Is there any way I can correlate the PID in this display to find (or
verify) just which SP is spawning multiple times?
Is there any way I can stop this behavior? If only one occurance of
each of the 80 SP's lived in memory, that would make my server much
happier.
Any help or pointers would be much appreciated.
Thanks
Sean