IMS DC - DB2

[rejip]

We have an IMS DC screen which access DB2 database. The screen allows the user to insert new data to the database. Suppose while updating the database some error occurs. How will we rollback to the last committed state ?.

Please reply

 

[pkganapathi]

Rejip,

When an update error or abend occurs, the unit of work is not complete, so IMS would issue a ROLB. Otherwise, you can check for any invalid SQLCODES and issue an implicit CALL CBLTDLI USING ROLB,IO-PCB to rollback the changes.

-PK.

I.T.Analyst
Tata Consultancy Services

 

[Vallarapu]

Rejip,

When an Database update error occurs, Check for the SQLCodes and your application program should have a code issuing a ROLB which will roll back the changes.

Naveen
Kanbay Software