---
title: "How to Say Correctly – If DB2 down will Pre-compilation successful"
description: "This is an interview questions if DB2 is down will the pre-compilation successful. Here is correct answer."
url: https://srinimf.com/2016/03/23/db2-pre-compilation-during-db2-is-down-interview-question/
date: 2016-03-23
modified: 2026-10-10
author: "Srini"
image: https://i0.wp.com/srinimf.com/wp-content/uploads/2016/03/pexels-photo-1439087.jpeg?fit=1880%2C1253&ssl=1
categories: ["DB2"]
tags: ["DB2 Pre-compilation when DB2 is down"]
type: post
lang: en
---

# How to Say Correctly – If DB2 down will Pre-compilation successful

Here is a question asked in a recent interview. What happens to DB2 [pre compilation](https://srinimf.com/2012/03/16/db2-bind-time-and-precompile-errors/) process, when DB2 is down?

## The Correct Answer

[In DB2](https://srinimf.com/2017/01/02/the-best-substring-example-in-db2-for-quick-use/), 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

- [DB2: Bind vs Pre-compilation errors](https://srinimf.com/2012/03/16/db2-bind-time-and-precompile-errors/)DateMarch 16, 2012
- [DB2 Host Variables Here are 4 Key Points](https://srinimf.com/2018/05/10/4-top-db2-host-variable-points/)DateMay 10, 2018
- [DB2 Bind Options – And Their Correct Meaning](https://srinimf.com/2012/05/20/db2-bind-options-part-2/)DateMay 20, 2012

- [![30 SQL Practice Queries with Solutions — Run Them Live](https://i0.wp.com/srinimf.com/wp-content/uploads/2026/10/pexels-photo-5530473.jpeg?resize=867%2C1300&ssl=1)](https://srinimf.com/2026/10/01/30-sql-practice-queries-with-solutions-run-them-live/) ## [30 SQL Practice Queries with Solutions — Run Them Live](https://srinimf.com/2026/10/01/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.

### Share this:

-
- [Tweet](https://twitter.com/share)
- [![](https://i0.wp.com/assets.pinterest.com/images/pidgets/pinit_fg_en_rect_gray_20.png)](https://www.pinterest.com/pin/create/link/?url=https%3A%2F%2Fsrinimf.com%2F2016%2F03%2F23%2Fdb2-pre-compilation-during-db2-is-down-interview-question%2F&media=https%3A%2F%2Fi0.wp.com%2Fsrinimf.com%2Fwp-content%2Fuploads%2F2016%2F03%2Fpexels-photo-1439087.jpeg%3Ffit%3D1200%252C800%26ssl%3D1&description=How%20to%20Say%20Correctly%20-%20If%20DB2%20down%20will%20Pre-compilation%20successful)
-
- [Share on Tumblr](https://www.tumblr.com/share)
- [Share on WhatsApp (Opens in new window) WhatsApp](https://srinimf.com/2016/03/23/db2-pre-compilation-during-db2-is-down-interview-question/?share=jetpack-whatsapp)
- [More](#)
-

- [Print (Opens in new window) Print](https://srinimf.com/2016/03/23/db2-pre-compilation-during-db2-is-down-interview-question/?share=print)
- [Share on Reddit (Opens in new window) Reddit](https://srinimf.com/2016/03/23/db2-pre-compilation-during-db2-is-down-interview-question/?share=reddit)
- [Share on Telegram (Opens in new window) Telegram](https://srinimf.com/2016/03/23/db2-pre-compilation-during-db2-is-down-interview-question/?share=telegram)
- [Email a link to a friend (Opens in new window) Email](mailto:?subject=%5BShared%20Post%5D%20How%20to%20Say%20Correctly%20-%20If%20DB2%20down%20will%20Pre-compilation%20successful&body=https%3A%2F%2Fsrinimf.com%2F2016%2F03%2F23%2Fdb2-pre-compilation-during-db2-is-down-interview-question%2F&share=email)
-

### Like this:

Like Loading…