DB2 z/OS V9 question: are we a big or small DB2 shop?!

Norbert Wolf

DB2 z/OS V9 question: are we a big or small DB2 shop?!
Hello,

perhaps you think this is a silly question. How can an company estimate whether it is a big or small shop? This can be only demonstrated by comparison with other DB2 z/OS customer.

But if my manager asks me:

- how high is our DB2-MIPS consumption in comparison to other "really big DB2 z/OS"-shops"?
- or are 80 TB of DB2 data a large amount of DB2 data?
- and other questions more

then I have one big problem:

I am sure that we are now far away from any DB2 z/OS limit (transaction rate, active connections, etc.). But the best proof of my theory (that we are no really big DB2 shop) would be a look at "some numbers" (DB2-MIPS-consumption, used DB2 space, ..) from other DB2 customers.

Perhaps someone can give me a useful hint, there I can get such numbers. My one investigations (contacting German DB2 Guide, asking vendors, ..) were not successful yet. Maybe some is able to send me his "the DB2 numbers" .




regards

Norbert Wolf

Datev eG



_________________________________________________________________

Register NOW for the IDUG DB2 Tech Conference in Anaheim, May 2-6, 2011!
_________________________________________________________________
International DB2 User Group (IDUG) - Independent, not-for-profit, User Run
Your only source for independent, unbiased, and trusted DB2 information

Maja Markotic

Re: DB2 z/OS V9 question: are we a big or small DB2 shop?!
(in response to Norbert Wolf)
In his IDUG 2008 Europe presentation "Future DB2 for z/OS Technical Directions" (session B13) Jeff Josten shared some interesting numbers:

- the largest banking benchmark ever at the Bank of China: 9,445 transactions per second
- the world's largest known peak database workload at UPS: 1.1 billion SQL statements per hour
- the world's largest known transaction processing database at UK Land Registry: 23.1 TB

That was back in 2008 though... if I remember correctly, Jeff Jonas shared more recent numbers during his IDUG 2010 EMEA opening keynote so ask again after his keynote at IDUG's DB2 Tech conference in Anaheim on Tuesday, May 3 :-)

Maja

-----Original Message-----
From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Norbert Wolf
Sent: Thursday, April 28, 2011 11:34 AM
To: [login to unmask email]
Subject: [DB2-L] DB2 z/OS V9 question: are we a big or small DB2 shop?!

Hello,

perhaps you think this is a silly question. How can an company estimate whether it is a big or small shop? This can be only demonstrated by comparison with other DB2 z/OS customer.

But if my manager asks me:

- how high is our DB2-MIPS consumption in comparison to other "really big DB2 z/OS"-shops"?
- or are 80 TB of DB2 data a large amount of DB2 data?
- and other questions more

then I have one big problem:

I am sure that we are now far away from any DB2 z/OS limit (transaction rate, active connections, etc.). But the best proof of my theory (that we are no really big DB2 shop) would be a look at "some numbers" (DB2-MIPS-consumption, used DB2 space, ..) from other DB2 customers.

Perhaps someone can give me a useful hint, there I can get such numbers. My one investigations (contacting German DB2 Guide, asking vendors, ..) were not successful yet. Maybe some is able to send me his "the DB2 numbers" .




regards

Norbert Wolf

Datev eG



_________________________________________________________________

Register NOW for the IDUG DB2 Tech Conference in Anaheim, May 2-6, 2011!
_________________________________________________________________
International DB2 User Group (IDUG) - Independent, not-for-profit, User Run
Your only source for independent, unbiased, and trusted DB2 information

Disclaimer:
Ova elektronička poruka je povjerljiva i može sadržavati povlaštene informacije. Ako niste naznačeni primatelj, niste ovlašteni čitati, printati, pohraniti, obrađivati ili priopćavati ovu poruku. Ako ste ovu poruku primili greškom, molimo Vas da o tome odmah obavijestite pošiljatelja i izbrišete ovu poruku, njene privitke i kopije. Zagrebačka banka d.d. ne preuzima nikakvu odgovornost s obzirom na bilo koju moguću netočnost bilo kojeg podatka koji je sadržan u ovoj poruci ako takav podatak nije povezan s registriranim predmetom poslovanja Zagrebačke banke d.d. Stajališta izražena u ovoj poruci ne odražavaju nužno službena stajališta Zagrebačke banke d.d. Hvala!
This e-mail is confidential and may also contain privileged information. If you are not the intended recipient, you are not authorised to read, print, save, process or disclose this message. If you have received this message by mistake, please inform the sender immediately and delete this e-mail, its attachments and any copies. Zagrebacka banka d.d. does not take any responsibility with regards to any possible inaccuracy of any data contained in this e-mail if such data do not relate to the registered operations of Zagrebacka banka d.d. The opinions expressed in this e-mail do not necessarily reflect the official positions of Zagrebacka banka d.d. Thank you!

