• Introducing Dark Mode! Switch by clicking on the lightbulb icon next to Search or by clicking on Default style at the bottom left of the page!

SQL Packages and AS/400

We have had problems with applications that we run on the AS/400 using the
RUNUBE command suddenly quit working. Several examples are the Invoice Print
R42565, Sales Update R42800, and Master Planning Schedule - Multiple Plant
R3483. We schedule these jobs to run nightly via the AS/400 job scheduler.
Periodically applications stop working for some unknown reason. I discovered
today that one of the reasons may be the SQL package. I was told by JDE that
these should be deleted periodically. There is a document in the KG
explaining this OTI-99-0072. I am hoping that this does the trick since MRP
stopped working last night. In the past we would check the version out and
back in and submit the version specs to the AS/400, which usually corrects
the problem.

I was just curious if there are others who delete the SQL packages and how
often?

Tom Chmielewski
Flair Corp

B7332, SP11.3
AS/400 V4R5
NT 4.0 Citrix



Tom Chmielewski
Sr. Programmer/Analyst
Flair Corp.
Ocala, Fl
 

graham_jones

Active Member
We delete all our *SQLPKG's once a week.

Graham Jones
JDE Systems Manager
graham.jones@parkgroup.co.uk
0151 653 1700 ext 1109

B7332 SP15 / AS400 V4R4 (CO on AS400) / Fat clients NT4



***** DISCLAIMER ***** This communication contains information which is
confidential. It is for the exclusive use of the intended recipient. If you
are not the intended recipient, please note that any distribution, copying
or use of this communication or the information in it is prohibited. If you
have received this communication in error, please notify us by email or by
telephone on 0151 653 1700 and then delete the email and any copies of it.
*****
 

hotm6654

Well Known Member
We delete our package in 3 situations:

1. Once a week
2. After major OS/400 upgrades.
3. After majore JDE upgrades (including service packs).

Hope this helps.





JD Nowell
OW: B7332
ES: AS400 V4R4 CO: DB2/400 SP: 11.2
Users: 250 TSE Users: 100
 

rfletche

Active Member
Graham
I thought there are a couple of SQLPKG that the AS400 need to operate - QIWS/QZAPKG,
QSYS/SQXDPKG and perhaps QSYS/QSQLPKG2?
regards
Robert

graham_jones wrote:
 

graham_jones

Active Member
Robert,

Yes you are right. What I should have said was don't delete any beginning
with Q as these are the IBM ones.

Regards,

Graham.
Graham Jones
JDE Systems Manager
graham.jones@parkgroup.co.uk
0151 653 1700 ext 1109

B7332 SP15 / AS400 V4R5 (CO on AS400) / Fat clients NT4



***** DISCLAIMER ***** This communication contains information which is
confidential. It is for the exclusive use of the intended recipient. If you
are not the intended recipient, please note that any distribution, copying
or use of this communication or the information in it is prohibited. If you
have received this communication in error, please notify us by email or by
telephone on 0151 653 1700 and then delete the email and any copies of it.
*****
 
Top