Monthly Archives: May, 2016

DB2 ESE Standby HADR Licensing requirement


We are currently running DB2 ESE 10.1 on Primary Database. We would like to implement HADR with 1 standby. What are the licensing implications?

My Response:

The answer to this question depends on usage of STANDBY database server.

There are 3 different ways we can use standby server:

  1. HOT (active) standby:  A Physical/Virtual server that has operational DB2 databases which service user transactions and queries is called HOT. Because, it handles transactions/queries.

          For example 1:

Node1 (Active server) has 1 database: PROD

Node2 (Standby server) has 3 databases: TEST1, TEST2, PROD (which gets replicated from active PROD)

Even though you don’t use PROD on standby, both TEST1 and TEST2 are still operational to respond to user transactions/queries. Hence, STANDBY server is considered as HOT/Active.

          For example 2:

Node1 (Active server) has 1 database: PROD

Node2 (Standby server) has 1 database: PROD (which gets replicated from active PROD)

 But, you do READS on standby, which classifies it as HOT.  These READS are still considered as transactions/queries.

What about licensing in case of HOT standby?

In my opinion, you need to get fully licensed on standby server, but better to check with IBM Support.


2. WARM standby:

Standby server doesn’t involve in servicing user transactions or query workloads. However, your standby will be in ROLLFORWARD PENDING state and has to apply transaction logs continuously.

WARM Standby scenario is also called as “Vanila” HADR configuration (the read on standby capability is not being used).

From my experience, we don’t have to fully license WARM standby server. However 25% of licenses need to be bought for standby. With this knowledge, please initiate a discussion with your client manager/IBM Support.

3. COLD standby:

Standby server is neither HOT nor WARM.  Most of the cases, COLD standby will be in SHUTDOWN mode. If primary goes down, then only we will start COLD standby and apply backup/transaction logs to bring it to latest consistent point to start database server.

I don’t think we need any license for COLD standby server.

These licensing terms vary with respect to production version: DB2 Express C, Workgroup, Enterprise, and Advanced Enterprise models.

Also, we have various licensing metrics: Limited Use Virtual Server, Fixed Term License, Limited Use Socket, Terabyte License, Processor Value Unit, Authorized User Single Install.

In summary, For a DBA/Developer, these permutations and combinations are little confusing in the first place. Even though, you are confident on what licenses needed, it is always advisable to explain business requirement to IBM Support and take their inputs.

Cheers! Ravi

Credits: Partly, referred below developer works article to answer the above query.