Is it possible to precompile if db2 goes down?
- 4 Answers
- 12499 Views
- Target, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / i-tek
Yes. Because the precompiler does not refer to the DB2
catalogue tables.
| Is This Answer Correct ? | 9 Yes | 0 No |
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 |
Answer / kranthi kumar
while bind step takes place, definitely db2 should be up.
| Is This Answer Correct ? | 1 Yes | 2 No |
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 |
When would you prefer to use VARCHAR?
What does the RUNSTATS Utility do?
How to execute stored procedure in db2 command editor?
What is index cardinality?
what is the use of bind parameter, Replace?
What are some characteristics of columns that benefit from indexes?
I need to view the number of tables existing under one particular Owner. Is it possible? If so, pl give the SQL query for this?
What is the difference between Where and Having Clause
Explain how can you do the explain of a dynamic sql statement?
For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.
What is dbrm? When it will be created?
What will the DB2 optimizer do?
COBOL 
