Skip to main content

developerWorks >  Information Management  >  Forums  >  IBM DB2 Express Forum  >  developerWorks

DB2 Express-C License Question    Point your RSS reader here for a feed of the latest messages in this thread


Tags for this thread: 

     

 
 

My developerWorks
 Welcome, Guest
Sign in or register
This question is not answered.

Permlink Replies: 1 - Pages: 1 - Last Post: Nov 6, 2009 3:27 PM Last Post By: Z-Company
impetej

Posts: 3
Registered: Nov 06, 2009 07:56:53 AM
DB2 Express-C License Question
Posted: Nov 06, 2009 08:38:16 AM
 
Click to report abuse...   Click to reply to this thread Reply
I have read IBM's articles involving licensing and the versions of DB2:

http://www.ibm.com/developerworks/data/library/techarticle/dm-0909db2halicensing
http://www.ibm.com/developerworks/data/library/techarticle/dm-0909db2compare/

Thinking about having 2 servers (Express-C, unless this is a license issue) one is active and sending it logs to a Standby Server which is applying the logs every 15 minutes or so (the instance is started, thus making it "warm". I know HADR is not part of the Express-C licensing and understand that if we use any other kind of outside software that is not allowed either. Here is the snippet from the compare article...

You cannot use HA clustering software of any kind to cluster DB2 Express-C servers for HA. For example, availability clustering through Microsoft Clustering Services, SteeleEye, or even the built-in DB2 HA clustering facilities are not allowed with DB2 Express-C.

Is having the standby machine with an instance started and applying logs considered part of the "built-in DB2 HA clustering facilities"? I am not sure if that definition is limited to only separate add on products/editions such as HADR, DB2 pureScale, etc. Clearly applying logs actively on the standby does reduce the MTTR.

My read is that this is not allowed with Express-C since it would be warm, but I didn't see where this was specifically addressed other than being classified as warm. With non DB2 Express-C it is clear you would need to license any warm standby as shown in Firgure 1 & Figure 2 in the HA licensing article.

Any help on this would be appreciated.

Thanks!
Valued Contributor Z-Company

Posts: 233
Registered: Dec 04, 2007 11:08:12 AM
Re: DB2 Express-C License Question
Posted: Nov 06, 2009 03:27:16 PM   in response to: impetej in response to: impetej's post
 
Click to report abuse...   Click to reply to this thread Reply
log shipping to another unlicensed server is allowed even with paid db2 license as long as instance is stopped on target server (no other active databases are running on it). It have nothing to do with db2, you are just moving data around.

After primary server fails, you just start instance on backup server, apply remaining redo logs and users can connect to it. Common choice is to use backups/restore from TSM. Its very simple to setup. Its not considered as clustering or HA because you are doing manual switching not using other software such as HACMP.
 Tags
Help

Use the search field to find all types of content in My developerWorks with that tag.

Use the slider bar to see more or fewer tags.

Popular tags shows the top tags for this particular type of content or application that you're viewing.

My tags shows your tags for this particular type of content or application that you're viewing.

 

MoreLess 


Point your RSS reader here for a feed of the latest messages in all forums