_________________________________________________________________

Register NOW for the IDUG DB2 Tech Conference in Anaheim, May 2-6, 2011!
_________________________________________________________________
International DB2 User Group (IDUG) - Independent, not-for-profit, User Run
Your only source for independent, unbiased, and trusted DB2 information


Cuneyt Goksu

Re: DB2 z/OS V9 question: are we a big or small DB2 shop?!
(in response to Maja Markotic)
To complement Maja;
I needed latest benchmarks for a presentation a few weeks ago and collected from DB2 for z/OS Marketing Team.

The latest figures are

- Delivered the largest banking benchmark ever at the Kookmin Bank in Korea, a record 15,353 transactions per second
- The world’s largest known OLTP database – 71 TB at UK Land Registry

Details are : http://www.slideshare.net/CuneytGoksu/db2-10-for-zos-update

Cuneyt


-----Original Message-----
From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Maja Markotic
Sent: Thursday, April 28, 2011 2:12 PM
To: [login to unmask email]
Subject: Re: [DB2-L] DB2 z/OS V9 question: are we a big or small DB2 shop?!

In his IDUG 2008 Europe presentation "Future DB2 for z/OS Technical Directions" (session B13) Jeff Josten shared some interesting numbers:

- the largest banking benchmark ever at the Bank of China: 9,445 transactions per second
- the world's largest known peak database workload at UPS: 1.1 billion SQL statements per hour
- the world's largest known transaction processing database at UK Land Registry: 23.1 TB

That was back in 2008 though... if I remember correctly, Jeff Jonas shared more recent numbers during his IDUG 2010 EMEA opening keynote so ask again after his keynote at IDUG's DB2 Tech conference in Anaheim on Tuesday, May 3 :-)

Maja

-----Original Message-----
From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Norbert Wolf
Sent: Thursday, April 28, 2011 11:34 AM
To: [login to unmask email]
Subject: [DB2-L] DB2 z/OS V9 question: are we a big or small DB2 shop?!

Hello,

perhaps you think this is a silly question. How can an company estimate whether it is a big or small shop? This can be only demonstrated by comparison with other DB2 z/OS customer.

But if my manager asks me:

- how high is our DB2-MIPS consumption in comparison to other "really big DB2 z/OS"-shops"?
- or are 80 TB of DB2 data a large amount of DB2 data?
- and other questions more

then I have one big problem:

I am sure that we are now far away from any DB2 z/OS limit (transaction rate, active connections, etc.). But the best proof of my theory (that we are no really big DB2 shop) would be a look at "some numbers" (DB2-MIPS-consumption, used DB2 space, ..) from other DB2 customers.

Perhaps someone can give me a useful hint, there I can get such numbers. My one investigations (contacting German DB2 Guide, asking vendors, ..) were not successful yet. Maybe some is able to send me his "the DB2 numbers" .




regards

Norbert Wolf

Datev eG



_________________________________________________________________

Register NOW for the IDUG DB2 Tech Conference in Anaheim, May 2-6, 2011!
_________________________________________________________________
International DB2 User Group (IDUG) - Independent, not-for-profit, User Run
Your only source for independent, unbiased, and trusted DB2 information

Disclaimer:
Ova elektronička poruka je povjerljiva i može sadržavati povlaštene informacije. Ako niste naznačeni primatelj, niste ovlašteni čitati, printati, pohraniti, obrađivati ili priopćavati ovu poruku. Ako ste ovu poruku primili greškom, molimo Vas da o tome odmah obavijestite pošiljatelja i izbrišete ovu poruku, njene privitke i kopije. Zagrebačka banka d.d. ne preuzima nikakvu odgovornost s obzirom na bilo koju moguću netočnost bilo kojeg podatka koji je sadržan u ovoj poruci ako takav podatak nije povezan s registriranim predmetom poslovanja Zagrebačke banke d.d. Stajališta izražena u ovoj poruci ne odražavaju nužno službena stajališta Zagrebačke banke d.d. Hvala!
This e-mail is confidential and may also contain privileged information. If you are not the intended recipient, you are not authorised to read, print, save, process or disclose this message. If you have received this message by mistake, please inform the sender immediately and delete this e-mail, its attachments and any copies. Zagrebacka banka d.d. does not take any responsibility with regards to any possible inaccuracy of any data contained in this e-mail if such data do not relate to the registered operations of Zagrebacka banka d.d. The opinions expressed in this e-mail do not necessarily reflect the official positions of Zagrebacka banka d.d. Thank you!

