Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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

What is coalesce in db2?

0 Answers  


what is the input to PLAN? what is the input to DBRM?

4 Answers  


Q4. How will you get the count of record without using COUNT verb in query?

2 Answers   IBM,


in db2, already 10 columns arie der, and i want to insert 11th column. what parameters u wil consider for insertion and how will u insert

1 Answers   TCS,


What are the levels of isolation available with DB2V4

2 Answers   IBM,






How to define the data items to receive the fetch items for the SQL?

2 Answers  


what is Static and dynamic linking

1 Answers   Virtusa,


How do I start db2 in windows?

0 Answers  


Explain an outer join?

1 Answers  


What is a db2 package?

0 Answers  


Plan is an executable form of sql statements,But what exactly resides inside a Plan. what are the details inside Plan.

2 Answers   IBM,


How can you compare table column after update and before update?

5 Answers   Satyam,


Categories