Here is a question asked in a recent interview. What happens to DB2 pre compilation process, when DB2 is down?
The Correct Answer
In DB2, the pre-compilation is an inbuilt process. When DB2 is down, the DB2 resources may not be available, so pre-compilation will fail and BIND also will fail.
The answer for this question is pre-compilation process will not be successful.
Related Posts
-
30 SQL Practice Queries with Solutions — Run Them Live
Practice 30 SQL queries with solutions, from SELECT and JOINs to subqueries and window functions. Run SQL queries live in an interactive SQL Playground.

