estimating real storage for V8

Steve (IHG) Barth

estimating real storage for V8
We're trying to get a handle on how much additional real storage we'll
need for V8. I've seen some breakdowns in the Performance Topics and
Install guides for V8, but some of this is pretty confusing. Does anyone
have a handy-dandy spreadsheet where I could plug in values from V7
(virtual and/or real) that would calculate values for V8? Thanks.

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Tom Moulder

Re: estimating real storage for V8
(in response to Steve (IHG) Barth)
http://www.redbooks.ibm.com/abstracts/SG246465.html?Open is a link to a new
redbook that has a good discussion of the issues. I don't believe that it
has any formulas with magic to tell you what to do to make things just work.
It would give you a good idea of what to look for.

Tom Moulder
TREX Associates, Inc.
9728 Delmonico Dr.
Keller, Tx. 76248-9559
+1 817 741-5549 Office
+1 817 741-5548 Fax
+1 682 558-6527 Mobile
[login to unmask email]
www.t-rex-associates.com


-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On Behalf
Of Steve Barth
Sent: Monday, November 20, 2006 2:16 PM
To: [login to unmask email]
Subject: [DB2-L] estimating real storage for V8

We're trying to get a handle on how much additional real storage we'll
need for V8. I've seen some breakdowns in the Performance Topics and
Install guides for V8, but some of this is pretty confusing. Does anyone
have a handy-dandy spreadsheet where I could plug in values from V7
(virtual and/or real) that would calculate values for V8? Thanks.

----------------------------------------------------------------------------
-----
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home
page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select
"Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org.
The IDUG List Admins can be reached at [login to unmask email] Find
out the latest on IDUG conferences at http://conferences.idug.org/index.cfm


--
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.1.409 / Virus Database: 268.14.7/538 - Release Date: 11/18/2006

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Leslie

Re: estimating real storage for V8
(in response to Tom Moulder)
Hi

Yes this is available to you at the IBM web site I think (bundled in the
memu2 rexx download).

I have a document I have written on the subject of storage and V8 (which has
all the links in it that you will need) , I just need to clean out
references to clients from it. Do you want a copy?

It basically is a very condensed version of John Campbell (IBM Distinguished
Engineer) which points you re storage and what to do to determine wart you
are using & what to do if you have "not enough" for the v8 CM migration. It
has been used well in many places as a very good guide to getting started
quickly with the storage issue.

Email me privately if you want a copy - just so I can check who I am sending
it to.

Regards

Leslie Pendlebury-Bowe

-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On Behalf
Of Steve Barth
Sent: 20 November 2006 20:16
To: [login to unmask email]
Subject: [DB2-L] estimating real storage for V8

We're trying to get a handle on how much additional real storage we'll need
for V8. I've seen some breakdowns in the Performance Topics and Install
guides for V8, but some of this is pretty confusing. Does anyone have a
handy-dandy spreadsheet where I could plug in values from V7 (virtual and/or
real) that would calculate values for V8? Thanks.

----------------------------------------------------------------------------
-----
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home
page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select
"Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org.
The IDUG List Admins can be reached at [login to unmask email] Find
out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

--
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.1.409 / Virus Database: 268.14.10/541 - Release Date: 20/11/2006


--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.409 / Virus Database: 268.14.10/541 - Release Date: 20/11/2006


---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Steve (IHG) Barth

Re: estimating real storage for V8
(in response to Leslie)
Thanks, Leslie. I would like a copy. I'll email you separately.

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Steve (IHG) Barth

Re: estimating real storage for V8
(in response to Steve (IHG) Barth)
Thanks. I've been reading this. It is quite detailed--I'm having just
having a problem sorting it all out in a way that makes sense for us.

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

William Favero

Re: estimating real storage for V8
(in response to Steve (IHG) Barth)
Take a look a the materials and replay for John Campbell's last
teleconference... "Virtual Storage Relief in DB2 V8... and What to
Expect"... the replay is available at
http://www.ibm.com/software/os/zseries/telecon/15nov/

