ChannelDB2

Data Replication for the IBM Smart Analytics System 5600 and 7600

With more companies looking into the IBM Smart Analytics Systems, one obvious question people ask is - what are my replication options? The answer is simple, but not easy to find. I'm going to use this post to provide one for the 5600 and 7600.

Both of these systems are built on a base of IBM's DB2 and InfoSphere Warehouse. 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. It's an easy thing to do. I plan a future post to highlight this.

What about support? Both DB2 and InfoSphere Warehouse are part of the validated software stacks for the IBM Smart Analytics Systems.

The only odd thing I've found is with DB2 Connect. The license information (LI) documents for the 5600 and 7600 show that DB2 Connect components exist in both them. However, these documents restrict its 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 Smart Analytics System. You'd need to purchase a copy of DB2 Connect and possibly install it on a separate system. 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. However, the license information (LI) documents for the 5600 and 7600 say that a license for the IBM Homogeneous Replication Feature must be purchased before these components can be used. In other words, it's not included in the price of the IBM Smart Analytics System.

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? 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 I mentioned under SQL Replication. The impact for Q Replication is on loading tables in the Smart Analytics System. 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 5600 and 7600 license information (LI) documents don't allow this usage of the built-in DB2 Connect.


Conclusion

This post may be simple, but it's longer than I thought it would be :)

--

Views: 196

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