What is the specific need of Plan and..where are the tables
in DB2 are physically saved

Answer Posted / srinvias yadav

PLAN IS AN EXECUTABLE ONE.
I.E,
WHEN THE CONCEPT OF MAIN PROGRAM AND SUB PROGRAM IS THERE
THEN WE NEED PLAN.
IF THERE IS A SINGLE PROGRAM THEN PACKAGE IS EXECUTABLE ONE.
ALL THE DB2 FILES ARE SAVED IN TABLESPACES.

Is This Answer Correct ?    2 Yes 8 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the difference between using bind () and rebind () methods of naming class?

777


Explain about rct in db2?

627


How many types of page locks can be held in db2?

583


What is buffer pool in the db2 database?

608


How is deadlock resolved?

640






What are types of indexes?

580


what is utility for parm lib

1863


What are the different types of base tables?

578


What is clone table?

587


How can deadlocks be resolved?

531


What is cascading rollback?

611


What is the difference between cursor and select statement?

605


Describe major components of db2?

632


Explain the contention situations caused by locks?

580


What is copy pending and check pending in db2?

567