PLAN IS AN EXECUTABLE ONE. I.E, WHEN THE CONCEPT OF MAIN PROGRAM AND SUB

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

Question Posted / srinvias yadav

3 Answers
9482 Views
Infosys, I also Faced
E-Mail Answers

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

Please Help Members By Posting Answers For Below Questions

Define db2.

1172

Which components manage deadlocks in db2?

1126

How would you find out the total number of rows in a db2 table?

1095

Which is faster delete or truncate?

1177

How can you validate Sql errors during cursor operation in db2 pgms and where do you code?

2268

What is the difference between plan and package in db2?

1175

What is precompiler in db2?

1080

Define db2 and its databases?

1115

For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.

1165

What is sqlca?

1133

How do I copy a table in db2?

1059

Is db2 a database?

1029

What is meant by explain?

1196

What is db2 command?

1091

List some fields from sqlca?

1107