Is it possible to precompile if db2 goes down?
Answer Posted / 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 View All Answers
How does coalesce work?
Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?
What are catalog tables in db2?
What is the syntax for seeing the columns and data types of a table in the db2 database?
What is difference between isnull and coalesce?
What is iseries database?
What is db2 command?
How do I import a csv file into db2?
What is the function of logging in the db2 database?
What is performance tuning db2?
what is the sqlcode -501
Mention the different locking levels that are available in db2.
I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.
What is a Foreign Key?
Mention the downsides of page level lock.