[SPAM] DB2 for z/OS stress tool

Daniel Luksetich

[SPAM] DB2 for z/OS stress tool
Max,
I use REXX to simulate SQL performance situations and to test all (and I
mean all) SQL performance changes I make. I also use the DB2 Estimator
tool. Yes, it is old and out of date. However, when I am asked to deliver a
CPU and DASD estimate two years in advance of a new application being
deployed and have no code or database yet created then I use it. I can tell
you that it still does a fair job predicting CPU and DASD. Get it now as
IBM is currently hiding it and will remove it once DB2 for z/OS V8 goes out
of service.

Go here and follow the link to DB2 estimator. Also, I'm going to also make
my REXX routines available hopefully next week.

http://www.db2expert.com/index.php?page=links

Also, there is a benchmark tool on DB2 for LUW call db2batch that you can
run as a command. I believe you can connect it to a z/OS database, but not
sure. Why not try it and let us all know.

Cheers!
Dan

On Wed, 17 Nov 2010 15:58:57 +0100, Max Scarpa <[login to unmask email]> wrote:
> Esteemed Listers
>
> Is there any 'stress tool' to simulate a sort of workload on DB2 for
> z/OS ? If nothing was created for z/OS, is there a chance it was for
> DB2 for LUW ?
>
> Thank you and best regards
>
> Max Scarpa
>
> IDUG EMEA Thread 'A' Baci Perugina Certified Provider
> IDUG EMEA 2010 Certified Soppressa & Prosecco Champion
> IBM 2010 Information Champion
> Certified Nutella Platinum taster
> Wine provider (Datastudio Solution Architect ladies only)
>
> _____________________________________________________________________
> * IDUG North America * Anaheim, California * May 2-6 2011 *
> http://IDUG.ORG/NA *
> * Your only source for independent, unbiased, and trusted DB2
> information. *
> ** The most DB2 technical sessions of any conference
> ** Access IBM experts and developers
> _____________________________________________________________________
>
> 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 *
* Your only source for independent, unbiased, and trusted DB2 information. *
** The most DB2 technical sessions of any conference
** Access IBM experts and developers
_____________________________________________________________________

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

Daniel Luksetich

Re: DB2 for z/OS stress tool
(in response to Daniel Luksetich)
sorry for the redundancy, but I eliminated a couple of words from the
subject line in case email filters eliminate the message.
Dan

On Wed, 17 Nov 2010 07:12:41 -0800, Dan Luksetich <[login to unmask email]>
wrote:
> Max,
> I use REXX to simulate SQL performance situations and to test all (and I
> mean all) SQL performance changes I make. I also use the DB2 Estimator
> tool. Yes, it is old and out of date. However, when I am asked to
deliver a
> CPU and DASD estimate two years in advance of a new application being
> deployed and have no code or database yet created then I use it. I can
tell
> you that it still does a fair job predicting CPU and DASD. Get it now as
> IBM is currently hiding it and will remove it once DB2 for z/OS V8 goes
out
> of service.
>
> Go here and follow the link to DB2 estimator. Also, I'm going to also
make
> my REXX routines available hopefully next week.
>
> http://www.db2expert.com/index.php?page=links
>
> Also, there is a benchmark tool on DB2 for LUW call db2batch that you
can
> run as a command. I believe you can connect it to a z/OS database, but
not
> sure. Why not try it and let us all know.
>
> Cheers!
> Dan
>
> On Wed, 17 Nov 2010 15:58:57 +0100, Max Scarpa <[login to unmask email]> wrote:
>> Esteemed Listers
>>
>> Is there any 'stress tool' to simulate a sort of workload on DB2 for
>> z/OS ? If nothing was created for z/OS, is there a chance it was for

>> DB2 for LUW ?
>>
>> Thank you and best regards
>>
>> Max Scarpa
>>
>> IDUG EMEA Thread 'A' Baci Perugina Certified Provider
>> IDUG EMEA 2010 Certified Soppressa & Prosecco Champion
>> IBM 2010 Information Champion
>> Certified Nutella Platinum taster
>> Wine provider (Datastudio Solution Architect ladies only)
>>
>> _____________________________________________________________________
>> * IDUG North America * Anaheim, California * May 2-6 2011 *
>> http://IDUG.ORG/NA *
>> * Your only source for independent, unbiased, and trusted DB2
>> information. *
>> ** The most DB2 technical sessions of any conference
>> ** Access IBM experts and developers
>> _____________________________________________________________________
>>
>> 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 *
> * Your only source for independent, unbiased, and trusted DB2
> information. *
> ** The most DB2 technical sessions of any conference
> ** Access IBM experts and developers
> _____________________________________________________________________
>
> 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 *
* Your only source for independent, unbiased, and trusted DB2 information. *
** The most DB2 technical sessions of any conference
** Access IBM experts and developers
_____________________________________________________________________

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

