Is it possible to precompile if db2 goes down?

Answers were Sorted based on User's Feedback



Is it possible to precompile if db2 goes down?..

Answer / i-tek

Yes. Because the precompiler does not refer to the DB2
catalogue tables.

Is This Answer Correct ?    9 Yes 0 No

Is it possible to precompile if db2 goes down?..

Answer / ram

100 % correct. During pre-compile, DB2 doest not required
to be up. Because it wont refer any DB2 catalog tables....
its does a basic syntax checking by referring DB2
DECLGEN....

Is This Answer Correct ?    9 Yes 0 No

Is it possible to precompile if db2 goes down?..

Answer / kranthi kumar

while bind step takes place, definitely db2 should be up.

Is This Answer Correct ?    1 Yes 2 No

Is it possible to precompile if db2 goes down?..

Answer / reddy kanupuru

Yes. DB2 need not be up during precompilation stage. at
that stage DB2 will get the info about tables using DCLGEN
not from the tables

Is This Answer Correct ?    1 Yes 3 No

Post New Answer

More DB2 Interview Questions

how do u update the faltfile into db2 table ?

4 Answers   RBS, TCS,


How is deadlock resolved?

0 Answers  


How to execute stored procedures?

0 Answers  


What is a clustered index?

1 Answers  


How can we retrieve the total number of records in RPG & CLLE?

0 Answers  






Is db2 a database?

0 Answers  


if there is a table with huge number of records and if i want to extract only first 3 records from the table, what query i have to provide to retreive first 3 records

4 Answers   UST,


What are the disadvantages of PAGE level lock?

3 Answers  


how can u retrieve the data from null values using applicaion program.

3 Answers   TCS,


What are the three types of page locks that can be held?

1 Answers  


Explain the contention situations caused by locks?

0 Answers  


Define buffer pool.

0 Answers  


Categories