_________________________________________________________________

Register NOW for the IDUG DB2 Tech Conference in Anaheim, May 2-6, 2011!
_________________________________________________________________
International DB2 User Group (IDUG) - Independent, not-for-profit, User Run
Your only source for independent, unbiased, and trusted DB2 information

_________________________________________________________________

Register NOW for the IDUG DB2 Tech Conference in Anaheim, May 2-6, 2011!
_________________________________________________________________
International DB2 User Group (IDUG) - Independent, not-for-profit, User Run
Your only source for independent, unbiased, and trusted DB2 information

Joel Goldstein

Re: DB2 z/OS V9 question: are we a big or small DB2 shop?!
(in response to Cuneyt Goksu)
A couple of other interesting numbers (of course they are driven by users/applications):

Getpage/Hour >>> 780 Million

I/O Second >>> close to 7,000 at peak load
cost of this IO rate is approx 750 CPU sec/hr.

memory allocated to 4K buffer pools >>>>> 5,250,000
memory allocated to 32K pools >>>>> 82,000
memory used by DBM1 address space 28 Gigabytes

These are not all from the same client.

Thanks,
Joel


Joel Goldstein
Responsive Systems
IBM Gold Consultant
Buffer Pool Tool for DB2, the worldwide industry standard
Performance software that works...... Predicts IO Rate !!
Predicts Group Buffer Pool performance too
www.responsivesystems.com

Buffer Pool Tool for DB2 on www.LinkedIn.com
Watch the 3-Minute Buffer Pool Tool Movie at: www.responsivesystems.com/Movie1


tel. (732) 972-1261
fax.(732) 972-9416
----- Original Message -----
From: "Cuneyt Goksu(Gmail)" <[login to unmask email]>
Newsgroups: bit.listserv.db2-l
To: <[login to unmask email]>
Sent: Thursday, April 28, 2011 9:28 AM
Subject: Re: [DB2-L] DB2 z/OS V9 question: are we a big or small DB2 shop?!


To complement Maja;
I needed latest benchmarks for a presentation a few weeks ago and collected from DB2 for z/OS Marketing Team.

The latest figures are

- Delivered the largest banking benchmark ever at the Kookmin Bank in Korea, a record 15,353 transactions per second
- The world’s largest known OLTP database – 71 TB at UK Land Registry

Details are : http://www.slideshare.net/CuneytGoksu/db2-10-for-zos-update

Cuneyt


-----Original Message-----
From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Maja Markotic
Sent: Thursday, April 28, 2011 2:12 PM
To: [login to unmask email]
Subject: Re: [DB2-L] DB2 z/OS V9 question: are we a big or small DB2 shop?!

In his IDUG 2008 Europe presentation "Future DB2 for z/OS Technical Directions" (session B13) Jeff Josten shared some interesting numbers:

- the largest banking benchmark ever at the Bank of China: 9,445 transactions per second
- the world's largest known peak database workload at UPS: 1.1 billion SQL statements per hour
- the world's largest known transaction processing database at UK Land Registry: 23.1 TB

That was back in 2008 though... if I remember correctly, Jeff Jonas shared more recent numbers during his IDUG 2010 EMEA opening keynote so ask again after his keynote at IDUG's DB2 Tech conference in Anaheim on Tuesday, May 3 :-)

Maja

-----Original Message-----
From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Norbert Wolf
Sent: Thursday, April 28, 2011 11:34 AM
To: [login to unmask email]
Subject: [DB2-L] DB2 z/OS V9 question: are we a big or small DB2 shop?!

Hello,

perhaps you think this is a silly question. How can an company estimate whether it is a big or small shop? This can be only demonstrated by comparison with other DB2 z/OS customer.

But if my manager asks me:

- how high is our DB2-MIPS consumption in comparison to other "really big DB2 z/OS"-shops"?
- or are 80 TB of DB2 data a large amount of DB2 data?
- and other questions more

then I have one big problem:

I am sure that we are now far away from any DB2 z/OS limit (transaction rate, active connections, etc.). But the best proof of my theory (that we are no really big DB2 shop) would be a look at "some numbers" (DB2-MIPS-consumption, used DB2 space, ..) from other DB2 customers.

Perhaps someone can give me a useful hint, there I can get such numbers. My one investigations (contacting German DB2 Guide, asking vendors, ..) were not successful yet. Maybe some is able to send me his "the DB2 numbers" .




regards

Norbert Wolf

Datev eG



_________________________________________________________________



