SP storage consumption



IBM's flagship relational database management system

SP storage consumption

Postby mehi1353 » 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
mehi1353
 
Posts: 39
Joined: Sun Jan 11, 2009 4:51 pm
Has thanked: 0 time
Been thanked: 0 time

Return to DB2

 


  • Related topics
    Replies
    Views
    Last post