IBM Mainframe Forum

Hi all,

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:

STORAGE NOTIFICATION
90% CONSUMED
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,
Mehrdad Rastegar