ChannelDB2

Data Replication for the IBM Smart Analytics System 7700

Someday after you get through reading the outstanding highlights in this week's announcement of the 7700, you may want to know what your replication options are. The answer is pretty much the same as it is for the 7600. I'll use this post to give you a quick rundown (and it will look a whole lot like my post for the 7600 :).

 

As you can see from the license information document, the 7700 includes IBM's DB2 and InfoSphere Warehouse products. This means you have two replication technologies built into the system - SQL Replication and Q Replication.

 

 

SQL Replication

 

This is core DB2 function on UNIX and Windows. In other words, it's part of every DB2 edition you can buy just as functions like the Export and Load utilities are. There's no need to purchase anything extra. And, since InfoSphere Warehouse is built on top of DB2, SQL Replication is part of every Warehouse as well.

 

You can use SQL Replication to replicate data between an IBM Smart Analytics System and any of the following:

 

  • Other Smart Analyitcs Systems
  • DB2 for Linux, UNIX, and Windows
  • InfoSphere Warehouse
  • DB2 for z/OS
  • DB2 for i5/OS (iSeries)

 

However, you must purchase SQL Replication on z/OS or i5/OS if you need to replicate to or from the DB2 on those platforms. You can also replicate from an IBM Smart Analytics System to many different targets with SQL Replication, including the following if you purchase InfoSphere Replication Server for the target system:

 

  • Oracle
  • Microsoft SQL Server
  • Sybase ASE
  • Informix (IDS)
  • Teradata
  • Databases with JDBC 3.0+ compliant JDBC drivers such as PostgreSQL

 

You can also use SQL Replication to feed changed data into ETL processes and tools like InfoSphere DataStage.

 

What about support? Both DB2 and InfoSphere Warehouse are part of the 7700. For confirmation, see the validated software stack for the 7700.

 

The only odd thing I've found is with DB2 Connect. The license information document shows that DB2 Connect components exist in it. However, it restricts DB2 Connect's usage to only the SQL Warehousing (SQW) Tool. That means you couldn't use this DB2 Connect with DB2's own Export, Load from Cursor, or SQL Replication to pull data from DB2 z/OS or DB2 i5/OS into the 7700. You'd need to purchase a copy of DB2 Connect and possibly install it on a separate system. Sounds odd, but many z and i shops already have DB2 Connect, so I don't see this as serious issue.

 

My last comment here is, if you're not familiar with SQL Replication, try my Fast Start for SQL Replication.

 

Q Replication

 

This is IBM's scalable, high-performance replication technology. The components for Q Replication exist in every DB2 and InfoSphere Warehouse. Do you need to pay for this Q Replication. It depends on the solution you're implementing:

 

 

You can use Q Replication for many replication needs. Some of the most popular are:

 

 

You can use Q Replication to replicate data between an IBM Smart Analytics Systems and any of the following:

 

  • Other Smart Analyitcs Systems
  • DB2 for Linux, UNIX, and Windows
  • InfoSphere Warehouse
  • DB2 for z/OS
  • Oracle

 

However, you must purchase Q Replication on z/OS if you need to replicate to or from the DB2 on that platform. You can also replicate from an IBM Smart Analytics System to many different targets with Q Replication, including the following if you purchase InfoSphere Replication Server for the target system:

 

  • Microsoft SQL Server
  • Sybase ASE
  • Informix (IDS)
  • Teradata

 

What about support? Two-DB2/IW Q Replication is included. For other solutions, as per the announcement letter for the IBM Homogeneous Replication Feature, the first 12 months of subscription and support (S&S) is included in your purchase of this feature.

 

Again, the only quirk is the DB2 Connect thing for DB2 z/OS and DB2 i5/OS that I mentioned under the SQL Replication heading. The impact for Q Replication is on loading tables in the Smart Analytics System with data from z or i. Q Replication can do high-speed loads of target tables using DB2's Load from Cursor. However, you would need to purchase a separate copy of DB2 Connect since the 7700's license information document doesn't allow this usage of the included DB2 Connect.

 

 

--

Views: 191

Tags: Q Replication, SQL Replication, Smart Analytics Systems, data replication

Comment

You need to be a member of ChannelDB2 to add comments!

Join ChannelDB2

Try BLU Acceleration on Cloud

© 2014   Created by channeldb2.

Badges  |  Report an Issue  |  Terms of Service