Interested to Buy Any Domain ? << Click Here >> for more details...
Is it possible to precompile if db2 goes down?
- 4 Answers
- 14025 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 |
Cursors can be declared in both working-storage & procedure division, agreed. But is there any difference? If could you please suggest what is the difference
What are the rules for db2 programming?
What is cursor stability?
How are write I/Os from the buffer pool executed?
Explain the contention situations caused by locks?
Which components manage deadlocks in db2?
What is the maximum length of sqlca?
What is reorg in DB2
What technique is used to retrieve data from more than one table in a single SQL statement?
How can you compare table column after update and before update?
can any one provide me the link for the db2 v7 & db2 v8 manual for Z/os? i need to know about the syntax of REORG in both versions & need to know the difference as well
What are the Isolation levels possible ?
COBOL 
