October 8, 1999 11:23 AM
(in response to Sibimon Philip)
I am doing 'syncpoint rollback' if SQLcode is other than 0 while
one DB2 table.
Actually we are getting ASP3 abend at that syncpoint rollback.
lots of syncpoint so I thought if it can be replaced by
At 11:52 AM 10/8/99 -0400, you wrote:
>I have not tested, but rollback also should be two phase. Cics
>handling other recoverable resource like VSAM file or MQ
series, so need to
>rollback that also. Most probably you will get a negative
sqlcode with new
>DB2 rollback. DB2 may not execute.
>972-702-2515 - Office
>972-417-3597 - Residence
>E-mail - [login to unmask email]
>From: Vikas Puri [mailto:[login to unmask email]
>Sent: Friday, October 08, 1999 10:42 AM
>To: [login to unmask email]
>A small question to the gurus of DB2.
>Can I replace exec cics syncpoint rollback exit cics.
>with exec sql rollback exit rollback.
>I know syncpoint is double phase commit and we can't replace it
>commit. But I guess above should not give any problem.