DB2 for z/OS Efficiency rating

Marcus Davage

DB2 for z/OS Efficiency rating
Has anyone ever come up with an overall DB2 for z/OS performance
efficiency rating?



What would it involve? Wait time? Getpages? Package statement cost? CPU
cost? Buffer pool usage? Thread usage?



Marcus

Lloyds TSB Bank plc. Registered Office: 25 Gresham Street, London EC2V 7HN. Registered in England and Wales, number 2065. Telephone: 020 7626 1500.
Bank of Scotland plc. Registered Office: The Mound, Edinburgh EH1 1YZ. Registered in Scotland, number 327000. Telephone: 0870 600 5000

Lloyds TSB Scotland plc. Registered Office: Henry Duncan House, 120 George Street, Edinburgh EH2 4LH. Registered in Scotland, number 95237. Telephone: 0131 225 4555.
Cheltenham & Gloucester plc. Registered Office: Barnett Way, Gloucester GL4 3RL. Registered in England and Wales, number 2299428. Telephone: 01452 372372.

Lloyds TSB Bank plc, Lloyds TSB Scotland plc, Bank of Scotland plc and Cheltenham & Gloucester plc are authorised and regulated by the Financial Services Authority.
Halifax is a division of Bank of Scotland plc. Cheltenham & Gloucester Savings is a division of Lloyds TSB Bank plc.

HBOS plc. Registered Office: The Mound, Edinburgh EH1 1YZ. Registered in Scotland, number 218813. Telephone: 0870 600 5000

Lloyds Banking Group plc. Registered Office: The Mound, Edinburgh EH1 1YZ. Registered in Scotland, number 95000. Telephone: 0131 225 4555

This e-mail (including any attachments) is private and confidential and may contain privileged material. If you have received this e-mail in error, please notify the sender and delete it (including any attachments) immediately. You must not copy, distribute, disclose or use any of the information in it or any attachments.

Telephone calls may be monitored or recorded.

______________________________________________________________________
This email has been scanned by the MessageLabs Email Security System.
For more information please visit http://www.messagelabs.com/email
______________________________________________________________________

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* If you are going to attend only one conference this year, this is it! *
** The best DB2 technical sessions in the world
** Independent, not-for-profit, User Run - the IDUG difference!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv

Adam Baldwin

Re: DB2 for z/OS Efficiency rating
(in response to Marcus Davage)
Pi * (total number of DBAs / total number of DB2 Sysprogs)
* Number of DB2 Subsystems * (Number of Coffee Breaks + Number of Ciggy Breaks) / 42

...and it's not even Friday.

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* If you are going to attend only one conference this year, this is it! *
** The best DB2 technical sessions in the world
** Independent, not-for-profit, User Run - the IDUG difference!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv

Avram Friedman

Re: DB2 for z/OS Efficiency rating
(in response to Adam Baldwin)
Let me start out by pointing out that DB2 for z/os is not a direct user of fossil fuel and as such is an efficient green solution.

I always like to mention that DB2 is a very efficient DBMS in a batch environment because:
It does batched reads instead of single block.
It anticipates the requirement for batch reads and does them async (prefetch).
It defers writes to avoid duplicate writes and usually writes async.
It has a brillant result set concept.
It has effective almost automatic access path optomization.

Almost note of these wonderful batch efficencies is good for an OLTP environment however. The very effective DB2 developers have managed to make OLTP peformance acceptable.

For OLTP
A DB2 relational row will never beat an IMS database record
requires more logical I/O to obtain
requires additional logical I/O to obtain other parts of the relation
requires additional data to be processed because parts of the record key are always duplicated
(IMS eliminates redundant data as one of its original design objectives)
A indexed read (requireing 2 or more logical I/Os) will never beat IMS HDAM where obtaining a root requires 1 logical I/O.

IMS is not the fastest / efficent IBM 360+ OLTP DBMS by the way. IBM's ACP/TCF for example is much faster / efficient than IMS.

My 1 to 10 ratings for DB2 with 10 being the best are
Batch 8 (relational results in extra IO and extra data transfered)
OLTP 6 (optiomization keeps it from being a 5)

Let me remind people who may of forgot ...
DB2 for z/os was not marketed originally based on its efficiency ... it was anything but ...
It was marketed of the bases of reduing the application development expense
and a mathamaticial concept that relational applications could be proven.

The typical early c-level IT presentions on DB2 were a demostration of
how easy it was for Chief IT offices to write QMF scripts espically QBE.
Anyone care to comment on well those QBE applications are doing in your shops?

By the way I love DB2.
Not efficent but a wonderful choice for other reasons.
Avram Friedman

On Mon, 17 Jan 2011 11:38:29 -0000, Davage, Marcus <[login to unmask email]> wrote:

>Has anyone ever come up with an overall DB2 for z/OS performance
>efficiency rating?
>
>
>
>What would it involve? Wait time? Getpages? Package statement cost? CPU
>cost? Buffer pool usage? Thread usage?
>
>
>
>Marcus
>
>Lloyds TSB Bank plc. Registered Office: 25 Gresham Street, London EC2V 7HN. Registered in England and Wales, number 2065. Telephone: 020 7626 1500.
>Bank of Scotland plc. Registered Office: The Mound, Edinburgh EH1 1YZ. Registered in Scotland, number 327000. Telephone: 0870 600 5000
>
>Lloyds TSB Scotland plc. Registered Office: Henry Duncan House, 120 George Street, Edinburgh EH2 4LH. Registered in Scotland, number 95237. Telephone: 0131 225 4555.
>Cheltenham & Gloucester plc. Registered Office: Barnett Way, Gloucester GL4 3RL. Registered in England and Wales, number 2299428. Telephone: 01452 372372.
>
>Lloyds TSB Bank plc, Lloyds TSB Scotland plc, Bank of Scotland plc and Cheltenham & Gloucester plc are authorised and regulated by the Financial Services Authority.
>Halifax is a division of Bank of Scotland plc. Cheltenham & Gloucester Savings is a division of Lloyds TSB Bank plc.
>
>HBOS plc. Registered Office: The Mound, Edinburgh EH1 1YZ. Registered in Scotland, number 218813. Telephone: 0870 600 5000
>
>Lloyds Banking Group plc. Registered Office: The Mound, Edinburgh EH1 1YZ. Registered in Scotland, number 95000. Telephone: 0131 225 4555
>
>This e-mail (including any attachments) is private and confidential and may contain privileged material. If you have received this e-mail in error, please notify the sender and delete it (including any attachments) immediately. You must not copy, distribute, disclose or use any of the information in it or any attachments.
>
>Telephone calls may be monitored or recorded.
>
>______________________________________________________________________
>This email has been scanned by the MessageLabs Email Security System.
>For more information please visit http://www.messagelabs.com/email
>______________________________________________________________________
>
>_____________________________________________________________________
>* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
>* If you are going to attend only one conference this year, this is it! *
>** The best DB2 technical sessions in the world
>** Independent, not-for-profit, User Run - the IDUG difference!
>_____________________________________________________________________
>
>If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* If you are going to attend only one conference this year, this is it! *
** The best DB2 technical sessions in the world
** Independent, not-for-profit, User Run - the IDUG difference!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv