View previous topic :: View next topic
|
Author |
Message |
karthi_ind
Active User
Joined: 24 Feb 2004 Posts: 131 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. |
|
Back to top |
|
|
karthi_ind
Active User
Joined: 24 Feb 2004 Posts: 131 Location: Chennai
|
|
|
|
hi
can anyone answer these questions? Why no answers frm anybody?
karthi G. |
|
Back to top |
|
|
sandip_datta
Active User
Joined: 02 Dec 2003 Posts: 150 Location: Tokyo, Japan
|
|
|
|
All these are very basic questions and you will find it in any basic manual. Please search.
Regards,
Sandip. |
|
Back to top |
|
|
anuradha
Active User
Joined: 06 Jan 2004 Posts: 247 Location: Hyderabad
|
|
|
|
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 |
|
|
harikrishnanrajeev
EXPERT
Joined: 28 Jan 2004 Posts: 37 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. |
|
Back to top |
|
|
gowtham_srgp
New User
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 |
|
Back to top |
|
|
seshi_somanas
New User
Joined: 21 Jun 2005 Posts: 1 Location: hyderabad
|
|
|
|
Dear friends,
could you tell me the diff betwen dd and dsn? In jcl
bye
seshi......... |
|
Back to top |
|
|
vijayamadhuri
Active User
Joined: 06 Apr 2005 Posts: 180
|
|
|
|
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 |
|
|
vijayamadhuri
Active User
Joined: 06 Apr 2005 Posts: 180
|
|
Back to top |
|
|
|