Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

What is mean by attachment facility in db2

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> Mainframe Interview Questions
View previous topic :: :: View next topic  
Author Message
tomrsan

New User


Joined: 15 Oct 2005
Posts: 13
Location: chennai

PostPosted: Tue Dec 06, 2005 7:12 pm    Post subject: What is mean by attachment facility in db2
Reply with quote

hi
1.what is mean by attachment facility in db2?
2. what is the max abd min. limit can we give for db2 lock?
3. where is the information for the rollback we can get?
4. why rollback occurs?
5. what is mean by autocommit?
what is mean by alias- i know the answer but whats the correct way to say while the interviewer as me ?
Back to top
View user's profile Send private message

iknow

Active User


Joined: 22 Aug 2005
Posts: 413
Location: Colarado, US

PostPosted: Tue Dec 06, 2005 8:18 pm    Post subject: Re: attachment facility
Reply with quote

Hi tomsran,

Quote:
1.what is mean by attachment facility in db2?


An attachment facility is a part of the DB2 code that allows other programs to connect to and use. DB2 to process SQL statements and commands.

Quote:
4. why rollback occurs?


Check this link for a clear explanation on rollback.
http://publib.boulder.ibm.com/infocenter/dzichelp/v2r2/index.jsp?topic=/com.ibm.db2.doc.apsg/bjnqmstr314.htm


Quote:
6.what is mean by alias- i know the answer but whats the correct way to say while the interviewer as me ?

An alternative name used to identify a table.
Aliases can refer to local or remote sites.Alias can be referenced by several users


If I get the exact explanation for the rest I will update in this list.
Hope this helps.
Back to top
View user's profile Send private message
khamarutheen

Active Member


Joined: 23 Aug 2005
Posts: 680
Location: NJ

PostPosted: Fri Dec 09, 2005 12:31 pm    Post subject: Interview Query
Reply with quote

Hi frnd,

Quote:
2. what is the max abd min. limit can we give for db2 lock?

i think there is nothing like min and max... it depends upon the programmer... IRLMPROC will take care of the locking services of DB2..

Quote:
3. where is the information for the rollback we can get?


Refer the link specified by iknow... hope it's enough..

And in the interview point of view u can just say some practical examples.. ie., say what is it and say the situation where it can b used..... i think it will add an extra point once u say the answer with an example...
Back to top
View user's profile Send private message
tomrsan

New User


Joined: 15 Oct 2005
Posts: 13
Location: chennai

PostPosted: Sat Dec 10, 2005 5:27 pm    Post subject: which one is the lowet lock level?
Reply with quote

hi khamarutheen
thanx , the links are very usefull to me,

1) which is the lowest lock level? page, table or tablespace?
Back to top
View user's profile Send private message
khamarutheen

Active Member


Joined: 23 Aug 2005
Posts: 680
Location: NJ

PostPosted: Mon Dec 12, 2005 10:32 am    Post subject: Lock Level
Reply with quote

Hi santhosh,

I think it goes in this way

1. Page
2. Table
3. Tablespace...
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> Mainframe Interview Questions All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts COOLGEN - TSO TEST FACILITY indianrajput CA Products 4 Wed Nov 02, 2016 9:28 pm
No new posts Issue in sending zip file as mail att... ajithajt JCL & VSAM 8 Thu Apr 07, 2016 9:11 am
No new posts IBM Encryption Facility OpenPGP - ASC... Mark Walker69 IBM Tools 3 Thu Oct 15, 2015 10:43 pm
No new posts Empty excel attachment in mail receiv... gs185008 COBOL Programming 8 Mon Jul 13, 2015 7:45 pm
No new posts Delete record from Coupling facility ... maxsubrat JCL & VSAM 1 Thu May 14, 2015 11:34 am


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us