In db2, is there any way to determine the total "storage consumption" of a particular "stored procedure" after a run?
we usually encounter this error:
85% CONSUMED BY DB2
DSNV510I -DSNA DSNVMON - BEGIN DISPLAY OF LARGEST 719
STORAGE CONSUMERS IN DBM1
DSNV512I -DSNA DSNVMON - AGENT 1: 720
Now, I guess that there are some "stored procedures" that use the system storage more than we expect and we want to find them...
all the best,