New on Z/OS & experiencing slowness

William Proctor

New on Z/OS & experiencing slowness
Thanks for all replies in advance. We went to Z/OS 1.4 the second week
of December and since that time we keep getting complains of things
being just a little bit slower and our batch cycle seems to have
increased by about 40 minutes a night. Other jobs do seem to take just
a little longer to run. We are not getting any errors or anything to
indicate that there's a problem. When looking at individual jobs your
looking at 1 maybe two minutes but it's adding up over time. Sorry for
the vagueness but that's what we are working with at the moment. We
actually increased the amount of memory from 2.5 gig to 3 gig for our
production lpar. Has anyone else experienced this? Any suggestions on
what adjustments might be needed? We are on DB2 V7.1 using VP's backed
by HP's. We have not made any changes to the database during this
time.







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

Jeff Frazier

Re: New on Z/OS & experiencing slowness
(in response to William Proctor)
William,
Did you go to z/OS 1.4 from what? Are you doing anymore PAGING? Are
bufferpools still responding the same as before?




"Proctor, William" <[login to unmask email]>
Sent by: DB2 Data Base Discussion List <[login to unmask email]>
01/05/2005 08:24 AM
Please respond to DB2 Database Discussion list at IDUG


To: [login to unmask email]
cc:
Subject: [DB2-L] New on Z/OS & experiencing slowness




Thanks for all replies in advance. We went to Z/OS 1.4 the second week of
December and since that time we keep getting complains of things being
just a little bit slower and our batch cycle seems to have increased by
about 40 minutes a night. Other jobs do seem to take just a little longer
to run. We are not getting any errors or anything to indicate that
there's a problem. When looking at individual jobs your looking at 1
maybe two minutes but it's adding up over time. Sorry for the vagueness
but that's what we are working with at the moment. We actually increased
the amount of memory from 2.5 gig to 3 gig for our production lpar. Has
anyone else experienced this? Any suggestions on what adjustments might
be needed? We are on DB2 V7.1 using VP's backed by HP's. We have not
made any changes to the database during this time.







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

John Lendman

Re: New on Z/OS & experiencing slowness
(in response to Jeff Frazier)
What about WLM?

Have you set it up or let it default?

Just a few thoughts.


John C. Lendman
IBM Certified Solutions Expert
IBM Certified Database Administrator
DB2 Universal Database V8.1 for zOS
Office 561-357-7523
Cell 772-485-1592
Email [login to unmask email]

-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email]On Behalf Of Jeff Frazier
Sent: Wednesday, January 05, 2005 8:40 AM
To: [login to unmask email]
Subject: Re: [DB2-L] New on Z/OS & experiencing slowness



William,
Did you go to z/OS 1.4 from what? Are you doing anymore PAGING? Are bufferpools still responding the same as before?



"Proctor, William" <[login to unmask email]>
Sent by: DB2 Data Base Discussion List <[login to unmask email]>


01/05/2005 08:24 AM
Please respond to DB2 Database Discussion list at IDUG



To: [login to unmask email]
cc:
Subject: [DB2-L] New on Z/OS & experiencing slowness





Thanks for all replies in advance. We went to Z/OS 1.4 the second week of December and since that time we keep getting complains of things being just a little bit slower and our batch cycle seems to have increased by about 40 minutes a night. Other jobs do seem to take just a little longer to run. We are not getting any errors or anything to indicate that there's a problem. When looking at individual jobs your looking at 1 maybe two minutes but it's adding up over time. Sorry for the vagueness but that's what we are working with at the moment. We actually increased the amount of memory from 2.5 gig to 3 gig for our production lpar. Has anyone else experienced this? Any suggestions on what adjustments might be needed? We are on DB2 V7.1 using VP's backed by HP's. We have not made any changes to the database during this time.







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

William Proctor

Re: New on Z/OS & experiencing slowness
(in response to John Lendman)
We went to Z/OS 1.4 from OS/390 2.10. We are running 64 bit. I
increased my bufferpools until the system did page and then I backed
them off. We are doing very little paging currently. The bufferpool
appear to be doing the same.



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





-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
Behalf Of Jeff Frazier
Sent: Wednesday, January 05, 2005 7:40 AM
To: [login to unmask email]
Subject: Re: [DB2-L] New on Z/OS & experiencing slowness




