Performance tuning of DB2/CICS transactions.

Prasad Mani

Performance tuning of DB2/CICS transactions.
Dear Listers,



We are DB2 V6.1; CICS V1.3 on OS/390 V2.8



I have a task of performance tuning of non-terminal DB2/CICS transactions
having increased response times.

The non-terminal transactions showed increase in their response times by 25%
over the last one year. DB2 is the prime suspect as of now even though we
have not yet reviewed of any impact due to CICS and other stuffs. I also
observed that the (average) Non-terminal I/O response time has increased
considerably even though the (average)non-terminal I/O count remained
steady(data based on averages for each day).



Since the count of I/O done for non-terminal transactions has not increased
and remained steady for most of the time, I want to know what are the
possible factors that could have caused this increase in non-terminal I/O
response times.



Any help on how to proceed with this investigation on this performance
problem is greatly appreciated. We have ca-platinum products and
bmc-mainview tools to monitor performance.



Thanks in advance!!!

- Prasad

**************************************************************************
This email (including any attachments) is intended for the sole use of the
intended recipient/s and may contain material that is CONFIDENTIAL AND
PRIVATE COMPANY INFORMATION. Any review or reliance by others or copying or
distribution or forwarding of any or all of the contents in this message is
STRICTLY PROHIBITED. If you are not the intended recipient, please contact
the sender by email and delete all copies; your cooperation in this regard
is appreciated.
**************************************************************************

---------------------------------------------------------------------------------
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: Performance tuning of DB2/CICS transactions.
(in response to Prasad Mani)
You are running a DB2 that is nearly 6 years old, that would be about 70
in human terms. V6 goes out of service in the next 5 months. Are you
working on a version migration? Is the service current (say 6 months to a
year from current)? You can use those tools that measure DB2 response
times or format the DB2 accounting records.

The Administration Guide for V6
http://publib.boulder.ibm.com/epubs/pdf/DSNAG0G3.PDF
has a chapter 5-2 that discusses looking at the DB2 times to see what has
changed, and what is the cause. Chapter 5-3 is about improving response
times and throughput.

Roger Miller

On Thu, 13 Jan 2005 23:22:15 +0530, Prasad_Mani <[login to unmask email]>
wrote:

>Dear Listers,
>
>
>
>We are DB2 V6.1; CICS V1.3 on OS/390 V2.8
>
>
>
>I have a task of performance tuning of non-terminal DB2/CICS transactions
>having increased response times.
>
>The non-terminal transactions showed increase in their response times by
25%
>over the last one year. DB2 is the prime suspect as of now even though we
>have not yet reviewed of any impact due to CICS and other stuffs. I also
>observed that the (average) Non-terminal I/O response time has increased
>considerably even though the (average)non-terminal I/O count remained
>steady(data based on averages for each day).
>
>
>
>Since the count of I/O done for non-terminal transactions has not
increased
>and remained steady for most of the time, I want to know what are the
>possible factors that could have caused this increase in non-terminal I/O
>response times.
>
>
>
>Any help on how to proceed with this investigation on this performance
>problem is greatly appreciated. We have ca-platinum products and
>bmc-mainview tools to monitor performance.
>
>
>
>Thanks in advance!!!
>
>- Prasad
>
>**************************************************************************
>This email (including any attachments) is intended for the sole use of the
>intended recipient/s and may contain material that is CONFIDENTIAL AND
>PRIVATE COMPANY INFORMATION. Any review or reliance by others or copying
or
>distribution or forwarding of any or all of the contents in this message
is
>STRICTLY PROHIBITED. If you are not the intended recipient, please contact
>the sender by email and delete all copies; your cooperation in this regard
>is appreciated.
>**************************************************************************
>

---------------------------------------------------------------------------------
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: Performance tuning of DB2/CICS transactions.
(in response to Roger Miller)
If those chapters are a bit too much, then here is a white paper I noticed.

Think you've mastered all the tricks for CICS® and DB2® performance? Try
something new. Re-examine your options to increase simultaneous
transactions while decreasing the number of Task Control Blocks (TCBs).

Maximize performance with tips on how to streamline processing and
conserve resources by reading "Tuning the CICS/DB2 Interface." In this
white paper from Yevich, Lawson & Associates Inc., you'll learn about:

Tweaking settings to avoid sign-on calls when possible
Adjusting accounting record parameters to limit unnecessary data
collection
Using wildcard characters in the transaction definitions to speed
processing

http://candle.m0.net/m/p/can/cic/signup.asp?src=CICSE31H05EZJRNL

Roger Miller

On Fri, 14 Jan 2005 10:29:25 -0600, Roger Miller <[login to unmask email]>
wrote:

>You are running a DB2 that is nearly 6 years old, that would be about 70
>in human terms. V6 goes out of service in the next 5 months. Are you
>working on a version migration? Is the service current (say 6 months to a
>year from current)? You can use those tools that measure DB2 response
>times or format the DB2 accounting records.
>
>The Administration Guide for V6
>http://publib.boulder.ibm.com/epubs/pdf/DSNAG0G3.PDF
>has a chapter 5-2 that discusses looking at the DB2 times to see what has
>changed, and what is the cause. Chapter 5-3 is about improving response
>times and throughput.
>
>Roger Miller
>
>On Thu, 13 Jan 2005 23:22:15 +0530, Prasad_Mani <[login to unmask email]>
>wrote:
>
>>Dear Listers,
>>
>>
>>
>>We are DB2 V6.1; CICS V1.3 on OS/390 V2.8
>>
>>
>>
>>I have a task of performance tuning of non-terminal DB2/CICS transactions
>>having increased response times.
>>
>>The non-terminal transactions showed increase in their response times by
>25%
>>over the last one year. DB2 is the prime suspect as of now even though we
>>have not yet reviewed of any impact due to CICS and other stuffs. I also
>>observed that the (average) Non-terminal I/O response time has increased
>>considerably even though the (average)non-terminal I/O count remained
>>steady(data based on averages for each day).
>>
>>
>>
>>Since the count of I/O done for non-terminal transactions has not
>increased
>>and remained steady for most of the time, I want to know what are the
>>possible factors that could have caused this increase in non-terminal I/O
>>response times.
>>
>>
>>
>>Any help on how to proceed with this investigation on this performance
>>problem is greatly appreciated. We have ca-platinum products and
>>bmc-mainview tools to monitor performance.
>>
>>
>>
>>Thanks in advance!!!
>>
>>- Prasad
>>
>>*************************************************************************
*
>>This email (including any attachments) is intended for the sole use of
the
>>intended recipient/s and may contain material that is CONFIDENTIAL AND
>>PRIVATE COMPANY INFORMATION. Any review or reliance by others or copying
>or
>>distribution or forwarding of any or all of the contents in this message
>is
>>STRICTLY PROHIBITED. If you are not the intended recipient, please
contact
>>the sender by email and delete all copies; your cooperation in this
regard
>>is appreciated.
>>*************************************************************************
*
>>
>
>--------------------------------------------------------------------------
-------
>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 DB2-L-
[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

Jim Tonchick

Re: Performance tuning of DB2/CICS transactions.
(in response to Roger Miller)
Prasad, you have your work cut out planning upgrades. Besides DB2 V6 going
off support soon, you are already running unsupported with CICS TS 1.3 and
OS/390 2.8. You can go from CICS TS 1.3 to 2.2. We did that last year. But
OS/390 2.8 is not a valid migration path for z/OS 1.5. We had to rush an order
last August for z/OS 1.4 so we could have a supported migration path from OS/390
2.10.

Jim Tonchick

---------------------------------------------------------------------------------
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