Iseries uncommitted changes pending for file

Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.

Connect and share knowledge within a single location that is structured and easy to search. Technical description. The XID is X'5CD'. It doesn't show up under active jobs and running this:. What is happening? How can a job that was finished be connected to pending changes? How can I rollback those changes?

The original error that made me find the problem is when C throws:. It may be that the job isn't gone, you just don't have authority to see it. Where are you seeing the message? With the job gone, I wouldn't expect to see that message in an active job. Still no idea what caused this or what was happening. But I managed to fix it. So you're left with the sole "option" of logging off - which will end your job and associated commitment control. Stack Overflow for Teams — Collaborate and share knowledge with a private group.

Create a free Team What is Teams? Collectives on Stack Overflow. Learn more. Ask Question. Asked 8 years, 5 months ago. Active 8 years, 5 months ago. Viewed 4k times. Piro says Reinstate Monica. Piro says Reinstate Monica Piro says Reinstate Monica 1, 2 2 gold badges 20 20 silver badges 36 36 bronze badges. Add a comment. Active Oldest Votes. However, there are one or more active resources under commitment control for the commitment definition.

Buck Calabro Buck Calabro 7, 20 20 silver badges 25 25 bronze badges. So like Benny said ending job seems only valid option. I thought Turnover was a change management system, but I don't use it. If you are going to use this View I encourage you, at least once, to remove line 13 to see the results of all the pending database transactions in your partition.

This article was written for IBM i 7. Post a Comment To prevent "comment spam" all comments are moderated. Learn about this website's comments policy here. Some people have reported that they cannot post a comment using certain computers and browsers.

If this is you feel free to use the Contact Form to send me the comment and I will post it for you, please include the title of the post so I know which one to post the comment to. Lines 6 and 7: Move a value to the column in the table, and then write to the table.