Pending changes from a finished job
0
votes
2
answers
788
views
I'm getting the following error:
>Uncommitted changes pending for file MYTABLE in library MYLIB.
>
>CPF325E
>
>Cause . . . . . : Uncommitted changes are pending for file MYTABLE in library MYLIB for commitment definition MYTABLE.
>
>Recovery . . . : Do one of the following and try your request again:
>
> -- Complete the commitment control process by doing a commit or rollback for commitment definition MYTABLE.
>
> -- Change the commitment control option and compile the program again.
>
>Technical description . . . . . . . . : The commitment definition identifier is X'5CC4C6E3C1C3E3C7D9D7'. The job that initiated the change(s) is 954538/QUSER/QZDASOINIT. The logical unit of work identifier is *N. The lock space identifier is *N. The XID is X'5CD5404040404040404040404040404040404040404040404040404040404040404040404040404040404040404040404040404040404040404040404040404040404040404040404040404040404040404040404040404040404040404040404040404040404040404040404040404040404040404040404040404040404040404040'.
Problem is, 954538/QUSER/QZDASOINIT is not an active job. It doesn't show up under active jobs and running this:
WRKCMTDFN 954538/QUSER/QZDASOINIT
Gives this:
> Job 954538/QUSER/QZDASOINIT not found.
...What is happening? How can a job that was finished be connected to pending changes? How can I rollback those changes?
EDIT: Responding to questions in an Answer:
> Where are you seeing the message?
That specific one is when, in System iNavigator, I right-click MYTABLE and select Journaling. The original error that made me find the problem is when C# throws:
> iDB2SQLErrorException: SQL0910 Object MYTABLE in MYLIB type *FILE has a pending change.
Likewise, I get a "changes are pending" error when trying to remove a referential constraint from MYTABLE.
> Do you have *JOBCTL authority? It may be that the job isn't gone, you just don't have authority to see it.
I don't know, nor do I know how to check. If I run:
WRKCMTDFN QUSER/QZDASOINIT
Then a bunch of jobs show up, but 954538 is not one of them.
Asked by Sarov
(281 rep)
Sep 12, 2019, 05:29 PM
Last activity: Sep 13, 2019, 01:58 PM
Last activity: Sep 13, 2019, 01:58 PM