RE: Another V5R2 question -- SYSTEM21

Juan,

When we upgraded from V4R5 to V5R2 in November, we only had three S21 pgms that 
wouldn't convert and I believe it was due to observability.  We are on version 
3.5.0b of S21.  From looking at the "last used date" information, it appeared 
that they were never used, so I ignored them and we've not had a problem.  If 
these ARE used in your shop, you might want to check with GEAC - I would think 
they could give you modules updated for V5R2.

With regard to performance, my first guess was that you hadn't converted your 
data libraries (files are converted, too).  But since you mentioned that in the 
first paragraph, you must have.  SQL might very well be the culprit.  In doing 
some reading this weekend about SQL cursors, I learned that the less specific 
you are about the use of the cursor, the more resource SQL brings to handle all 
variations.  So, the more specific you are, the more opportunity there is for 
SQL to be more efficient in the resources it chooses.  If the vendor's software 
is using a "lazy" approach to SQL coding, it could be causing the degradation.  
I would think your warehousing module vendor should be able to help you 
optimize the software for V5R2.  V5R2 also includes (through Ops Nav) some 
tools to help investigate SQL performance issues.

We only noticed a slight degradation post V5R2, but within two weeks, we had 
converted from our 730 to an 825, and all our performance problems disappeared 
after that!  The 825 is a screamer. We partitioned it and moved our development 
system into a partition on it and now the development system is even light 
years faster - our testing users are delighted.

==Kevin

-----Original Message-----
From: system21-bounces@xxxxxxxxxxxx
[mailto:system21-bounces@xxxxxxxxxxxx]On Behalf Of Juan Doe
Sent: Tuesday, February 03, 2004 8:12 AM
To: System 21 Users
Subject: [SYSTEM21] Another V5R2 question


Hi

we are currently upgrading our test box to V5R2 and
during the Object Conversion, a lot of System21
programs are failing to convert. I believe this is
because Observability was removed from the program
before being delivered by JBA. Some of the programs we
have the source for, but the ones in the IPGxxxxx
libraries did not come with source code.

I guess you people already at V5R2 must have
encountered this as well - so can anyone advise how
you got around this issue please.

Another quickie - we tried going to V5R2 about 10
months ago, but encountered a big performance
degradation, mainly noticeable on a non System21
module we have for data warehousing. This has a lot of
imbedded SQL and as the whole SQL engine was changed
in this release, our decision was to hold off until
IBM had released their usual lengthy batch of PTF's.

For anyone who has recently gone to V5R2 - did you
notice any significant performance reduction?

Many Thanks for any help...


Juan

__________________________________
Do you Yahoo!?
Yahoo! SiteBuilder - Free web site building tool. Try it!
http://webhosting.yahoo.com/ps/sb/
_______________________________________________
This is the System 21 Users (SYSTEM21) mailing list
To post a message email: SYSTEM21@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/system21
or email: SYSTEM21-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/system21.



**********************************************************************
CONFIDENTIALITY NOTICE:  The information transmitted in this message is 
intended only for the person or entity to which it is addressed and may contain 
confidential and/or privileged material.  Any review, retransmission, 
dissemination or other use of this information by persons or entities other 
than the intended recipient is prohibited.  If you received this in error, 
please contact the sender and destroy all copies of this document.  Thank you.  
The Butler Company
**********************************************************************