|
I am making a lot of code changes to a legacy system,
writing and deploying new apps.
There is a constant battle with system locks.
The system is way behind on PTFs because we cant afford
the down time ( and lack of knowledge on how to minimize the time
needed in restricted state to apply the PTFs ).
I am not definitive on this because I am only working on V5R3 .... at
that release for sure, the i is not easy to run 24/7. I am making a
lot of code changes to a legacy system, writing and deploying new
apps. There is a constant battle with system locks. SQL often retains
a lock on a file after the query is completed. I have to run the
ALCOBJ CONFLICT(*RQSRLS) command to free the locks up when replacing
the file. SQL VIEWS also stay locked for some reason, even after the
using job is ended. I use SQL VIEWs a lot to get a handle on legacy
databases. When I replace a view in PRD, the system eventually
releases the lock on the view being replaced, but it takes about 15
minutes. Then of course there are all those locks retained by legacy
code on data and device files ( and database records ). Would help a
lot to be able to tell the system to at least temporarily release
those locks. The system is way behind on PTFs because we cant afford
the down time ( and lack of knowledge on how to minimize the time
needed in restricted state to apply the PTFs ).
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.