Re: Auxiliary Storage Usage - History Data?

2007-10-22 Thread Vernooy, C.P. - SPLXM
Martin Packer [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
om...
 Peter Hunkeler said: 
 
  You can switch interval recording on if you need even more of 
  those virtual projectiles.
 
 Sorry, I WAS referring to interval recording. I've a feeling Cees was 
 referring to the 30-4 and -5 subtypes. 
 
 Cheers, Martin 
 
 Martin Packer

No, I was also referring to interval recording. We used it to track long
running tasks for constant growth due to errors.

Kees.
**
For information, services and offers, please visit our web site:
http://www.klm.com. This e-mail and any attachment may contain
confidential and privileged material intended for the addressee
only. If you are not the addressee, you are notified that no part
of the e-mail or any attachment may be disclosed, copied or
distributed, and that any other action related to this e-mail or
attachment is strictly prohibited, and may be unlawful. If you have
received this e-mail by error, please notify the sender immediately
by return e-mail, and delete this message. 

Koninklijke Luchtvaart Maatschappij NV (KLM), its subsidiaries
and/or its employees shall not be liable for the incorrect or
incomplete transmission of this e-mail or any attachments, nor
responsible for any delay in receipt.
Koninklijke Luchtvaart Maatschappij N.V. (also known as KLM Royal
Dutch Airlines) is registered in Amstelveen, The Netherlands, with
registered number 33014286 
**

--
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO
Search the archives at http://bama.ua.edu/archives/ibm-main.html


Re: Auxiliary Storage Usage - History Data?

2007-10-19 Thread Martin Packer
Kees wrote:

 Remember that the reported figures are highwater marks, 
 so they will only go up, never down, but it can provide 
 you a clue.

I tend to characterise this as Allocated rather than Suballocated / Used.

So in principle the numbers can go down - but that's not a frequent 
occurrence with DB2.

And, perhaps parenthetically, I don't trust the REAL memory numbers in 
Type 30 any further than I can throw them. :-(

Cheers, Martin

Martin Packer
Performance Consultant
IBM United Kingdom Ltd
+44-20-8832-5167
+44-7802-245-584
[EMAIL PROTECTED]







Unless stated otherwise above:
IBM United Kingdom Limited - Registered in England and Wales with number 
741598. 
Registered office: PO Box 41, North Harbour, Portsmouth, Hampshire PO6 3AU






--
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO
Search the archives at http://bama.ua.edu/archives/ibm-main.html


Re: Auxiliary Storage Usage - History Data?

2007-10-19 Thread Mark Zelden
On Thu, 18 Oct 2007 15:15:54 -0500, Patrick Lyon [EMAIL PROTECTED] wrote:


But back to my previous question, is there an RMF report that I can use via
batch to see history on how many AUX frames were allocated to what address
space via the REPORTS or SYSREPORTS statement, or via some other report
feature that I am not familiar with?  I need to go back weeks of kept SMF
data, not just hours of real time online data.


No.  Not unless you have a VSTOR detail set up ahead of time or were
running RMF MON II in the background.  See hlq.IBM.PARMLIB(ERBRMF03)
and the fine manuals for how to do that.

Mark
--
Mark Zelden
Sr. Software and Systems Architect - z/OS Team Lead
Zurich North America / Farmers Insurance Group - ZFUS G-ITO
mailto:[EMAIL PROTECTED]
z/OS Systems Programming expert at http://expertanswercenter.techtarget.com/
Mark's MVS Utilities: http://home.flash.net/~mzelden/mvsutil.html

--
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO
Search the archives at http://bama.ua.edu/archives/ibm-main.html


Re: Auxiliary Storage Usage - History Data?

2007-10-19 Thread Martin Packer
Peter Hunkeler said: 

 You can switch interval recording on if you need even more of 
 those virtual projectiles.

Sorry, I WAS referring to interval recording. I've a feeling Cees was 
referring to the 30-4 and -5 subtypes. 

Cheers, Martin 

Martin Packer
Performance Consultant
IBM United Kingdom Ltd
+44-20-8832-5167
+44-7802-245-584
[EMAIL PROTECTED]







Unless stated otherwise above:
IBM United Kingdom Limited - Registered in England and Wales with number 
741598. 
Registered office: PO Box 41, North Harbour, Portsmouth, Hampshire PO6 3AU






--
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO
Search the archives at http://bama.ua.edu/archives/ibm-main.html


Re: Auxiliary Storage Usage - History Data?

2007-10-19 Thread Patrick Lyon

No.  Not unless you have a VSTOR detail set up ahead of time or were
running RMF MON II in the background.  See hlq.IBM.PARMLIB(ERBRMF03)
and the fine manuals for how to do that.

Mark

Clarification... since you mentioned AUX specifically in the last post:

VSTOR won't show the AUX frames.. but will show the virtual storage usage
by subpool within the job you monitor.  I think that was part of what you
wanted in your original post IIRC.   If you run RMF III and backup the
volumes with the VSAM history (full volume or incremental), you could
also restore them and specifically allocate them to your TSO session
(RMFDSnn) and start a monitor 3 session to use STORF.

Mark

Ah HA!  That is what I had thought being I was pouring over the RMF Users 
Guide and running every type of report I could with no success.

Thanks Mark and to all who replied.
Pat L.

--
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO
Search the archives at http://bama.ua.edu/archives/ibm-main.html


Re: Auxiliary Storage Usage - History Data?

2007-10-19 Thread Mark Zelden
On Fri, 19 Oct 2007 08:09:53 -0500, Mark Zelden [EMAIL PROTECTED]
wrote:

On Thu, 18 Oct 2007 15:15:54 -0500, Patrick Lyon [EMAIL PROTECTED]
wrote:


But back to my previous question, is there an RMF report that I can use via
batch to see history on how many AUX frames were allocated to what address
space via the REPORTS or SYSREPORTS statement, or via some other report
feature that I am not familiar with?  I need to go back weeks of kept SMF
data, not just hours of real time online data.


No.  Not unless you have a VSTOR detail set up ahead of time or were
running RMF MON II in the background.  See hlq.IBM.PARMLIB(ERBRMF03)
and the fine manuals for how to do that.

Mark

Clarification... since you mentioned AUX specifically in the last post:  

VSTOR won't show the AUX frames.. but will show the virtual storage usage 
by subpool within the job you monitor.  I think that was part of what you
wanted in your original post IIRC.   If you run RMF III and backup the 
volumes with the VSAM history (full volume or incremental), you could
also restore them and specifically allocate them to your TSO session
(RMFDSnn) and start a monitor 3 session to use STORF.

Mark
--
Mark Zelden
Sr. Software and Systems Architect - z/OS Team Lead
Zurich North America / Farmers Insurance Group - ZFUS G-ITO
mailto:[EMAIL PROTECTED]
z/OS Systems Programming expert at http://expertanswercenter.techtarget.com/
Mark's MVS Utilities: http://home.flash.net/~mzelden/mvsutil.html

--
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO
Search the archives at http://bama.ua.edu/archives/ibm-main.html


Re: Auxiliary Storage Usage - History Data?

2007-10-19 Thread Vernooy, C.P. - SPLXM
Martin Packer [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
om...
 Kees wrote:
 
  Remember that the reported figures are highwater marks, 
  so they will only go up, never down, but it can provide 
  you a clue.
 
 I tend to characterise this as Allocated rather than Suballocated /
Used.

Don't think so, it is the highwater mark of what has been allocated.

 
 So in principle the numbers can go down - but that's not a frequent 
 occurrence with DB2.

Don't think so, highwater marks never get lower, even if the allocated
virtual storage goes down.

 
 And, perhaps parenthetically, 

Since I had to grab the dictionary at the same time this week as Barbara
did, I now know the word parenthetically (although it still makes me
think it reads pathetically).

I don't trust the REAL memory numbers in 

I am referring to virtual storage in smf 30.

 Type 30 any further than I can throw them. :-(

That sounds like a more interesting competition that throwing
cellphones.

Kees.

 
 Cheers, Martin
 
 Martin Packer
**
For information, services and offers, please visit our web site:
http://www.klm.com. This e-mail and any attachment may contain
confidential and privileged material intended for the addressee
only. If you are not the addressee, you are notified that no part
of the e-mail or any attachment may be disclosed, copied or
distributed, and that any other action related to this e-mail or
attachment is strictly prohibited, and may be unlawful. If you have
received this e-mail by error, please notify the sender immediately
by return e-mail, and delete this message. 

Koninklijke Luchtvaart Maatschappij NV (KLM), its subsidiaries
and/or its employees shall not be liable for the incorrect or
incomplete transmission of this e-mail or any attachments, nor
responsible for any delay in receipt.
Koninklijke Luchtvaart Maatschappij N.V. (also known as KLM Royal
Dutch Airlines) is registered in Amstelveen, The Netherlands, with
registered number 33014286 
**

--
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO
Search the archives at http://bama.ua.edu/archives/ibm-main.html


Re: Auxiliary Storage Usage - History Data?

2007-10-19 Thread Vernooy, C.P. - SPLXM
Ed Gould [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]...
 On Oct 18, 2007, at 3:15 PM, Patrick Lyon wrote:
 
  Thanks to all who have responded.
 
  We went through this all again today and DB2 crashed.  After  
  restarting it, it
  doesn't take up near the storage as just before it went down.
 
  After doing some research, I found some storage related PTFs that  
  were not
  on describing not freeing storage.  I will apply these ASAP.
 
  But back to my previous question, is there an RMF report that I can

  use via
  batch to see history on how many AUX frames were allocated to what  
  address
  space via the REPORTS or SYSREPORTS statement, or via some other  
  report
  feature that I am not familiar with?  I need to go back weeks of  
  kept SMF
  data, not just hours of real time online data.
 
  Thanks again for all who have responded.
 
  Best Regards,
  Patrick Lyon
 Patrick,
 
 There is an RMF report (you feed SMF recs for the time period you  
 want reported) that gives you numbers on paging slots used/available.
 
 Its been 10 years since I ran it but I am sure thats its still there.
 
 The last time I ran it I went with several months worth of data to  
 prove that we didn't need more page spaces.
 
 Ed
 

Yes, reporting AUX useage and its growth is available.
However, finding the offender is difficult. If you have an suspect, you
can trace SMF30 for its virtual storage useage and growth. Remember that
the reported figures are highwater marks, so they will only go up, never
down, but it can provide you a clue.

Kees.
**
For information, services and offers, please visit our web site:
http://www.klm.com. This e-mail and any attachment may contain
confidential and privileged material intended for the addressee
only. If you are not the addressee, you are notified that no part
of the e-mail or any attachment may be disclosed, copied or
distributed, and that any other action related to this e-mail or
attachment is strictly prohibited, and may be unlawful. If you have
received this e-mail by error, please notify the sender immediately
by return e-mail, and delete this message. 

Koninklijke Luchtvaart Maatschappij NV (KLM), its subsidiaries
and/or its employees shall not be liable for the incorrect or
incomplete transmission of this e-mail or any attachments, nor
responsible for any delay in receipt.
Koninklijke Luchtvaart Maatschappij N.V. (also known as KLM Royal
Dutch Airlines) is registered in Amstelveen, The Netherlands, with
registered number 33014286 
**

--
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO
Search the archives at http://bama.ua.edu/archives/ibm-main.html


Re: Auxiliary Storage Usage - History Data?

2007-10-18 Thread Patrick Lyon
Thanks to all who have responded.  

We went through this all again today and DB2 crashed.  After restarting it, it 
doesn't take up near the storage as just before it went down.

After doing some research, I found some storage related PTFs that were not 
on describing not freeing storage.  I will apply these ASAP.

But back to my previous question, is there an RMF report that I can use via 
batch to see history on how many AUX frames were allocated to what address 
space via the REPORTS or SYSREPORTS statement, or via some other report 
feature that I am not familiar with?  I need to go back weeks of kept SMF 
data, not just hours of real time online data.

Thanks again for all who have responded.

Best Regards,
Patrick Lyon

--
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO
Search the archives at http://bama.ua.edu/archives/ibm-main.html


Re: Auxiliary Storage Usage - History Data?

2007-10-18 Thread Ed Gould

On Oct 18, 2007, at 3:15 PM, Patrick Lyon wrote:


Thanks to all who have responded.

We went through this all again today and DB2 crashed.  After  
restarting it, it

doesn't take up near the storage as just before it went down.

After doing some research, I found some storage related PTFs that  
were not

on describing not freeing storage.  I will apply these ASAP.

But back to my previous question, is there an RMF report that I can  
use via
batch to see history on how many AUX frames were allocated to what  
address
space via the REPORTS or SYSREPORTS statement, or via some other  
report
feature that I am not familiar with?  I need to go back weeks of  
kept SMF

data, not just hours of real time online data.

Thanks again for all who have responded.

Best Regards,
Patrick Lyon

Patrick,

There is an RMF report (you feed SMF recs for the time period you  
want reported) that gives you numbers on paging slots used/available.


Its been 10 years since I ran it but I am sure thats its still there.

The last time I ran it I went with several months worth of data to  
prove that we didn't need more page spaces.


Ed

--
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO
Search the archives at http://bama.ua.edu/archives/ibm-main.html


Re: Auxiliary Storage Usage - History Data?

2007-10-17 Thread Lizette Koehler
Patrick,

What version of z/OS or os/390 are you on?

Are you seeing IRA messages? If so, could you show us some?

If there are IRA messages, I would issue the command D ASM to see what my page 
packs look like.  It sounds that you might be paging.  Which means you might 
not have sufficient real storage.

Or I could be way off base.

You can always run the RMF Post Processor to read the offloaded SMF data.  
though I am not sure you can read the current MAN files with it.


Lizette



Good Morning List - We have recently gone short of aux storage, this is after 
we installed a new BMC DB2 monitor/collector.

I can see that the DB2DBM1 is taking up a lot of storage.  What I want is to 
compare this with data from before we started firing up the collector.

I know that you can use RMF real time through the STORF command to see 
the aux frames, but can you use RMF in batch mode to see aux storage usage 
using SMF data?

I've been through the RMF User's Guide and through these archives and have 
not found what I am looking for.

Is this even possible?


--
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO
Search the archives at http://bama.ua.edu/archives/ibm-main.html


Re: Auxiliary Storage Usage - History Data?

2007-10-17 Thread Martin Packer
Lizette Wrote:

 It sounds that you might be paging.  Which means you might not have 
sufficient real storage.

Going short on memory is going to be bad going forwards - especially for 
DB2, especially for z/OS Release 8, and especially if you don't have a 
really beefy paging subsystem.

And don't forget just once in a while you may (unfortunately) have to dump 
that big DB2 subsystem. So the steady state probably isn't the thing you 
have to cater for.

Cheers, Martin

Martin Packer
Performance Consultant
IBM United Kingdom Ltd
+44-20-8832-5167
+44-7802-245-584
[EMAIL PROTECTED]








Unless stated otherwise above:
IBM United Kingdom Limited - Registered in England and Wales with number 
741598. 
Registered office: PO Box 41, North Harbour, Portsmouth, Hampshire PO6 3AU






--
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO
Search the archives at http://bama.ua.edu/archives/ibm-main.html


Re: Auxiliary Storage Usage - History Data?

2007-10-17 Thread Ted MacNEIL
You can always run the RMF Post Processor to read the offloaded SMF data.  
though I am not sure you can read the current MAN files with it.

You have to dump (not clear -- leave that up to your normal processes) the 
current files before you can process it with ERBRMFPP.

-
Too busy driving to stop for gas!

--
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO
Search the archives at http://bama.ua.edu/archives/ibm-main.html


Re: Auxiliary Storage Usage - History Data?

2007-10-17 Thread Mark Zelden
On Wed, 17 Oct 2007 17:39:48 +, Ted MacNEIL [EMAIL PROTECTED] wrote:

You can always run the RMF Post Processor to read the offloaded SMF data.
 though I am not sure you can read the current MAN files with it.

You have to dump (not clear -- leave that up to your normal processes) the
current files before you can process it with ERBRMFPP.


Or use the RMF Sysplex Data Server.  How much data is there in the
wrap around file depends on how big you make the buffer.   Default is 32M
and can go up to 2G (specified in the RMF proc or modify command).   

Mark
--
Mark Zelden
Sr. Software and Systems Architect - z/OS Team Lead
Zurich North America / Farmers Insurance Group - ZFUS G-ITO
mailto:[EMAIL PROTECTED]
z/OS Systems Programming expert at http://expertanswercenter.techtarget.com/
Mark's MVS Utilities: http://home.flash.net/~mzelden/mvsutil.html

--
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO
Search the archives at http://bama.ua.edu/archives/ibm-main.html