ca.portal.admin

Re: Question: Why Severe Performance Degradation after Database

Discussion created by ca.portal.admin on Mar 15, 2006
Enlarge

Hello Bill:

That is good news, I guess your IDMS Consultant was right on the money!

I also thought that you might have overloaded the DASD Cache, in my
experience with the EMC boxes they usually take about 8 Gig for their
common areas and ID Tables, so, some people think that they have 16 Gig
for cache when the actual portion that they can use is only 8 Gig.

Bill Allen
ARCH Consulting Associates, Ltd.

"
IDMS Public Discussion Forum
IDMS-L@LISTSERV.IUASSN.COM
SMTP
IDMS-L@LISTSERV.IUASSN.COM
IDMS-L@LISTSERV.IUASSN.COM
SMTP








Normal

Normal
Re: Question: Why Severe Performance Degradation after Database Enlarge
"Hello Bill:

That is good news, I guess your IDMS Consultant was right on the money!

I also thought that you might have overloaded the DASD Cache, in my
experience with the EMC boxes they usually take about 8 Gig for their common areas
and ID Tables, so, some people think that they have 16 Gig for cache when the
actual portion that they can use is only 8 Gig.

Bill Allen
ARCH Consulting Associates, Ltd.

"
IDMS Public Discussion Forum
IDMS-L@LISTSERV.IUASSN.COM
SMTP
IDMS-L@LISTSERV.IUASSN.COM
IDMS-L@LISTSERV.IUASSN.COM
SMTP








Normal

Normal
Question: Why Severe Performance Degradation after Database Enlarge
"From: Bill Vohs, SC Data Center, Monroe, Wi
Date: March 15, 2006

Back in February I submitted the following.

_____________________________________________
From: Vohs, Bill
Sent: Wednesday, February 01, 2006 2:09 PM
To: 'idms-l@listserv.iuassn.com'
Subject: Question: Why Severe Performance Degradation after
Database Enlarge

From: Bill Vohs, SC Data Center, Monroe, Wi
Date: February 1, 2006

Subject: Enlarge/Expand IDMS Database

We are running:

z/OS 1.4
IDMS Release 16 SP02
EMC DMX2000 DASD

We have a need to enlarge a number of the IDMS databases.

Every time we do, we experience a severe performance degradation.
Run times elongate by a factor of 3 to 5.

Our first attempt was back in November.
The approach at that time was to do an UNLOAD and RELOAD to enlarged
area.
This time the databases were enlarged by a factor of 3.
One database went from 15,000 tracks on a 3390 to 45,000 tracks.
Another database went from 7,000 tracks to 21,000 tracks.

Our run times were:

Before UNLOAD/RELOAD 11/09/2005 74
minutes
11/10/2005 46 minutes

After UNLOAD/RELOAD 11/16/2005 174
minutes
11/1/2005 198 minutes

Our second attempt was January 29, 2006..
The approach for this time was to do a EXPAND PAGE to enlarged area
This time the databases were enlarged by a factor of 2.
One database went from PAGE SIZE 5064 to 10796 from 15,000 tracks to
30,000 tracks.
Another database went from PAGE SIZE 5064 to 10796 from 7,000 tracks
to 14,000 tracks.

The run times are:

Before EXPAND PAGE 01/26/2006
64 minutes

After EXPAND PAGE 01/31/2006
209 minutes
02/01/2006 212 minutes


We have had an IDMS consultant review our work and he says every thing
looks
great.

Our z/OS and IDMS statistics show nothing out of the ordinary.


We are at a bit of a loss.

Might anybody have any suggestion for us?
------------------------------------------------------------------------
-----------------------------------------------------------

We have been fighting this problem off and on since then.

We would try something and it would look good then go sour on us.

Finally the hardware people got involved.
Our DASD vendor, EMC, took a look at the problem.
EMC installed another 16gb DASD cache the weekend of 03/04/2006. We had
16gb to start with.

The jobs in question went from hours to minutes in run times.

I.e. PIC530 ran 209 minutes on 01/31/2006
212 minutes on 02/01/2006


PIC530 running between 30-50 minutes since cache
install.

All other jobs are experiencing same results.

Bill Vohs
SC Data Center

