SP storage consumption
Posted: Sun Nov 02, 2014 5:12 pm
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
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