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.


Ref: http://www.ibm.com/developerworks/data/library/techarticle/dm-1311db2halicensing/


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: