Unix Technical Forum

two-phase-commit with nicknames on 8.2.2 linux SQL/PL procedure?

This is a discussion on two-phase-commit with nicknames on 8.2.2 linux SQL/PL procedure? within the DB2 forums, part of the Database Server Software category; --> On Linux or Solaris with UDB 8.2.2, can an SQL/PL stored-procedure use two-phase-commit with nicknames and if DB2 provides ...


Go Back   Unix Technical Forum > Database Server Software > DB2

Register FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 02-27-2008, 05:20 AM
_link98@yahoo.com
 
Posts: n/a
Default two-phase-commit with nicknames on 8.2.2 linux SQL/PL procedure?

On Linux or Solaris with UDB 8.2.2, can an SQL/PL stored-procedure
use two-phase-commit with nicknames and if DB2 provides the
Transaction-manager?

i.e. in the same transaction, can an SQL/PL procedure
update a local table and
also update a nicknamed-table (in another database
on the same hostname), before committing ?

Is this possible, or must I have a CLI procedure and not use nicknames?

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #2 (permalink)  
Old 02-27-2008, 05:20 AM
_link98@yahoo.com
 
Posts: n/a
Default Re: two-phase-commit with nicknames on 8.2.2 linux SQL/PL procedure?

To answer my own question, from the v8.2 "federated systems guide":
"Federated Systems do not currently support the two phase commit
protocol".

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 02:14 AM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.0
www.UnixAdminTalk.com