Re: DB2 MSTR address space memory usage

2006-05-17 Thread Knutson, Sam
Discussion List [mailto:[EMAIL PROTECTED] On Behalf Of R.S. Sent: Thursday, May 11, 2006 6:14 AM To: IBM-MAIN@BAMA.UA.EDU Subject: DB2 MSTR address space memory usage How to find out what is memory usage of DB2 xxxMSTR address space ? -- Radoslaw Skorupka Lodz, Poland

Re: DB2 MSTR address space memory usage

2006-05-15 Thread IBMsysProg
by a class 6 statistics trace. They mostly report on DBM1. I suspect that from the viewpoint of the original question the IFCID information should be ignored. - Original Message - From: R.S.mailto:[EMAIL PROTECTED] Sent: Thursday, May 11, 2006 6:13 AM Subject: DB2 MSTR address

DB2 MSTR address space memory usage

2006-05-11 Thread R.S.
How to find out what is memory usage of DB2 xxxMSTR address space ? -- Radoslaw Skorupka Lodz, Poland -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET

R: DB2 MSTR address space memory usage

2006-05-11 Thread MASSIMO BIANCUCCI
. -Messaggio originale- Da: IBM Mainframe Discussion List [mailto:[EMAIL PROTECTED] Per conto di R.S. Inviato: giovedì 11 maggio 2006 12.14 A: IBM-MAIN@BAMA.UA.EDU Oggetto: DB2 MSTR address space memory usage How to find out what is memory usage of DB2 xxxMSTR address space ? -- Radoslaw

Re: DB2 MSTR address space memory usage

2006-05-11 Thread Shane
On Thu, 2006-05-11 at 12:13 +0200, R.S. wrote: How to find out what is memory usage of DB2 xxxMSTR address space ? Think of a (large) number. Double it. If you have allowed the DBAs free reign with buffers, double it again. If the result looks ridiculously high, you're probably getting close.

Re: R: DB2 MSTR address space memory usage

2006-05-11 Thread R.S.
MASSIMO BIANCUCCI wrote: If you need a snapshot of memory usage, you could use a monitor if you got any or SDSF/DA Real field or TASID utility (even if it looks TASID doesn't care about DataSpace data). If you need a long term trend data, you should use SMF records post-processing. Hope

Re: DB2 MSTR address space memory usage

2006-05-11 Thread John Ticic
-- snip -- If you need a snapshot of memory usage, you could use a monitor if you got any or SDSF/DA Real field or TASID utility (even if it looks TASID doesn't care about DataSpace data). If you need a long term trend data, you should use SMF records post-processing. Hope it's useful. It is

Re: DB2 MSTR address space memory usage

2006-05-11 Thread Philippe Leite
It is actually described in the FM - just hard to find. When displaying numeric values that are too large for the column width, SDSF scales them using these abbreviations: T (thousands), M (millions), B (billions), KB (kilobytes), MB (megabytes), GB (gigabytes), TB (terabytes) and PB

Re: DB2 MSTR address space memory usage

2006-05-11 Thread Mark Zelden
On Thu, 11 May 2006 12:13:51 +0200, R.S. [EMAIL PROTECTED] wrote: How to find out what is memory usage of DB2 xxxMSTR address space ? Virtual? Real? Lots of ways. SDSF, RMF virtual storage detail report (need to set up parms for RMF STC), RMF III shows frames used, MVS monitors (Omegamon,

Re: DB2 MSTR address space memory usage

2006-05-11 Thread R.S.
Mark Zelden wrote: On Thu, 11 May 2006 12:13:51 +0200, R.S. [EMAIL PROTECTED] wrote: How to find out what is memory usage of DB2 xxxMSTR address space ? Virtual? Real? Both. g Lots of ways. SDSF, RMF virtual storage detail report (need to set up parms for RMF STC), RMF III shows

Re: DB2 MSTR address space memory usage

2006-05-11 Thread Aaron Walker
Some info on what's going on in DB2 can be found here. Watch the wrap. http://www-1.ibm.com/support/docview.wss?rs=64context=SSEPEKamp;q1=% 2bpresentationuid=swg27006985loc=en_UScs=utf-8cc=uslang=all Aaron On Thu, 11 May 2006 12:13:51 +0200, R.S. [EMAIL PROTECTED] wrote: How to find out