two phase commit?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Lennart Jonsson - 05 Oct 2004 18:51 GMT

I need to do a two phase commit (a transaction over a table and a
nickname). Trying to do so gives me the error SQL30090N reason = 18

The suggested action is:

If multiple data sources need to be updated within a unit of
work, make sure the two_phase_commit server option has been
set to 'Y' for all the data sources that need to be updated.
See the SQL Reference for information on setting the value
used for the two_phase_commit setting.

Problem is I cant find this in the SQL Reference. Can anyone point out
where in the SQL Ref this is described.

Thanx in advance
/Lennart

Reply to this Message

Rhino - 05 Oct 2004 20:14 GMT

> I need to do a two phase commit (a transaction over a table and a
> nickname). Trying to do so gives me the error SQL30090N reason = 18
[quoted text clipped - 9 lines]
> Problem is I cant find this in the SQL Reference. Can anyone point out
> where in the SQL Ref this is described.

It might help if you could tell us which operating system you are using and
which version of DB2 you are running.

Rhino

Reply to this Message

Lennart Jonsson - 06 Oct 2004 04:26 GMT

> > I need to do a two phase commit (a transaction over a table and a
> > nickname). Trying to do so gives me the error SQL30090N reason = 18
[quoted text clipped - 14 lines]
>
> Rhino

Sorry about that:

Redhat Enterprise AS
DB2 V8.1 fixpak 5

/Lennart

Reply to this Message

Fan Ruo Xin - 06 Oct 2004 02:47 GMT

Just read ahead a little more in the SQL Reference,
"Server options for federated systems" in the Federated Systems Guide

> I need to do a two phase commit (a transaction over a table and a
> nickname). Trying to do so gives me the error SQL30090N reason = 18
[quoted text clipped - 12 lines]
> Thanx in advance
> /Lennart

Reply to this Message

Lennart Jonsson - 06 Oct 2004 17:03 GMT

> Just read ahead a little more in the SQL Reference,
> "Server options for federated systems" in the Federated Systems Guide

Thanx, I think I have found it

/Lennart

[...]

Reply to this Message