Max Scarpa

Re: [SPAM] DB2 for z/OS stress tool
(in response to Daniel Luksetich)
Hi Dan

Thank you so much for your quick reply. Please let us know when you'll
publish your REXX, it sounds very interesting. I'd have a copy of DB2
Xtimator somewhere, but I'll download is for safe.

Thank you again and Cheers !

Max


IDUG DB2-L <[login to unmask email]> wrote on 17/11/2010 16.12.41:

> From: Dan Luksetich <[login to unmask email]>
> To: [login to unmask email]
> Date: 17/11/2010 16.13
> Subject: Re: [DB2-L] [SPAM] DB2 for z/OS stress tool
> Sent by: IDUG DB2-L <[login to unmask email]>
>
> Max,
> I use REXX to simulate SQL performance situations and to test all (and I
> mean all) SQL performance changes I make. I also use the DB2 Estimator
> tool. Yes, it is old and out of date. However, when I am asked to
deliver a
> CPU and DASD estimate two years in advance of a new application being
> deployed and have no code or database yet created then I use it. I can
tell
> you that it still does a fair job predicting CPU and DASD. Get it now as
> IBM is currently hiding it and will remove it once DB2 for z/OS V8 goes
out
> of service.
>
> Go here and follow the link to DB2 estimator. Also, I'm going to also
make
> my REXX routines available hopefully next week.
>
> http://www.db2expert.com/index.php?page=links
>
> Also, there is a benchmark tool on DB2 for LUW call db2batch that you
can
> run as a command. I believe you can connect it to a z/OS database, but
not
> sure. Why not try it and let us all know.
>
> Cheers!
> Dan
>
> On Wed, 17 Nov 2010 15:58:57 +0100, Max Scarpa <[login to unmask email]> wrote:
> > Esteemed Listers
> >
> > Is there any 'stress tool' to simulate a sort of workload on DB2 for

> > z/OS ? If nothing was created for z/OS, is there a chance it was
for
> > DB2 for LUW ?
> >
> > Thank you and best regards
> >
> > Max Scarpa
> >
> > IDUG EMEA Thread 'A' Baci Perugina Certified Provider
> > IDUG EMEA 2010 Certified Soppressa & Prosecco Champion
> > IBM 2010 Information Champion
> > Certified Nutella Platinum taster
> > Wine provider (Datastudio Solution Architect ladies only)
> >
> > _____________________________________________________________________
> > * IDUG North America * Anaheim, California * May 2-6 2011 *
> > http://IDUG.ORG/NA *
> > * Your only source for independent, unbiased, and trusted DB2
> > information. *
> > ** The most DB2 technical sessions of any conference
> > ** Access IBM experts and developers
> > _____________________________________________________________________
> >
> > 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 *
> * Your only source for independent, unbiased, and trusted DB2
> information. *
> ** The most DB2 technical sessions of any conference
> ** Access IBM experts and developers
> _____________________________________________________________________
>
> 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 *
* Your only source for independent, unbiased, and trusted DB2 information. *
** The most DB2 technical sessions of any conference
** Access IBM experts and developers
_____________________________________________________________________

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

Cristian Molaro

Re: DB2 for z/OS stress tool
(in response to Max Scarpa)
Ciao Max,

In addition to Dan's advice: for distributed workload I have been using the IBM Trade Performance Benchmark sample application. This is a free of charge application and simulates an OLTP environment. It works very well for me and we used it in many of the tests documented in http://www.redbooks.ibm.com/abstracts/sg246952.html.
You can get the tool from here https://www14.software.ibm.com/webapp/iwm/web/preLogin.do?source=trade6.
This solution requires a WAS server and it can be somehow complicated to install if you are not used to or if you are in a hurry.

Another option is Quest's Benchmark Factory for Databases. Have a look here: http://www.quest.com/benchmark-factory/. It works also really good, you can simulate many concurrent users in the free version and it is easy to get up and running. As far as I remember, it will not use a Java driver but an ODBC connection to DB2 for z/OS. I like the reports and the charts that it produces.

Have fun!

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2 information. *
** The most DB2 technical sessions of any conference
** Access IBM experts and developers
_____________________________________________________________________

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

Max Scarpa

Re: DB2 for z/OS stress tool
(in response to Cristian Molaro)
Hi Ken & Cristian

Thank you for valuable your informations !

Max Scarpa


IDUG DB2-L <[login to unmask email]> wrote on 17/11/2010 16.58.45:

