GeekInterview.com
   Home |  Tech FAQ  |   Interview Questions |  Placement Papers |  Tech Articles |  Learn |  Freelance Projects |  Online Testing |  Geeks Talk |  Job Postings |  Knowledge Base | Site Search |  Add/Ask Question

  GeekInterview.com  >  Interview Questions  >  Mainframe

 Print  |  
Question:  CICS and DB2

Answer: When executing a CICS program that updates DB2 tables, if the program performs a LINK to another CICS modules and the Database changes have not been commited, will the process Rollback the database changes or will they still be in place when CICS returns to the main program.


August 08, 2009 09:21:06 #1
 darapradeep   Member Since: August 2009    Total Comments: 4 

RE: CICS and DB2
 

CICS have special future for data Base updates i.e. TWO FACE COMMIT. On completion of CICS program, syncpoint will execute which will commit the changes from CICS end and request for DB2 Commit.

For this question, here there is no explicit DB2 Commit request and the CICS not completed. So the changes will rollback. 

     

 

Back To Question