Willie

Steve Barth wrote:

>We're trying to get a handle on how much additional real storage we'll
>need for V8. I've seen some breakdowns in the Performance Topics and
>Install guides for V8, but some of this is pretty confusing. Does anyone
>have a handy-dandy spreadsheet where I could plug in values from V7
>(virtual and/or real) that would calculate values for V8? Thanks.
>
>---------------------------------------------------------------------------------
>Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm
>
>
>
>

--
Willie
My DB2 blog --> http://blogs.ittoolbox.com/database/db2zos
My Cars Website --> http://www.Red-Corvettes.com
62 Maroon, 99 MagRed (MTI 422), 03 Anniversary
05 Harley Dark Cherry Red Heritage Softail
I just love dark red.. LOL
My Personal Website --> http://www.WillieFavero.com
Cowboy HOG Website --> http://www.cowboyhog.org/
National Corvette Museum --> http://www.corvettemuseum.com/

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Avram Friedman

Re: estimating real storage for V8
(in response to William Favero)
With the exception of very small DB2 systems there is a very easy way to do this storage estimate.
The real storage requirement for a DB2 System (not including applications, DDF, WLM) is 2 gig.

This is not exactly rocket science.
Consider the following,
One of the biggest benefits of V8 is virtual storage constraint relief. The pre V7 world was constrained by 31 bit addressing and the victim was the DBM1 address space. Moving from V7 to V8 allowed the DBM1 to fit!
DB2 system address spaces are paging intolerant as the address spaces are multi tasking and a page fault results in the entire address space waiting. Its fair to guess that the real storage demand = the virtual storage demand or 2 gig based on the DBM1. Of course that 2 gig includes some common areas on one hand but on the other hand does not include MSTR and IRLM.
The current unit of capacity for real storage I belive is 4 gig, this is the smallest amount of additional memory that can be ordered for current machine models. I is safe to assume that a DB2 V8 upgrade will require an increase of between 0 and 1 units of memory capacity.

Avram Friedman
C.C.O. Geek-PCsolutions
(202)232-GEEK
----- Original Message -----
From: Steve Barth<mailto:[login to unmask email]>
Sent: Monday, November 20, 2006 3:15 PM
Subject: estimating real storage for V8


We're trying to get a handle on how much additional real storage we'll
need for V8. I've seen some breakdowns in the Performance Topics and
Install guides for V8, but some of this is pretty confusing. Does anyone
have a handy-dandy spreadsheet where I could plug in values from V7
(virtual and/or real) that would calculate values for V8? Thanks.

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html <http://www.idugdb2-l.org/archives/db2-l.html>. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org<http://www.idugdb2-l.org/>. The IDUG List Admins can be reached at [login to unmask email]<mailto:[login to unmask email]>. Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm< http://conferences.idug.org/index.cfm >

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Steve (IHG) Barth

Re: estimating real storage for V8
(in response to Avram Friedman)
Thanks. Any idea how much more real storage would be required for MSTR
and IRLM?



________________________________

