two phase commit?

[Lennart Jonsson]

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_commi t 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_commi t 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

[Rhino]

Re: two phase commit?


"Lennart Jonsson" <lennart@kommun icera.umea.se> wrote in message
news:6dae7e65.0 410050951.64205 348@posting.goo gle.com...[color=blue]
> 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_commi t 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_commi t setting.
>
> Problem is I cant find this in the SQL Reference. Can anyone point out
> where in the SQL Ref this is described.
>[/color]
It might help if you could tell us which operating system you are using and
which version of DB2 you are running.

Rhino

[Fan Ruo Xin]

Re: two phase commit?

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



"Lennart Jonsson" <lennart@kommun icera.umea.se> wrote in message
news:6dae7e65.0 410050951.64205 348@posting.goo gle.com...[color=blue]
> 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_commi t 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_commi t 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[/color]

[Lennart Jonsson]

Re: two phase commit?

"Rhino" <rhino1@NOSPAM. sympatico.ca> wrote in message news:<2oC8d.151 78$jj2.745369@n ews20.bellgloba l.com>...[color=blue]
> "Lennart Jonsson" <lennart@kommun icera.umea.se> wrote in message
> news:6dae7e65.0 410050951.64205 348@posting.goo gle.com...[color=green]
> > 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_commi t 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_commi t setting.
> >
> > Problem is I cant find this in the SQL Reference. Can anyone point out
> > where in the SQL Ref this is described.
> >[/color]
> It might help if you could tell us which operating system you are using and
> which version of DB2 you are running.
>
> Rhino[/color]

Sorry about that:

Redhat Enterprise AS
DB2 V8.1 fixpak 5

/Lennart

[Lennart Jonsson]

Re: two phase commit?

"Fan Ruo Xin" <fanruox@sbcglo bal.net> wrote in message news:<69I8d.117 52$zZ1.9914@new ssvr15.news.pro digy.com>...[color=blue]
> Just read ahead a little more in the SQL Reference,
> "Server options for federated systems" in the Federated Systems Guide
>
>[/color]

Thanx, I think I have found it


/Lennart

[...]