RE: V5R3 Performance Issue

["Ingvaldson, Scott" <SIngvaldson@xxxxxxxxxxxx>]

Rick -

Don't give up that battle!  IIRC *MAX1TB has been the default since
about V4R1.  I spent over two years fighting this one with our
programmers and the end result was that when we converted to *MAX1TB it
was a complete non-issue.  I also recall that the worst possible
performance is in a mixed environment with some *MAX1TB and some *MAX4GB
access paths.

See:
http://www-912.ibm.com/s_dir/slkbase.nsf/90402cf55bdbcdc786256ffd0076ec0
5/d0992b5f1fb2b2bc862568a90068cf06?OpenDocument&Highlight=2,*MAX1TB

Change your physical files first and then change the logicals.  The
access paths will rebuild, so if you have big files they may take some
time.  Also watch for logicals in separate libraries from the associated
physical file.  I have the code that we used to do this (one library at
a time.)  If you like I can send it to you.

I'm not going to promise you magical improvements, YMMV.  But sometimes
you've got to drag people into the next century.  (I'm currently trying
to force migration to the Apache HTTP server, also a two year battle,
required to upgrade to V5R3.)

Regards,
 
Scott Ingvaldson
iSeries System Administrator
GuideOne Insurance Group

-----Original Message-----
date: Wed, 18 May 2005 17:03:00 -0500
from: <Rick.Chevalier@xxxxxxxxxxxxxxx>
subject: RE: V5R3 Performance Issue


I've already lost that battle.  I keep fighting the war though.

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


Change the DDS logicals and see your performance improve.

Chris Bipes
Information Services Director
CrossCheck, Inc.


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

Sent: Wednesday, May 18, 2005 12:01 PM
To: midrange-l@xxxxxxxxxxxx
Subject: RE: V5R3 Performance Issue



We migrated from V5R2.

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