William,
Did you go to z/OS 1.4 from what? Are you doing anymore PAGING? Are
bufferpools still responding the same as before?





"Proctor, William" <[login to unmask email]>
Sent by: DB2 Data Base Discussion List <[login to unmask email]>

01/05/2005 08:24 AM
Please respond to DB2 Database Discussion list at IDUG


To: [login to unmask email]
cc:
Subject: [DB2-L] New on Z/OS & experiencing slowness






Thanks for all replies in advance. We went to Z/OS 1.4 the second week
of December and since that time we keep getting complains of things
being just a little bit slower and our batch cycle seems to have
increased by about 40 minutes a night. Other jobs do seem to take just
a little longer to run. We are not getting any errors or anything to
indicate that there's a problem. When looking at individual jobs your
looking at 1 maybe two minutes but it's adding up over time. Sorry for
the vagueness but that's what we are working with at the moment. We
actually increased the amount of memory from 2.5 gig to 3 gig for our
production lpar. Has anyone else experienced this? Any suggestions on
what adjustments might be needed? We are on DB2 V7.1 using VP's backed
by HP's. We have not made any changes to the database during this
time.







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

William Proctor

Re: New on Z/OS & experiencing slowness
(in response to William Proctor)
Our WLM is setup in goal mode using the same settings as under OS/390
2.10.



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







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

Eric Pearson

Re: New on Z/OS & experiencing slowness
(in response to William Proctor)
Consider converting the VP+HP to dataspace if you have the 64 bit hardware.

Have you looked at some of the longer jobs with STROBE or RMF WDM?
Have you looked before/after at some of the longer DB2 batch jobs with DB2PM
accounting reports? Once you identify more precisely the component(s)
contributing
to the slowdown the puzzle will get much simpler.

-----Original Message-----
From: Proctor, William [mailto:[login to unmask email]
Sent: Wednesday, January 05, 2005 8:25 AM
To: [login to unmask email]
Subject: [DB2-L] New on Z/OS & experiencing slowness



Thanks for all replies in advance. We went to Z/OS 1.4 the second week of
December and since that time we keep getting complains of things being just
a little bit slower and our batch cycle seems to have increased by about 40
minutes a night. Other jobs do seem to take just a little longer to run.
We are not getting any errors or anything to indicate that there's a
problem. When looking at individual jobs your looking at 1 maybe two
minutes but it's adding up over time. Sorry for the vagueness but that's
what we are working with at the moment. We actually increased the amount of
memory from 2.5 gig to 3 gig for our production lpar. Has anyone else
experienced this? Any suggestions on what adjustments might be needed? We
are on DB2 V7.1 using VP's backed by HP's. We have not made any changes to
the database during this time.







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



This e-mail transmission contains information that is confidential and may be privileged. It is intended only for the addressee(s) named above. If you receive this e-mail in error, please do not read, copy or disseminate it in any manner. If you are not the intended recipient, any disclosure, copying, distribution or use of the contents of this information is prohibited. Please reply to the message immediately by informing the sender that the message was misdirected. After replying, please erase it from your computer system. Your assistance in correcting this error 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

Robert Lawrence

Re: New on Z/OS & experiencing slowness
(in response to Eric Pearson)
Bill,

Did you rebind your plans and packages(especially any that seem to be
slower)? With all of the AI in the optimizer it may recognize your operating
system change and take advantage of any improvements from the upgrade. Some
improvements happen when DB2 recognizes the new OS and some may not and may
even degrade(I am only surmising) until rebinding or binding. Also are the
number of processors the same? Just some thoughts

good luck


Bob Lawrence
DBA
Boscov's Dept Stores LLc


-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email]On Behalf
Of Proctor, William
Sent: Wednesday, January 05, 2005 8:25 AM
To: [login to unmask email]
Subject: [DB2-L] New on Z/OS & experiencing slowness


Thanks for all replies in advance. We went to Z/OS 1.4 the second week of
December and since that time we keep getting complains of things being just
a little bit slower and our batch cycle seems to have increased by about 40
minutes a night. Other jobs do seem to take just a little longer to run.
We are not getting any errors or anything to indicate that there’s a
problem. When looking at individual jobs your looking at 1 maybe two
minutes but it’s adding up over time. Sorry for the vagueness but that’s
what we are working with at the moment. We actually increased the amount of
memory from 2.5 gig to 3 gig for our production lpar. Has anyone else
experienced this? Any suggestions on what adjustments might be needed? We
are on DB2 V7.1 using VP’s backed by HP’s. We have not made any changes to
the database during this time.







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

