Can you take a look at the open files for the job and see whether the files are still open? Do you have any OVRDBF’s in place?
Try a RCLRSC between menu options and see whether that makes any difference.
Do not use RCLRSC at all unless you are <b>certain</b> that all active processes are OPM. If you have ILE activation groups in your job (and you quite possibly do if you’re executing any number of IBM functions, not to mention your own application code), you can mess things up real quick.
Most likely the RPGSQL programs/modules need to be recompiled with appropriate options to close cursors properly.
Show the compile options that were used, including SQL options. Suggestions can be given that may be more appropriate.