serenity_now
Active Member
Hi All,
We are running 8.12 on a iSeries server. Every Sunday morning we have a program that runs to do the following:
ENDS JDE Services
Clears IPC
DLTSQLPKG (QRECOVERY/O*)
DLTSQLPKG (QRECOVERY/T*)
DLTJRNRCV JRNRCV(OWJRNL/OWJRNR*) DLTOPT(*IGNINQMSG)
START JDE Services
We are having issues where we are having random JAS web client errors (errors like prepared statement in use, unknown jas sign in error, etc) and the only solution is to bounce the web instance. We have tweaked these web servers to death per Oracles reccomendations but this still seems to happen once a week on at least one of our web servers.
Oracle say it must be SQL package related. What strategy does everyone else for deleting packages on their iSeries? Do you just remove whats in QRECOVERY? What about the packages in all pathcodes/data source libraries? We currently dont touch these and am not sure what performance impact there will be if we delete this weekly.
We are running 8.12 on a iSeries server. Every Sunday morning we have a program that runs to do the following:
ENDS JDE Services
Clears IPC
DLTSQLPKG (QRECOVERY/O*)
DLTSQLPKG (QRECOVERY/T*)
DLTJRNRCV JRNRCV(OWJRNL/OWJRNR*) DLTOPT(*IGNINQMSG)
START JDE Services
We are having issues where we are having random JAS web client errors (errors like prepared statement in use, unknown jas sign in error, etc) and the only solution is to bounce the web instance. We have tweaked these web servers to death per Oracles reccomendations but this still seems to happen once a week on at least one of our web servers.
Oracle say it must be SQL package related. What strategy does everyone else for deleting packages on their iSeries? Do you just remove whats in QRECOVERY? What about the packages in all pathcodes/data source libraries? We currently dont touch these and am not sure what performance impact there will be if we delete this weekly.