DB2 LUW Setting up Shadow Tables

Posted: November 16, 2016 | Author: | Filed under: DB2 10.5, DB2 LUW, Shadow Tables | Tags: , | Leave a comment

Just heard someone at IDUG EMEA 2016 asking about how to setup DB2 LUW shadow tables.

This will depend upon DB2 Version,you also need a compatible CDC (Infosphere Replication) version,check via Finding System Requirements for IBM Software Products.

The steps are at http://www.smooth1.co.uk/db2/cancun.html#1.1

NOTE: This was written when the feature first came out DB2 LUW 10.5 FP4.

CDC Components to download were:

  • InfoSphere CDC for DB2 for LUW
  • InfoSphere CDC Access Server
  • InfoSphere CDC Management Console
Advertisement

Finding System Requirements for IBM Software Products.

Posted: November 14, 2016 | Author: | Filed under: DB2 LUW, Informix | Tags: , | Leave a comment

IBM has a  Software Product Compatibility Reports facility.

http://www-969.ibm.com/software/reports/compatibility/clarity/softwareReqsForProduct.html

SQL Server on Linux notes from PASS Summit 2016

Posted: November 3, 2016 | Author: | Filed under: Microsoft SQL Server future, Microsoft SQL Server Linux | Tags: | Leave a comment

SQL Server on Linux notes from PASS Summit 2016

http://www.smooth1.co.uk/mssql/pass_summit_2016/sqlserveronlinux/SQLServerLinuxv1.htm