From: IBMsysProg [mailto:[login to unmask email]
Sent: Wednesday, November 22, 2006 5:50 PM
To: Barth, Stephen (IHG); [login to unmask email]
Subject: Re: estimating real storage for V8



With the exception of very small DB2 systems there is a very easy way to
do this storage estimate.

The real storage requirement for a DB2 System (not including
applications, DDF, WLM) is 2 gig.



This is not exactly rocket science.

Consider the following,

One of the biggest benefits of V8 is virtual storage constraint
relief. The pre V7 world was constrained by 31 bit addressing and the
victim was the DBM1 address space. Moving from V7 to V8 allowed the
DBM1 to fit!

DB2 system address spaces are paging intolerant as the address
spaces are multi tasking and a page fault results in the entire address
space waiting. Its fair to guess that the real storage demand = the
virtual storage demand or 2 gig based on the DBM1. Of course that 2 gig
includes some common areas on one hand but on the other hand does not
include MSTR and IRLM.

The current unit of capacity for real storage I belive is 4 gig, this is
the smallest amount of additional memory that can be ordered for current
machine models. I is safe to assume that a DB2 V8 upgrade will require
an increase of between 0 and 1 units of memory capacity.



Avram Friedman
C.C.O. Geek-PCsolutions
(202)232-GEEK

----- Original Message -----

From: Steve Barth <mailto:[login to unmask email]>

Sent: Monday, November 20, 2006 3:15 PM

Subject: estimating real storage for V8



We're trying to get a handle on how much additional real storage
we'll
need for V8. I've seen some breakdowns in the Performance Topics
and
Install guides for V8, but some of this is pretty confusing.
Does anyone
have a handy-dandy spreadsheet where I could plug in values from
V7
(virtual and/or real) that would calculate values for V8?
Thanks.


------------------------------------------------------------------------
---------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the
archives and home page at http://www.idugdb2-l.org/archives/db2-l.html.
From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at
http://www.idugdb2-l.org. The IDUG List Admins can be reached at
[login to unmask email] Find out the latest on IDUG conferences
at http://conferences.idug.org/index.cfm


---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Roger Miller

Re: estimating real storage for V8
(in response to Steve (IHG) Barth)
I added a number of the recent performance measurements and APARs to a
presentation on the web, with updates from Akira Shibamiya & John Campbell.
ftp://ftp.software.ibm.com/software/data/db2zos/IDUGApplicativoperformance.
pdf

Slide 48, page 24 has the initial real storage net picture. You'll also
want a number of the updated service APARs on slides through 56 too. We
also did get the V8 Performance Topics redbook updated again in November.

Roger

On Mon, 27 Nov 2006 07:21:41 -0500, Barth, Stephen (IHG)
<[login to unmask email]> wrote:

>Thanks. Any idea how much more real storage would be required for MSTR
>and IRLM?
>
>________________________________
>
>From: IBMsysProg [mailto:[login to unmask email]
>Sent: Wednesday, November 22, 2006 5:50 PM
>To: Barth, Stephen (IHG); [login to unmask email]
>Subject: Re: estimating real storage for V8
>
>
>
>With the exception of very small DB2 systems there is a very easy way to
>do this storage estimate.
>
>The real storage requirement for a DB2 System (not including
>applications, DDF, WLM) is 2 gig.
>
>
>
>This is not exactly rocket science.
>
> Consider the following,
>
> One of the biggest benefits of V8 is virtual storage constraint
>relief. The pre V7 world was constrained by 31 bit addressing and the
>victim was the DBM1 address space. Moving from V7 to V8 allowed the
>DBM1 to fit!
>
> DB2 system address spaces are paging intolerant as the address
>spaces are multi tasking and a page fault results in the entire address
>space waiting. Its fair to guess that the real storage demand = the
>virtual storage demand or 2 gig based on the DBM1. Of course that 2 gig
>includes some common areas on one hand but on the other hand does not
>include MSTR and IRLM.
>
>The current unit of capacity for real storage I belive is 4 gig, this is
>the smallest amount of additional memory that can be ordered for current
>machine models. I is safe to assume that a DB2 V8 upgrade will require
>an increase of between 0 and 1 units of memory capacity.
>
>
>
>Avram Friedman
>C.C.O. Geek-PCsolutions
>(202)232-GEEK
>
> ----- Original Message -----
>
> From: Steve Barth <mailto:[login to unmask email]>
>
> Sent: Monday, November 20, 2006 3:15 PM
>
> Subject: estimating real storage for V8
>
>
>
> We're trying to get a handle on how much additional real storage
>we'll
> need for V8. I've seen some breakdowns in the Performance Topics
>and
> Install guides for V8, but some of this is pretty confusing.
>Does anyone
> have a handy-dandy spreadsheet where I could plug in values from
>V7
> (virtual and/or real) that would calculate values for V8?
>Thanks.
>
>
>------------------------------------------------------------------------

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm