Guest.Visitor
09-22-2003, 10:55 PM
I need to find jobs that have pending uncommitted changes. Our save-while-active backup crashes when trying to back up the pending files. My approach so far is to try to figure out how to get the Commitment Control Status info returned by DSPJOB OPTION(*CMTCTL), in particular the Record Level Status or RDB Status info. Both show if there are pending transactions. I'll probably end up just sending the results to a splf and processing it in a program, but I thought I'd check here first. QUSRJOBI does not return the info, nor does QTNRCMTI (Retrieve Commitment Information). The latter only returns info about the job it is run in; there does not seem to be a way to tell it which job you want it to look at. Yet DSPJOB does it....