What is the logical entity between plan and Package?

Answer Posted / vamsi

Plan is an executabel one which provides access path to
access the DBRM's.

Is This Answer Correct ?    0 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain the contents that are a part of dclgen.

651


What are bind parameters in db2?

611


have 3 tables table1, table2 and table3 which contains employee information. table1 is master table, table2 contains emp details like emp no and so on, table 3 contains emp salary. so if any emp leave company between 25th - 30th of every month it has to get updated in tables. but it is not getting updated. What is the reason.

1232


What is explain in db2?

582


Differentiate between cs and rr isolation levels? Where do you specify them?

576






What is dbrm library?

575


When the like statement is used?

629


What are db2 tables?

641


What is ibm db2 database?

530


Mention the downsides of page level lock.

703


What is a db2 table?

593


Is schema the same as database?

625


Define db2 and its databases?

616


What is cascading rollback?

619


How will you return the number of records in table?

514