Is it possible to precompile if db2 goes down?
- 4 Answers
- 13279 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 |
Define predicate?
If I have 5 Queries in a DB2 Cobol program , while precompiling how many DBRMs will get created and How many Plans and Packages will get created while Bind Process?
What is a NULL value? What are the pros and cons of using NULLS?
How do you filter out the rows retrieved from a Db2 table ?
quary for 1> fetch last record 2> fetch in reverse order 3> fetch last 5 row 4> fetch second last record (their is no primary key) i think concept of count can be use for this in 4th
Give some example of statistics collected during RUNSTATS?
What is bind package and plan in db2?
What if we try to insert the base table through updatable view , but failed to give a column value which is defined as NOT NULL.
Plan has the optimized access path in it. But is that optimized access path is attained or known
Usually, which is more important for DB2 system performance - CPU processing or I/O access?
how to fetch first 100 rows in db2
What is clone table?
COBOL 
