Re: Impact of XA Performance with OS 6.1/V6R1

Praveen,
We have applied several IBM operating systems PTF fixes and one unpublished
patch, and then we did an IPL to apply the fixes permanently, since I wrote
my last comments. In addition, we have also used Operations Navigator to
review query access plans and as a result we have added indexes that it
suggested (Power Link Maintenance History needed 3 new indexes to get better
performance).

Power Link performance is back to pre-V6R1 levels as a result of our efforts
(still not fast but at least as good as it was).

Your situation is somewhat different than ours. We have the luxury of test
partitions and we are more current on both Infor XA (R7.7) and the operating
system (we migrated from V5R3 of the operating system, skipping V5R4).

In your situation, I would be tempted to go to V5R4 of the operating system
so that I could get to a supported level, without having to work through the
difficulties that we experienced.

I hope this information is helpful.

-----Original Message-----
From: mapics-l-bounces@xxxxxxxxxxxx [mailto:mapics-l-bounces@xxxxxxxxxxxx]
On Behalf Of Praveen Kumar
Sent: Saturday, April 11, 2009 5:24 AM
To: MAPICS ERP System Discussion
Cc: tutika. praveen
Subject: Re: [MAPICS-L] Impact of XA Performance with OS 6.1/V6R1

Thanks Rad,
Your comments and experience would really help me. My situation is that we
are currently in V5R1 and would like to upgrade to V6R1. As one of my
friend in IBM suggested me to go for V5R4 rather than jumping to V6R1. We
are using XA R6.0, I am also having the same concern for performance.

We only have one production box(iSeries) and no developement/testing box, so
our situation is too bad to take any decision.

V6R1 is compatible on XA, but it is not tested or recommended as stated by
my IBM friend.

If not V5R5 would be a better option for my situation.

Please share your views if you have the same thoughts or different.

Thanks,
Praveen,
IT Manager,
Gabriel India Ltd.
Hosur, T.N, INDIA
Mob: +91-9003381028,
Email: tutika.praveen@xxxxxxxxxxxxx


On Sun, Jan 25, 2009 at 9:30 PM, Rad Yates <ryates@xxxxxxxxxxxxx> wrote:

We are running Infor XA 7.7 Level 6638 since July 2008.

Between Christmas 2008 and New Year 2009, we upgraded all partitions from
i5/OS V5R3 to V6R1 and replaced one of our two 550 servers (Power 5+

chips)

with a new M50 server (Power 6 chips) in a regular rotation of servers.

We

upgraded Power Link to the current level of 40.93 at the same time because
we experienced some issues with managing purhase orders in Procurement
Management.

We received immediate feedback that Power Link performance on the older

550

server was considerably slower. The new M50 is so much faster that we
are either hiding performance issues with horsepower or V6R1 works much
better on Power 6 chips than it does on Power 5+ chips.

We are having conversations with Infor, another Infor XA customer, and

IBM,

and several of my staff are reviewing our options. We have taken
several incremental steps and we have found some performance gains but our
users still report that Power Link is slower than before the upgrade:
1. We reallocated some CPU processing power to the XA partition and
experienced some improvement;
2. We have installed several Infor XA PTF's that pertain to performance
with limited results;
3. We have reallocated memory to the XA partition to reduce paging and saw
probably the largest improvement;
4. We are reorganizing Infor XA tables this weekend with unknown results.

We have discovered several other things that concern us:
1. The Infor XA ACSAPPLY process is not working on V6R1 and Infor is
working on this problem;
2. Infor XA uses the Classic IBM Java Virtual Machine and several programs
are hard-coded to that JVM;
3. Infor is testing the newer JVM for us, which IBM claims to have
performance advantages over Classic;
4. Our users are complaining about performance on client server
applications that use the ASNA engine too.

We are reviewing how Infor XA and our own applications use the query
optimization engines to see how often we are using the new more optimized
engine. We are looking at the QAQQINI tables, SQL statements, and

reviewing

indexes. There is a clear advantage to pointing SQL statements at
the physical tables instead of logical indexes and asking the query
optimizer to ignore indexes containing selects and omits (which is the new
V6R1 default value).

If anyone has additional suggestions or knowledge, please share it with

the

community.

Rad Yates
Director of I/T
MTD Products




________________________________
From: "Stoltz, Claude (BW-STL)" <Claude.Stoltz@xxxxxxxxxxxxxxxxxxx>
To: MAPICS-L@xxxxxxxxxxxx
Sent: Sunday, January 25, 2009 7:52:17 AM
Subject: [MAPICS-L] Impact of XA Performance with OS 6.1/V6R1

Hello group,



I'm wondering if anyone who is on Release 6 or Release 7 has upgraded to
the latest OS 6.1 or V6R1. If so, can you share any viewpoint on
performance or any other aspect of running XA/MAPICS R6 or R7 on the new
OS. We are considering moving forward with this new OS level as we are
currently on V5R3 and have hope of increasing performance with our R7.7
Power-Link applications. We do not want to impact the performance of
our R7 Power-Link users if this OS version is unwise to move onto at
this time. Any experience your willing to share would be greatly
appreciated or contact me directly. Thanks.



Claude Stoltz
Manager of Enterprise Applications
Barry-Wehmiller Companies, Inc.
claude.stoltz@xxxxxxxxxxxxxxxxxxx
8020 Forsyth Boulevard
Saint Louis, Missouri 63105
(314)862-8000 ext. 204

Cell: (636) 448-9639



_______________________________________________
This is the MAPICS ERP System Discussion (MAPICS-L) mailing list
To post a message email: MAPICS-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/mapics-l
or email: MAPICS-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/mapics-l.
_______________________________________________
This is the MAPICS ERP System Discussion (MAPICS-L) mailing list
To post a message email: MAPICS-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/mapics-l
or email: MAPICS-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/mapics-l.

_______________________________________________
This is the MAPICS ERP System Discussion (MAPICS-L) mailing list
To post a message email: MAPICS-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/mapics-l
or email: MAPICS-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/mapics-l.