IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Some doubts


IBM Mainframe Forums -> Mainframe Interview Questions
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
rtalapaneni

New User


Joined: 20 Mar 2005
Posts: 13
Location: Bangalore

PostPosted: Mon May 16, 2005 5:58 pm
Reply with quote

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
View user's profile Send private message
subhasis_50

Moderator


Joined: 09 Mar 2005
Posts: 363
Location: Earth

PostPosted: Tue May 17, 2005 11:55 am
Reply with quote

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
View user's profile Send private message
arunoday

New User


Joined: 17 May 2005
Posts: 18
Location: Bangalore

PostPosted: Wed May 18, 2005 3:11 pm
Reply with quote

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
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> Mainframe Interview Questions

 


Similar Topics
Topic Forum Replies
No new posts Doubts in MQ data Converstions Java & MQSeries 3
No new posts Doubts related to insertion of table ... COBOL Programming 1
No new posts Doubts regarding Merging JCL & VSAM 5
No new posts Doubts in LA PL/I & Assembler 4
No new posts Need to Clarify some Doubts in Stream... All Other Mainframe Topics 8
Search our Forums:

Back to Top