_________________________________________________________________

Register NOW for the IDUG DB2 Tech Conference in Anaheim, May 2-6, 2011!
_________________________________________________________________
International DB2 User Group (IDUG) - Independent, not-for-profit, User Run
Your only source for independent, unbiased, and trusted DB2 information


Avram Friedman

Re: DB2 z/OS V9 question: are we a big or small DB2 shop?!
(in response to Joel Goldstein)
If I may
Big shop status and the rights to use the big shop logo on your correspondence is not a quantative assignment but a qualitative one.

Here are some of the qualitive things that indicate Big Shop (DB2 flavor)

Data sharing
More than one DB2 required for peek demand or High Availability

Very High Availability requirements
like 24x7 99.9% uptime fewer than 1 scheduled outage a month
Your requirements may be diffrent.
Lets face it a 5 minute outage impacts 50 users more than 5 users.

Dedicated resources
If you share your LPAR with CICS flat file transactions then DB2 really is not overwhelmingly important.

Content of CIO reports
Is the big pretty graph at the top of the pile about DB2 for z/OS or something else like Machine utilization
If DB2 is not the most important chart you are not a big DB2 shop, you may be big for what ever that top chart is for.

DR
Restore from volume dumps not a big shop (you can afford to loose a lot, Poor RPO)
Restore from vault copies not at the recover site you are not a big shop (No urgency in RTO requirements)
Use Mirrors or recover from materials actually delivered electronicly and stored at the recovery site, Big shop potencial.

Local recovery
Dependent on tape logs?
yes, not a big shop loose a volume with parts of 2 or more objects, recovery will be searialized
No, Big site potencial.

DB2 Systems Programmer leadership (systems programmers are often the smallest group of DB2 proffesionals in a shop)
Is the boss a DB2 specific manager or do the CICS, z/OS, Operations, or Capacity people also report to him
Hope by this time you can figure out which suggests a large shop.

In summary to the extent that DB2 is #1 in your shop you are big.

A historical note ... the term and the job DBA or Data Base Administrator was invented by our friends in the IMS world.
Why did they do this and why take the term DBA from business management (Doing Business As)
The novel idea was data was a corporate resource and not an application system resource.
This elevated the DBMS to an important corportate status, That is, it obtained the BIG label.
Does your DBMS deployment merit the BIG label?
Well just how important (not volume, but important) is it?

Best wishes from a BIG Data Base Proffesional
Avram Friedman


On Thu, 28 Apr 2011 09:33:31 +0000, Norbert Wolf <[login to unmask email]> wrote:

>Hello,
>
>perhaps you think this is a silly question. How can an company estimate whether it is a big or small shop? This can be only demonstrated by comparison with other DB2 z/OS customer.
>
>But if my manager asks me:
>
>- how high is our DB2-MIPS consumption in comparison to other "really big DB2 z/OS"-shops"?
>- or are 80 TB of DB2 data a large amount of DB2 data?
>- and other questions more
>
>then I have one big problem:
>
>I am sure that we are now far away from any DB2 z/OS limit (transaction rate, active connections, etc.). But the best proof of my theory (that we are no really big DB2 shop) would be a look at "some numbers" (DB2-MIPS-consumption, used DB2 space, ..) from other DB2 customers.
>
>Perhaps someone can give me a useful hint, there I can get such numbers. My one investigations (contacting German DB2 Guide, asking vendors, ..) were not successful yet. Maybe some is able to send me his "the DB2 numbers" .
>
>
>
>
>regards
>
>Norbert Wolf
>
>Datev eG
>
>
>
>_________________________________________________________________
>
>Register NOW for the IDUG DB2 Tech Conference in Anaheim, May 2-6, 2011!
>_________________________________________________________________
> International DB2 User Group (IDUG) - Independent, not-for-profit, User Run
> Your only source for independent, unbiased, and trusted DB2 information

_________________________________________________________________

Register NOW for the IDUG DB2 Tech Conference in Anaheim, May 2-6, 2011!
_________________________________________________________________
If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L
is the home of IDUG's Listserv

Chris Hoelscher

Re: DB2 z/OS V9 question: are we a big or small DB2 shop?!
(in response to Avram Friedman)
The are no little DB2 shops - only little DB2 DBAs

Chris Hoelscher



The information transmitted is intended only for the person or entity to which it is addressed and may contain CONFIDENTIAL material. If you receive this material/information in error, please contact the sender and delete or destroy the material/information.


_________________________________________________________________

Register NOW for the IDUG DB2 Tech Conference in Anaheim, May 2-6, 2011!
_________________________________________________________________
If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L
is the home of IDUG's Listserv