View previous topic :: View next topic
|
Author |
Message |
rtalapaneni
New User
Joined: 20 Mar 2005 Posts: 13 Location: Bangalore
|
|
|
|
1) I am calling subprogram with three parameters. But in subprogram i am recieving two parameters. It will give any error?
2) If i alter a table with new column. Do i need to rebind the program?
(if i am not using the new column in the program)
3) What is Twophase Commit? |
|
Back to top |
|
|
subhasis_50
Moderator
Joined: 09 Mar 2005 Posts: 363 Location: Earth
|
|
|
|
HI,
1.You will not get any error.
2. As u r not using the column it is not required to bind the DBRM. As there are no changes in your SQL statement in the programs.
Thanks
Subhasis |
|
Back to top |
|
|
arunoday
New User
Joined: 17 May 2005 Posts: 18 Location: Bangalore
|
|
|
|
Hi
I am answering the third question.
rtalapaneni wrote: |
3) What is Twophase Commit? |
Two phase commit takes place when the transaction spread across more than one transaction manager.
The primary transaction manager who wants to do the COMMIT inquires to other transaction managers about their status ,i.e - whether ready to COMMIT or not. This is "Preparation phase" (First phase). If any of the other tarnsaction manager replies about its inability , the primary transaction manager issues a ROLLBACK command.
In the next step, when all the transaction managers are ready to COMMIT, the primary transaction manager issues the actual COMMIT statement. This is called "Commit PHase" (Second Phase). |
|
Back to top |
|
|
|