IBM MAINFRAME HELP & SUPPORT FORUMS

karthi_ind · Joined: 24 Feb 2004 Posts: 64 Location: Chennai

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.

karthi_ind · Joined: 24 Feb 2004 Posts: 64 Location: Chennai

hi

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

karthi G.

sandip_datta · Joined: 02 Dec 2003 Posts: 152 Location: Tokyo, Japan

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

Regards,
Sandip.

anuradha · Joined: 06 Jan 2004 Posts: 257

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

harikrishnanrajeev · Joined: 28 Jan 2004 Posts: 40 Location: Trivandrum

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.

gowtham_srgp · Joined: 09 Jun 2005 Posts: 38

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

seshi_somanas · Joined: 21 Jun 2005 Posts: 1 Location: hyderabad

Dear friends,

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

bye
seshi.........

vijayamadhuri · Joined: 06 Apr 2005 Posts: 187

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

vijayamadhuri · Joined: 06 Apr 2005 Posts: 187

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