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
 

 

db2 questions

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

Active User


Joined: 24 Feb 2004
Posts: 131
Location: Chennai

PostPosted: Thu Jul 08, 2004 3:38 pm    Post subject: db2 questions
Reply with quote

hi to all


1) whatz the use of view (Real time) ?

2) whatz bind, plan, package, collection ?

3) whatz buffer mgr, database mgr?

4) whatz runtime supervisor?

5) diff. types of lock and itz use. which one is best?

6) whatz isolation level ?

7) whatz use of QMF?

anbudan
karthi G.
Back to top
View user's profile Send private message

karthi_ind

Active User


Joined: 24 Feb 2004
Posts: 131
Location: Chennai

PostPosted: Mon Jul 12, 2004 2:14 pm    Post subject: answer plz
Reply with quote

hi

can anyone answer these questions? Why no answers frm anybody?

karthi G.
Back to top
View user's profile Send private message
sandip_datta

Active User


Joined: 02 Dec 2003
Posts: 151
Location: Tokyo, Japan

PostPosted: Mon Jul 12, 2004 3:50 pm    Post subject:
Reply with quote

All these are very basic questions and you will find it in any basic manual. Please search.

Regards,
Sandip.
Back to top
View user's profile Send private message
anuradha

Active User


Joined: 06 Jan 2004
Posts: 247
Location: Hyderabad

PostPosted: Mon Jul 12, 2004 7:29 pm    Post subject:
Reply with quote

hello karthi_ind,

Just a small suggestion. If we search these type of questions in the manual or in the net you will not only get answers for your questions, but also while searching you may get many details you know. Even i did the same at the start of my career. Really i gained lot in that way.

Just curious!!!!!!!! what is anbudan. Is it first name or something else?

Thanks,
Anu
Back to top
View user's profile Send private message
harikrishnanrajeev

EXPERT


Joined: 28 Jan 2004
Posts: 37
Location: Trivandrum

PostPosted: Mon Jul 12, 2004 8:59 pm    Post subject:
Reply with quote

Hello Karthi,


whatz bind, plan, package, collection ?

this was one of ur questions ...

why don't u read the TOPIC titled

"Know more abt Precompilation, DBRM, Plan etc "

listed in this DB2 forum. Its really a very good article.

cheers..

Hari.
Back to top
View user's profile Send private message
gowtham_srgp

New User


Joined: 09 Jun 2005
Posts: 38

PostPosted: Tue Aug 16, 2005 4:22 pm    Post subject: Re: db2 questions
Reply with quote

karthi_ind wrote:
hi to all


1) whatz the use of view (Real time) ?

2) whatz bind, plan, package, collection ?

3) whatz buffer mgr, database mgr?

4) whatz runtime supervisor?

5) diff. types of lock and itz use. which one is best?

6) whatz isolation level ?

7) whatz use of QMF?

anbudan
karthi G.




hai.

1. view is a table which is not a separate table and resides as an window in the base table. by a view we are enabled to view the portion of the base table and it is for security purpose in the real time .

2. bind- it is the process of compiling the queries.
plan- the compiled form of queries.
package- collection of plan or the bound produce of a plan. so, if there are more than one plan for a transaction, what happens is, these plans in turn undergo a binding and the package is created.
collection- it is the name given to a set of logically related plan. you don't confuse. these are just logical names and they do not really reside physically.

3. buffer manager- it is responsible for transfer of data from the virtual and real memory. it follows the concepts of read ahead buffering and look aside buffering about which i don't have any idea. if you've just share with me.

4. runtime supervisor is a part of main memory which is responsible for the actual execution of my plan. whenever there is a request for the execution of any sql query, it is my runtime supervisor's responsiblity to appropriately invoke the corresponding plan/package.
5. there are 3 types of locks namely , shared,update and exclusive.

6.isolation level on my bind package designates the level my bind package containing the lock for the table is isolated. there are 3 isolation levels namely cursor stability(cs), repeatable read(rr), uncommited read(ur).

7. QMF is a tool similar to that of SPUFI. Both are intended for testing the queries before they are coded as embeded in the cobol programs.


i hope these info will suffice.. corrections are welcomed.........



gowtham
Back to top
View user's profile Send private message
seshi_somanas

New User


Joined: 21 Jun 2005
Posts: 1
Location: hyderabad

PostPosted: Mon Aug 22, 2005 10:08 pm    Post subject: small doubt
Reply with quote

Dear friends,

could you tell me the diff betwen dd and dsn? In jcl

bye
seshi.........
Back to top
View user's profile Send private message
vijayamadhuri

Active User


Joined: 06 Apr 2005
Posts: 180

PostPosted: Mon Aug 22, 2005 11:02 pm    Post subject: Hi seshi_somanas
Reply with quote

Please ask u r question under new topic.It is misguiding as this is asked under db2 section.Please see to that u do that next time.


any way

DD-DATA DEFINITION FIELD -main functon is to describe the dataset(file) that the program will read from or write into.
dsn-dataset name--it is the file into which the data can be written into or read from
Back to top
View user's profile Send private message
vijayamadhuri

Active User


Joined: 06 Apr 2005
Posts: 180

PostPosted: Mon Aug 22, 2005 11:09 pm    Post subject: HI
Reply with quote

Quote:
whatz the use of view (Real time) ?


it is an alternate way to view the table.In real time not all people will be given access to the base table.In such cases priveliges are given only to handle with views.u can extarct all the info that u requirefron the views.This is done in order to maintain the data security and unwanted access to the data.

Quote:
2) whatz bind, plan, package, collection
?

please have a look at the following link
http://www.db2mag.com/story/showArticle.jhtml?articleID=15300107
http://www.db2mag.com/story/showArticle.jhtml?articleID=17602333
http://www.db2mag.com/story/showArticle.jhtml?articleID=18901299
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 Mainframe Interview Questions CICS,CO... akshathan Mainframe Interview Questions 6 Thu Feb 09, 2017 6:38 pm
No new posts Viewing executing process in NDM .. q... Debb.Brant IBM Tools 0 Wed Dec 14, 2016 10:55 pm
No new posts INCLUDE condition questions van bui DFSORT/ICETOOL 1 Thu Jun 30, 2016 9:52 am
No new posts SAS Programming - Basic Questions Techelm All Other Mainframe Topics 3 Fri Mar 18, 2016 10:53 pm
No new posts Where can i find Interview questions ... Elixir Mainframe Interview Questions 4 Sat Feb 20, 2016 12:38 am


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