Slow performance from .NET to AS/400
We’re not big AS/400 experts but we are currently working on a .NET application that needs to access AS/400 for real-time We’ve been getting some varied results (on queries) over the past two weeks and can’t figure out why. Our first request (SPROC on AS/400), it usually takes about 15 seconds to get the data....
| December 30, 2013 3:29 PM
, iSeries Navigator
Locating active procedures in iSeries SQL
I have a strange problem in iSeries SQL. I’m running a script that fails every time it tries to create a procedure that already exists. The script is quite involved and necessary to complete a number of projects. Is there a way I can determine if specific procedures within the system already exist and drop...
| December 18, 2013 7:03 PM
, SQL Scripting
Security issues going from V5R2 to V5r4
we upgraded from V5R2 to V5r4 and now I am getting authority problems on any update programs in our custom programing library. User authorities were copied over. That seems fine. Were there any know security problems going from R2 to R4? I get around each instance by changing program to use Adopted authority of the...
| November 15, 2013 3:07 PM
, iSeries security