rollback

Vikas Puri

rollback
Hi ALL,

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 with
commit. But I guess above should not give any problem.
Please suggest.

Thanks
vp

Sibimon Philip

Re: rollback
(in response to Vikas Puri)
I have not tested, but rollback also should be two phase. Cics must be
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.

Thanks
Sibimon Philip
972-702-2515 - Office
972-417-3597 - Residence
E-mail - [login to unmask email]


-----Original Message-----
From: Vikas Puri [mailto:[login to unmask email]
Sent: Friday, October 08, 1999 10:42 AM
To: [login to unmask email]
Subject: rollback


Hi ALL,

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 with
commit. But I guess above should not give any problem.
Please suggest.

Thanks
vp

Vikas Puri

Re: rollback
(in response to Sibimon Philip)
I am doing 'syncpoint rollback' if SQLcode is other than 0 while updating
one DB2 table.
Actually we are getting ASP3 abend at that syncpoint rollback. Program has
lots of syncpoint so I thought if it can be replaced by rollback.
Thanks
vp
At 11:52 AM 10/8/99 -0400, you wrote:
>I have not tested, but rollback also should be two phase. Cics must be
>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.
>
>Thanks
>Sibimon Philip
>972-702-2515 - Office
>972-417-3597 - Residence
>E-mail - [login to unmask email]
>
>
>-----Original Message-----
>From: Vikas Puri [mailto:[login to unmask email]
>Sent: Friday, October 08, 1999 10:42 AM
>To: [login to unmask email]
>Subject: rollback
>
>
>Hi ALL,
>
>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 with
>commit. But I guess above should not give any problem.
>Please suggest.
>
>Thanks
>vp
>

[login to unmask email]

Re: rollback
(in response to Vikas Puri)
If u use EXEC SQL ROLLBACK END EXEC instead of EXEC CICS SYNCPOINT ROLLBACK
END EXEC then u will get sqlcode -926 as in case of commit u will get -925
and it means that it is not valid in IMS or CICS as ROLLBACK is also two
phase .

Sanjeev




>
>Hi ALL,
>
>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 with
>commit. But I guess above should not give any problem.
>Please suggest.
>
>Thanks
>vp
>