Interested to Buy Any Domain ? << Click Here >> for more details...
What is the specific need of Plan and..where are the tables
in DB2 are physically saved
- 3 Answers
- 9165 Views
- Infosys, I also Faced
- E-Mail Answers
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 |
What is meant by concurrency?
What is package versioning? Please give an example.
What is subquery ?
Explain what are the various isolation levels possible?
What is the physical storage length of each of the following DB2 data types: DATE, TIME, TIMESTAMP?
How do I connect my db2 database to ibm?
when we are trying to update db2 rows. if the program abends . how we will know that the last successful update row was
If I have a view which is a join of two or more tables, can this view be updateable?
in the CURSOR declare statement, if i am using an where clause and trying to compare the value with a host-varialble. EXEC SQL DECLARE C1 CURSOR FOR SELECT DEPTNO, DEPTNAME, MGRNO FROM DEPARTMENT WHERE ADMRDEPT = :ADM-DEPT Where would i need to provide value to this host-variable in the where clause. how could i pass value to this host-variable to check it.
What will the DB2 optimizer do?
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.
0 Answers ITC Infotech, Syntel,
What is a DBRM, PLAN ?
COBOL 
