Interested to Buy Any Domain ? << Click Here >> for more details...
Is it possible to precompile if db2 goes down?
- 4 Answers
- 14084 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 |
How would you move a tablespace (using STOGROUP) to a different DASD volume allocated to that tablespace?
What action db2 takes when a program aborts in the middle of a transaction?
Define buffer pool.
Explain package in db2 and its advantages?
How many buffer pools are available in db2?
can any one give the list of some important sql abend codes which r frequently asked in interviews?
DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?
what is the use of commit ? and what is the syntax?
How to take backup of table in db2?
For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.
How to retrieve rows from a db2 table in embedded sql?
What is cursor in dbms?
COBOL 
