467,185 Members | 1,237 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,185 developers. It's quick & easy.

two phase commit?

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
Nov 12 '05 #1
  • viewed: 4244
Share:
4 Replies

"Lennart Jonsson" <le*****@kommunicera.umea.se> wrote in message
news:6d**************************@posting.google.c om...
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.

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

Rhino
Nov 12 '05 #2
Just read ahead a little more in the SQL Reference,
"Server options for federated systems" in the Federated Systems Guide

"Lennart Jonsson" <le*****@kommunicera.umea.se> wrote in message
news:6d**************************@posting.google.c om...
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

Nov 12 '05 #3
"Rhino" <rh****@NOSPAM.sympatico.ca> wrote in message news:<2o********************@news20.bellglobal.com >...
"Lennart Jonsson" <le*****@kommunicera.umea.se> wrote in message
news:6d**************************@posting.google.c om...
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.

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

Rhino


Sorry about that:

Redhat Enterprise AS
DB2 V8.1 fixpak 5

/Lennart
Nov 12 '05 #4
"Fan Ruo Xin" <fa*****@sbcglobal.net> wrote in message news:<69******************@newssvr15.news.prodigy. com>...
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

[...]
Nov 12 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by William Chan | last post: by
4 posts views Thread by MelApiso | last post: by
2 posts views Thread by Ravi Sankar | last post: by
5 posts views Thread by Ravi Chirawala | last post: by
2 posts views Thread by amoon.ljlj@gmail.com | last post: by
13 posts views Thread by paul.joseph.davis@gmail.com | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.