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 explain in db2?

585


What is precompiler in db2?

587


What is a db2 cursor?

626


How to check sequence on a table in db2?

600


Which command is used to connect to a database in DB2 ? Give the Syntax.

602






What is cobol db2?

570


Explain in detail about buffer manager and its functionalities?

564


What is null indicator in cobol db2?

586


How do I connect my db2 database to ibm?

602


Explain about cursor stability?

623


Mention the various locks that are available in db2.

616


What is a bind in db2?

594


What types of tables are there in the db2 database?

556


How is a typical db2 batch pgm executed?

642


If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?

706