> From: Cristian Molaro <[login to unmask email]>
> To: [login to unmask email]
> Date: 17/11/2010 17.00
> Subject: Re: [DB2-L] DB2 for z/OS stress tool
> Sent by: IDUG DB2-L <[login to unmask email]>
>
> Ciao Max,
>
> In addition to Dan's advice: for distributed workload I have been
> using the IBM Trade Performance Benchmark sample application. This
> is a free of charge application and simulates an OLTP environment.
> It works very well for me and we used it in many of the tests documented
in
> http://www.redbooks.ibm.com/abstracts/sg246952.html.
> You can get the tool from here https://www14.software.ibm.com/
> webapp/iwm/web/preLogin.do?source=trade6.
> This solution requires a WAS server and it can be somehow
> complicated to install if you are not used to or if you are in a hurry.
>
> Another option is Quest's Benchmark Factory for Databases. Have a look
here:
> http://www.quest.com/benchmark-factory/. It works also really good,
> you can simulate many concurrent users in the free version and it is
> easy to get up and running. As far as I remember, it will not use a
> Java driver but an ODBC connection to DB2 for z/OS. I like the
> reports and the charts that it produces.
>
> Have fun!
>
> _____________________________________________________________________
> * IDUG North America * Anaheim, California * May 2-6 2011 * http://
> IDUG.ORG/NA *
> * Your only source for independent, unbiased, and trusted DB2
> information. *
> ** The most DB2 technical sessions of any conference
> ** Access IBM experts and developers
> _____________________________________________________________________
>
> 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 *
* Your only source for independent, unbiased, and trusted DB2 information. *
** The most DB2 technical sessions of any conference
** Access IBM experts and developers
_____________________________________________________________________

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

Troy L Coleman

Re: [SPAM] DB2 for z/OS stress tool
(in response to Max Scarpa)
Hi Dan,
Yes I used db2batch to run SQL on z/os from my pc.
It is a great way to see if you are having a network problems also.

Troy Coleman
CA Technologies
Principal Product Manager
Tel:      +1-630-210-9274 X46025
Fax:     +1-630-505-6608
Mobile: +1-224-343-0073
Troy.Coleman at ca.com


-----Original Message-----
From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Dan Luksetich
Sent: Wednesday, November 17, 2010 9:13 AM
To: [login to unmask email]
Subject: Re: [DB2-L] [SPAM] DB2 for z/OS stress tool

Max,
I use REXX to simulate SQL performance situations and to test all (and I
mean all) SQL performance changes I make. I also use the DB2 Estimator
tool. Yes, it is old and out of date. However, when I am asked to deliver a
CPU and DASD estimate two years in advance of a new application being
deployed and have no code or database yet created then I use it. I can tell
you that it still does a fair job predicting CPU and DASD. Get it now as
IBM is currently hiding it and will remove it once DB2 for z/OS V8 goes out
of service.

Go here and follow the link to DB2 estimator. Also, I'm going to also make
my REXX routines available hopefully next week.

http://www.db2expert.com/index.php?page=links

Also, there is a benchmark tool on DB2 for LUW call db2batch that you can
run as a command. I believe you can connect it to a z/OS database, but not
sure. Why not try it and let us all know.

Cheers!
Dan

On Wed, 17 Nov 2010 15:58:57 +0100, Max Scarpa <[login to unmask email]> wrote:
> Esteemed Listers
>
> Is there any 'stress tool' to simulate a sort of workload on DB2 for
> z/OS ? If nothing was created for z/OS, is there a chance it was for
> DB2 for LUW ?
>
> Thank you and best regards
>
> Max Scarpa
>
> IDUG EMEA Thread 'A' Baci Perugina Certified Provider
> IDUG EMEA 2010 Certified Soppressa & Prosecco Champion
> IBM 2010 Information Champion
> Certified Nutella Platinum taster
> Wine provider (Datastudio Solution Architect ladies only)
>
> _____________________________________________________________________
> * IDUG North America * Anaheim, California * May 2-6 2011 *
> http://IDUG.ORG/NA *
> * Your only source for independent, unbiased, and trusted DB2
> information. *
> ** The most DB2 technical sessions of any conference
> ** Access IBM experts and developers
> _____________________________________________________________________
>
> 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 *
* Your only source for independent, unbiased, and trusted DB2 information. *
** The most DB2 technical sessions of any conference
** Access IBM experts and developers
_____________________________________________________________________

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 *
* Your only source for independent, unbiased, and trusted DB2 information. *
_____________________________________________________________________
http://www.IDUG.org/mentor
Mentoring should be a rewarding experience for everyone...
IDUG is offering up to 80% off when you both come to the conference!
_____________________________________________________________________

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

Krishna

Re: DB2 for z/OS stress tool
(in response to Troy L Coleman)
Hi,

For DB2 LUW, we have a tool named iReplay which can replay your Production Workload onto a Test Database. Please refer to : http://exact-solutions.com/products/ireplay

Regards,
Krishna

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2 information. *
_____________________________________________________________________
http://www.IDUG.org/mentor
How can you expand your staff or do succession planning in this economy?
Mentoring is a proven, economical, way to train the next generation of DB2 Users!
_____________________________________________________________________

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