What is the specific need of Plan and..where are the tables
in DB2 are physically saved
Answers were Sorted based on User's Feedback
Answer / srinivas chennareddy
Though the tables are stored logically in tables space and
physically all tables/table Spaces are stored in VSAM
files....so the ultimate pgysical storage of any database
object is a VSAM file.
Is This Answer Correct ? | 11 Yes | 0 No |
Answer / amit
plan is nothing but executable form of sql statements and
formed by one or more dbrms, it is used for run the program,
without plan it will not run.
physically tables are stored in table space of data base.
but the information of table is tabulated in system
table 'sysibm.systable'
correct me if i am wrong
Is This Answer Correct ? | 10 Yes | 1 No |
Answer / 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 |
query to just fetch first matching row and stop execution. once one matching row is found ..no more records should be checked.. if the first record is matching.. the query must stop
What is the difference between spufi and qmf?
Mention the length of physical storage of the given data types of db2 – date, timestamp, time
Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?
What is dpf in db2?
What are the contents of dclgen?
what are bind concepts in db2 cobol?
How to connect to db2 database from windows command line?
Do we have any optinon to search part of integer in DB2 as we have for character Like,SUBSTR optins?
What is the cascade rule and how does it relate to deletions made with a subselect?
What is runstats and reorg in db2?
What is a SELECT statement?