• 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!

Re: AS/400 SQLPKG cleanup

rgz

Active Member
Re: AS/400 SQLPKG cleanup

Create a CL program full of DLTSQLPKG commands. Run this program as an early
call from your startup program (assuming you IPL at least once a month).
Alternatively, you can schedule it from WRKJOBSCDE. QZDASOINIT jobs tend to
leave locks lying around on SQLPKG's, so you'll need a CL pgm to shutdown
OneWorld, QSERVER, and the Host Servers first, run the DLT's, then start it
all up again.
Not recommended to point ODBC's to the same library... long story, see the
tuning guide.
 

LostinOW

Member
Re: AS/400 SQLPKG cleanup

Thanks for the tips.

Dalie
OneWorld Developer
One World Xe, SP 14.1, AS/400 V4R4M0
Windows 2000 SP1, SQL2000, Citrix Metaframe 1.8A SP1
 
Re: AS/400 SQLPKG cleanup

we are using JD Edwards Enterprise one, AS400 server & OS400 OS. While deleting the SQL package all packages are not getting deleted at time. Before deleting the SQL packages through CL program what code I will mention there. Kindly help me.
 
Top