Richard Humphris

Re: New on Z/OS & experiencing slowness
(in response to Robert Lawrence)

Hi Bill,

64 bit related --- when we went from 2.10 to z/os we had some
performance problems with SYNCSORT, which were resolved when we upgraded
to "syncsort for z/os". Of course, this effected performance on the
entire machine (in addition to an impact on DB2).

Also, you mentioned you were increasing the bufferpool sizes. But if
you increased the VP sizes (as well as the HP sizes), then make sure you
adjust the VDWQT and DWQT thresholds as well. Btw, could you have any
buffer pools where the hit ratio on the HP is so low that defining the
hiperpool is just using more cpu cycles than not having it at all?

Rich Humphris


E-MAIL CONFIDENTIALITY NOTICE: The contents of this e-mail message and any attachments are intended solely for the
addressee(s) and may contain confidential and/or legally privileged information. If you are not the
intended recipient of this message or if this message has been addressed to you in error, please
immediately alert the sender by reply e-mail and then delete this message and any attachments. If you
are not the intended recipient, you are notified that any use, dissemination, distribution, copying, or
storage of this message or any attachment is strictly prohibited.

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

Karthikeyan Vinayagam

Re: New on Z/OS & experiencing slowness
(in response to Richard Humphris)
presumably from 2.10 64bit? (not sure you could do it differently)
otherwise: I remember reading somewhere that moving pages from/to hiperpool
in central storage (true under z/arch) is slightly costlier than that in
expanded storage. just a thought.

On Wed, 5 Jan 2005 07:57:34 -0600, Proctor, William
<[login to unmask email]> wrote:

>We went to Z/OS 1.4 from OS/390 2.10. We are running 64 bit. I
>increased my bufferpools until the system did page and then I backed
>them off. We are doing very little paging currently. The bufferpool
>appear to be doing the same.
>
>
>
>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
>
>
>
>
>
>-----Original Message-----
>From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
>Behalf Of Jeff Frazier
>Sent: Wednesday, January 05, 2005 7:40 AM
>To: [login to unmask email]
>Subject: Re: [DB2-L] New on Z/OS & experiencing slowness
>
>
>
>
>William,
> Did you go to z/OS 1.4 from what? Are you doing anymore PAGING? Are
>bufferpools still responding the same as before?
>
>
>
>
>
>"Proctor, William" <[login to unmask email]>
>Sent by: DB2 Data Base Discussion List <[login to unmask email]>
>
>01/05/2005 08:24 AM
>Please respond to DB2 Database Discussion list at IDUG
>
>
> To: [login to unmask email]
> cc:
> Subject: [DB2-L] New on Z/OS & experiencing slowness
>
>
>
>
>
>
>Thanks for all replies in advance. We went to Z/OS 1.4 the second week
>of December and since that time we keep getting complains of things
>being just a little bit slower and our batch cycle seems to have
>increased by about 40 minutes a night. Other jobs do seem to take just
>a little longer to run. We are not getting any errors or anything to
>indicate that there's a problem. When looking at individual jobs your
>looking at 1 maybe two minutes but it's adding up over time. Sorry for
>the vagueness but that's what we are working with at the moment. We
>actually increased the amount of memory from 2.5 gig to 3 gig for our
>production lpar. Has anyone else experienced this? Any suggestions on
>what adjustments might be needed? We are on DB2 V7.1 using VP's backed
>by HP's. We have not made any changes to the database during this
>time.
>
>
>
>
>
>
>
>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 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

Paul Weissman

Re: New on Z/OS & experiencing slowness
(in response to Karthikeyan Vinayagam)
Bill,

Unless you have some performance data to identify potential problems it just be guesswork.

Going from OS/390 2.10 to z/OS 1.4 in one step is a very big jump. Our shop did it in multiple upgrades over a period of 4 years. Every upgrade had it's share of performance "hiper" problems, including our latest maintenance on z/OS 1.4. Most of the performance APARs since OS/390 except for the most recent would be fixed on your z/OS 1.4 system but there are many more issues with system parameters, application design, etc. that can cause degradation to batch job performance after a major operating system upgrade. The same thing applies to your 3rd party software products.

