ZOS 1.6 & DB2 7.1 & v7.? db2 connect

William Proctor

ZOS 1.6 & DB2 7.1 & v7.? db2 connect
Good Morning and thanks for all replies in advance. I am looking at the
output from CA's Detector monitor and I notice that the packages for DB2
connect, Specifically SYSSH100 has the most time percentage and cpu
percent of all of my transactions. I have made the assumption that this
is the package that handles the result sets and passes them back to the
user thru DB2 connect. Is there any buffers settings or other settings
that will improve/speed up this area of the transactions? What should I
be looking at to determine that this area is working efficiently? I
have been unable to find out very much in this area.



Bill Proctor

Database Administrator (Adabas/DB2)

DB2 UDB V7.1 Database Administration for OS/390

Texas Guaranteed Student Loan Corp.

Austin, Texas

Phone: 512-219-4847






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

Myron Miller

Re: ZOS 1.6 & DB2 7.1 & v7.? db2 connect
(in response to William Proctor)
Actually, this is the package that also runs the SQL received from the remote
requestor as well. So one would expect that this package will have a very
large amount of CPU if you have a lot of DDF activity.

You need to look at the SQL being received and see how to tune that. For
tuning between DB2 and the remote, William Smith of IBM has made several
presentations at IDUG in the past on tuning this DDF portion of DB2 connect.

Myron

--- "Proctor, William" <[login to unmask email]> wrote:

> Good Morning and thanks for all replies in advance. I am looking at the
> output from CA's Detector monitor and I notice that the packages for DB2
> connect, Specifically SYSSH100 has the most time percentage and cpu
> percent of all of my transactions. I have made the assumption that this
> is the package that handles the result sets and passes them back to the
> user thru DB2 connect. Is there any buffers settings or other settings
> that will improve/speed up this area of the transactions? What should I
> be looking at to determine that this area is working efficiently? I
> have been unable to find out very much in this area.
>
>
>
> Bill Proctor
>
> Database Administrator (Adabas/DB2)
>
> DB2 UDB V7.1 Database Administration for OS/390
>
> Texas Guaranteed Student Loan Corp.
>
> Austin, Texas
>
> Phone: 512-219-4847
>
>
>
>
>
>
>
---------------------------------------------------------------------------------
> 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