hi

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

situ - 31 Jul 2006 14:37 GMT

hi all,

when i run db2 get snapshot for bufferpools on <db_name>,
it shows "NOT COLLECTED" for most of the parameter, what could be the
problem.
is there any register variable or parameter to be enabled??

thanks
sridhar

Reply to this Message

Raj - 31 Jul 2006 14:58 GMT

Update your monitor switches using...

update monitor switches using BUFFERPOOL on LOCK on SORT on STATEMENT
on TABLE on UOW on global;

http://publib.boulder.ibm.com/infocenter/db2luw/v8/index.jsp?topic=/com.ibm.db2.
udb.doc/core/r0001977.htm

or update your dbm cfg settings DFT_MON_BUFPOOL...etc

Reply to this Message

situ - 31 Jul 2006 15:12 GMT

thanks raj

Reply to this Message