If you do not see any gross changes in the usual accounting measurements (CPU time, EXCP count, I/O connect time, DB2 accounting, etc.) you'll need data from a monitor like RMF-III, Omegamon, Strobe, etc..
Get all the before & after data for the most seriously impacted job to get a clue what's changed.
That will be better than guesswork or recitals of old "war stories".

-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email]On
Behalf Of Karthik Vinayagam
Sent: Wednesday, January 05, 2005 9:19 PM
To: [login to unmask email]
Subject: Re: [DB2-L] New on Z/OS & experiencing slowness


presumably from 2.10 64bit? (not sure you could do it differently)
otherwise: I remember reading somewhere that moving pages from/to hiperpool
in central storage (true under z/arch) is slightly costlier than that in
expanded storage. just a thought.

On Wed, 5 Jan 2005 07:57:34 -0600, Proctor, William
<[login to unmask email]> wrote:

>We went to Z/OS 1.4 from OS/390 2.10. We are running 64 bit. I
>increased my bufferpools until the system did page and then I backed
>them off. We are doing very little paging currently. The bufferpool
>appear to be doing the same.
>
>
>
>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
>
>
>
>
>
>-----Original Message-----
>From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
>Behalf Of Jeff Frazier
>Sent: Wednesday, January 05, 2005 7:40 AM
>To: [login to unmask email]
>Subject: Re: [DB2-L] New on Z/OS & experiencing slowness
>
>
>
>
>William,
> Did you go to z/OS 1.4 from what? Are you doing anymore PAGING? Are
>bufferpools still responding the same as before?
>
>
>
>
>
>"Proctor, William" <[login to unmask email]>
>Sent by: DB2 Data Base Discussion List <[login to unmask email]>
>
>01/05/2005 08:24 AM
>Please respond to DB2 Database Discussion list at IDUG
>
>
> To: [login to unmask email]
> cc:
> Subject: [DB2-L] New on Z/OS & experiencing slowness
>
>
>
>
>
>
>Thanks for all replies in advance. We went to Z/OS 1.4 the second week
>of December and since that time we keep getting complains of things
>being just a little bit slower and our batch cycle seems to have
>increased by about 40 minutes a night. Other jobs do seem to take just
>a little longer to run. We are not getting any errors or anything to
>indicate that there's a problem. When looking at individual jobs your
>looking at 1 maybe two minutes but it's adding up over time. Sorry for
>the vagueness but that's what we are working with at the moment. We
>actually increased the amount of memory from 2.5 gig to 3 gig for our
>production lpar. Has anyone else experienced this? Any suggestions on
>what adjustments might be needed? We are on DB2 V7.1 using VP's backed
>by HP's. We have not made any changes to the database during this
>time.
>
>
>
>
>
>
>
>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 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

Visit our website at http://www.ubs.com

This message contains confidential information and is intended only
for the individual named. If you are not the named addressee you
should not disseminate, distribute or copy this e-mail. Please
notify the sender immediately by e-mail if you have received this
e-mail by mistake and delete this e-mail from your system.

E-mail transmission cannot be guaranteed to be secure or error-free
as information could be intercepted, corrupted, lost, destroyed,
arrive late or incomplete, or contain viruses. The sender therefore
does not accept liability for any errors or omissions in the contents
of this message which arise as a result of e-mail transmission. If
verification is required please request a hard-copy version. This
message is provided for informational purposes and should not be
construed as a solicitation or offer to buy or sell any securities or
related financial instruments.

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

William Proctor

Re: New on Z/OS & experiencing slowness
(in response to Paul Weissman)
We were on OS/390 31 bit and went to Z/OS 1.4 64 bit. The problem does
seem to be getting worse and we are just barely making out batch
windows.

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



-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
Behalf Of Karthik Vinayagam
Sent: Wednesday, January 05, 2005 8:19 PM
To: [login to unmask email]
Subject: Re: [DB2-L] New on Z/OS & experiencing slowness

presumably from 2.10 64bit? (not sure you could do it differently)
otherwise: I remember reading somewhere that moving pages from/to
hiperpool
in central storage (true under z/arch) is slightly costlier than that in
expanded storage. just a thought.

On Wed, 5 Jan 2005 07:57:34 -0600, Proctor, William
<[login to unmask email]> wrote:

