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
How and when does the db2 enforces the unique key?
What is cursor with hold option in db2?
What is the clustering index in the db2 database?
How to resolve deadlock issue
What is the meaning concurrency in the db2 database?
What is schema in db2?
What is the default page size of buffer pools?
What is a page in db2?
How do I delete a table in database?
I HAVE 500 ROW TO UPDATE I WOULD LIKE TO USE ROLLBACK ALONG WITH COMMIT.WHAT IS THE SYNTAX TO CODE COMMIT AND ROLLBACK FOR EVERY 100 ROWS.AND HOW THE CURSOR ROLLBACK TO THE LAST COMMITTING POINT.
What is rebind in db2?
How do I import a csv file into db2?
Explain about rct.
How can deadlocks be resolved?
How to retrieve rows from a db2 table in embedded sql?