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.

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

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.

How do I add a column to an existing table in db2?

0 Answers  

---

Explain how can you do the explain of a dynamic sql statement?

0 Answers  

---

What is query for your birthday date should be in hours,minute and seconds format?

1 Answers   Fidelity,

---

If there is no row in Emp table with Ename as Raghava and you run the below queries in SPUFI. 1.select Ename from EMP wher Ename = 'raghava' 2.Select count(*) from EMP where Ename = 'raghava' What is SQLCODE shown up in SPUFI

4 Answers   ADP,

---

Can DASD types assigned to storage groups be intermixed (i.e., 3350s and 3380s)?

1 Answers  

---

What is image copy in db2?

0 Answers  

---

What is a system catalog table in db2?

0 Answers  

---

In cursor program perform para varying until 1 by 1 fetch para cursor------close para in the blank what will come for confirming in the database?

1 Answers   HCL,

---

File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?

0 Answers   Infosys,

---

What is DCLGEN ?

2 Answers  

---

Which is faster delete or truncate?

0 Answers  

---

Where do you specify them?

0 Answers  

---