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
-
How to Create a Generic Stored Procedure for KPI Calculation (SQL + AWS Lambda)
In modern data engineering, building scalable and reusable systems is essential. Writing separate SQL queries for every KPI quickly becomes messy and hard to maintain. A better approach?👉 Use a Generic Stored Procedure powered by Dynamic SQL, and trigger it using AWS Lambda. In this blog, you’ll learn: What is a Generic Stored Procedure? A…
Srinimf 