RE: V5R3 Performance Issue

[<Rick.Chevalier@xxxxxxxxxxxxxxx>]

We migrated from V5R2.

DDS logicals are set at *MAX4GB (existed before 1TB option) and SQL indexes are 
set at *MAX1TB.

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx]On Behalf Of Chris Bipes
Sent: Wednesday, May 18, 2005 1:43 PM
To: 'Midrange Systems Technical Discussion'
Subject: RE: V5R3 Performance Issue


What did you upgrade from?  What are your LF indexes set at for
ACCPTHSIZ(*MAX1TB or *MAX4GB)

With 5.3 *MAX4GB sucks in performance with SQL.  Update the indexes to
*MAX1GB and you will see a big difference.

Chris Bipes
Information Services Director
CrossCheck, Inc.


-----Original Message-----
From: Rick.Chevalier@xxxxxxxxxxxxxxx [mailto:Rick.Chevalier@xxxxxxxxxxxxxxx]

Sent: Wednesday, May 18, 2005 11:08 AM
To: midrange-l@xxxxxxxxxxxx
Subject: RE: V5R3 Performance Issue



I seriously doubt that an index was deleted.  Once a file, index, view, etc,
is created they tend to stay around.  The files in use are for the
application I support so I'm sure I would have heard something if one was
deleted.  There is also a second embedded SQL program that has experienced
an increase of run time.

I can't say about the cache.  Memory pools are changed prior to nightly
processing by a CL program so that shouldn't have changed.  I do know that
operations has been watching it almost every night and has been making
adjustments to try and improve the run time.  Any change to cache would
probably have been caught and if not it may be impossible to tell at this
point.
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.



Privileged and Confidential.  This e-mail, and any attachments there to, is 
intended only for use by the addressee(s) named herein and may contain 
privileged or confidential information.  If you have received this e-mail in 
error, please notify me immediately by a return e-mail and delete this e-mail.  
You are hereby notified that any dissemination, distribution or copying of this 
e-mail and/or any attachments thereto, is strictly prohibited.