>We went to Z/OS 1.4 from OS/390 2.10. We are running 64 bit. I
>increased my bufferpools until the system did page and then I backed
>them off. We are doing very little paging currently. The bufferpool
>appear to be doing the same.
>
>
>
>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
>
>
>
>
>
>-----Original Message-----
>From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
>Behalf Of Jeff Frazier
>Sent: Wednesday, January 05, 2005 7:40 AM
>To: [login to unmask email]
>Subject: Re: [DB2-L] New on Z/OS & experiencing slowness
>
>
>
>
>William,
> Did you go to z/OS 1.4 from what? Are you doing anymore PAGING? Are
>bufferpools still responding the same as before?
>
>
>
>
>
>"Proctor, William" <[login to unmask email]>
>Sent by: DB2 Data Base Discussion List <[login to unmask email]>
>
>01/05/2005 08:24 AM
>Please respond to DB2 Database Discussion list at IDUG
>
>
> To: [login to unmask email]
> cc:
> Subject: [DB2-L] New on Z/OS & experiencing slowness
>
>
>
>
>
>
>Thanks for all replies in advance. We went to Z/OS 1.4 the second week
>of December and since that time we keep getting complains of things
>being just a little bit slower and our batch cycle seems to have
>increased by about 40 minutes a night. Other jobs do seem to take just
>a little longer to run. We are not getting any errors or anything to
>indicate that there's a problem. When looking at individual jobs your
>looking at 1 maybe two minutes but it's adding up over time. Sorry for
>the vagueness but that's what we are working with at the moment. We
>actually increased the amount of memory from 2.5 gig to 3 gig for our
>production lpar. Has anyone else experienced this? Any suggestions on
>what adjustments might be needed? We are on DB2 V7.1 using VP's backed
>by HP's. We have not made any changes to the database during this
>time.
>
>
>
>
>
>
>
>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 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

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

Venkat Srinivasan

Re: New on Z/OS & experiencing slowness
(in response to William Proctor)
Bill,
Did you investigate the work load activity report for all service
classes?. Did you notice changes in PI before and after the upgrade.

Do you see evidence of changes in class-2 elapsed time, class-2 cpu and
class-3 time?. WLM policy might need adjustments.

It could also be due to SQL performance degradation coincidentally
happening at the same time after the upgrade. Investigating the DB2
performance figures in conjuction with the Workload activity would put you
in the right direction.

We would need specific pointers to avoid guess work.
What changes were done to application / DB2 system, following the upgrade.

Regards,
Venkat

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

Reg Munusamy

Re: New on Z/OS & experiencing slowness
(in response to Venkat Srinivasan)
Hi Bill,

We have encountered something very similar to what you are experiencing when
migrating to Z/OS 1.4, but in our case we have noticed in a STROBE report
that a high percentage of time was being spent in the .XMEMORY module
(extended cross memory procedure). Average times were in double figures and
in one instance appeared at the top of the list in the "most intensivey
executed procedures" using 23% of the CPU.

BTW, we are on V6 and an ETR (72666) has been raised with IBM which is under
review.

Thanks,
Reg Munusamy
DB2 DBA
Woolworths Ltd

-----Original Message-----
From: Proctor, William [mailto:[login to unmask email]
Sent: Thursday, 6 January 2005 12:25 AM
To: [login to unmask email]
Subject: [DB2-L] New on Z/OS & experiencing slowness



Thanks for all replies in advance. We went to Z/OS 1.4 the second week of
December and since that time we keep getting complains of things being just
a little bit slower and our batch cycle seems to have increased by about 40
minutes a night. Other jobs do seem to take just a little longer to run.
We are not getting any errors or anything to indicate that there's a
problem. When looking at individual jobs your looking at 1 maybe two
minutes but it's adding up over time. Sorry for the vagueness but that's
what we are working with at the moment. We actually increased the amount of
memory from 2.5 gig to 3 gig for our production lpar. Has anyone else
experienced this? Any suggestions on what adjustments might be needed? We
are on DB2 V7.1 using VP's backed by HP's. We have not made any changes to
the database during this time.







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



***********************************************************
CAUTION: This Message may contain confidential information intended
only for the use of the addressee named above. If you are not the
intended recipient of this message you are hereby notified that any use,
dissemination, distribution or reproduction of this message is prohibited.
If you received this message in error please notify Mail Administrators
immediately. Any views expressed in this message are those of the
individual sender and may not necessarily reflect the views of
Woolworths Ltd.
***********************************************************


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