Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> MainFrame >> IBM MainFrame >> DB2
  2. Suggest New Category

What is the specific need of Plan and..where are the tables
in DB2 are physically saved

Question Posted / srprev

Answers were Sorted based on User's Feedback



What is the specific need of Plan and..where are the tables in DB2 are physically saved..

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

What is the specific need of Plan and..where are the tables in DB2 are physically saved..

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

What is the specific need of Plan and..where are the tables in DB2 are physically saved..

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

Post New Answer

More DB2 Interview Questions

What is the syntax for FETCH in DB2 ?

0 Answers   MCN Solutions,

what is the differences between spufi and qmf and which is better?

4 Answers   Accenture, Cap Gemini,

Is db2 a programming language?

0 Answers  

how to resolve -811 sqlcode .give clear explaination

3 Answers   IBM,

What will the DB2 optimizer do?

2 Answers  

What is subquery ?

6 Answers  

How can you get the number of rows impacted by the last executed query?

1 Answers  

i know the stpes 2 create an executable CICS/DB2 cobol code. 1. DB2 Precompiler converts the SQL Statements into COBOL API statements and creates another member with Acess plans. CodeA results in CodeB (code with API calls) & CodeC ( Access Plans ) 2.Code B is compiled/linked 2 create an exceutable.(codeE) 3.Now CodeC is binded to the database on which CodeE will be run. Can somebody provide me the sample JCLs for precompile/compile/link/bind.

0 Answers  

What is the physical storage length of the data types: date, time, timestamp in the db2 database?

0 Answers  

What is dclgen (declaration generator)?

0 Answers  

When do you specify the isolation level?

0 Answers  

Define check constraint.

0 Answers  

For more DB2 Interview Questions Click Here
Categories