"
IDMS Public Discussion Forum
IDMS-L@LISTSERV.IUASSN.COM
SMTP
IDMS-L@LISTSERV.IUASSN.COM
IDMS-L@LISTSERV.IUASSN.COM
SMTP








Normal

Normal
Re: XOMT/CMMT product
"Are you Neon's paying customer ?

Bella Masterov
Manager DBA
718-312-5008
bella.masterov@empireblue.com




""EDWARD TIMM""
<ETIMM@SALLIEMAE.COM> To:
Sent by: ""IDMS IDMSVENDOR-L@LISTSERV.IUASSN.COM
3rd-party providers cc: (bcc: Bella
forum"" Masterov/WTC1/Empire)
<IDMSVENDOR-L@LISTSERV. Subject: Re: XOMT/CMMT product
IUASSN.COM>


03/15/2006 02:20 PM
Please respond to ""IDMS
Public Discussion
Forum""






We use XOMT/CMMT on ZOS 1.4, we will be moving to ZOS 1.7 (didn't think
about this do we need to update XOMT/CMMT for the upgrasde?
bella.masterov@EMPIREBLUE.COM 03/15/2006 02:00:42 PM >>>
I would like to know, if anyone using XOMT/CMMT product with ZOS 1.7
or
any ZOS >1.4.
If anybody does, what release of XOMT/CMMT is being installed.

This E-Mail has been scanned for viruses.







============================================================
===========
CONFIDENTIALITY NOTICE: This e-mail message, including any
attachments, is for the sole use of the intended recipient(s) and
may contain confidential and privileged information or otherwise
protected by law. Any unauthorized review, use, disclosure or
distribution is prohibited. If you are not the intended recipient,
please contact the sender by reply e-mail and destroy all copies of
the original message.
============================================================
============

"
IDMS Public Discussion Forum
IDMS-L@LISTSERV.IUASSN.COM
SMTP
IDMS-L@LISTSERV.IUASSN.COM
IDMS-L@LISTSERV.IUASSN.COM
SMTP








Normal

Normal
Re: XOMT/CMMT product
"We use XOMT/CMMT on ZOS 1.4, we will be moving to ZOS 1.7 (didn't think
about this do we need to update XOMT/CMMT for the upgrasde?
bella.masterov@EMPIREBLUE.COM 03/15/2006 02:00:42 PM >>>
I would like to know, if anyone using XOMT/CMMT product with ZOS 1.7
or
any ZOS >1.4.
If anybody does, what release of XOMT/CMMT is being installed.

This E-Mail has been scanned for viruses.

"
IDMS Public Discussion Forum
IDMS-L@LISTSERV.IUASSN.COM
SMTP
IDMS-L@LISTSERV.IUASSN.COM
IDMS-L@LISTSERV.IUASSN.COM
SMTP








Normal

Normal
"Re: [IDMSVENDOR-L] CVs up during ""soft"" timechange?"
"thanks to Linda and and Dan - the apars required were included in 15.0
SP5 - so i feel all warm and fuzzy on the upcoming time change


Chris Hoelscher
IDMS & DB2 Database Administrator
Humana Inc
502-710-3038
choelscher@humana.com




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.

"
IDMS Public Discussion Forum
IDMS-L@LISTSERV.IUASSN.COM
SMTP
IDMS-L@LISTSERV.IUASSN.COM
IDMS-L@LISTSERV.IUASSN.COM
SMTP








Normal

Normal
XOMT/CMMT product
"I would like to know, if anyone using XOMT/CMMT product with ZOS 1.7 or
any ZOS >1.4.
If anybody does, what release of XOMT/CMMT is being installed.

"
IDMS Public Discussion Forum
IDMS-L@LISTSERV.IUASSN.COM
SMTP
IDMS-L@LISTSERV.IUASSN.COM
IDMS-L@LISTSERV.IUASSN.COM
SMTP








Normal

Normal
"Re: CVs up during ""soft"" timechange?"
"A possible starting point.....

If I remember correctly, QO36778 (R15) is specific to the spring time
change. Hopefully references the updated PIB Dan mentions. Don't know if
there is an update for R16.

Linda Campbell
Informatix, Inc.

Outcomes