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.
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.