Re: QRWTSRVR job with open files - how to close?

[David Gibbs <david@xxxxxxxxxxxx>]

On 12/29/21 1:07 PM, Therrien, Paul via MIDRANGE-L wrote:
> We have QRWTSRVR jobs running on our system that are invoked from
> another IBM I. A stored proc on the source system will call a CL
> program on the target system. The target cl will call an RPG
> program(s) that run and set on *INLR and return. Which would close
> files and unlock files - I would hope. And the CL program also ends. 
> However, when I look at the QRWTSRVR job, that is currently sitting
> idle, I see dozens of open files. 

How is the RPG program accessing the database?  RLA (chain, read etc) or 
SQL?

If SQL, maybe it's a pseudo closed cursor?  I ran into that recently 
with the database host server jobs.

https://www.ibm.com/support/pages/pseudo-closed-cursor-faq

david