DB2 LUW Setting up Shadow Tables

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

Finding System Requirements for IBM Software Products.

IBM has a  Software Product Compatibility Reports facility.


SQL Server on Linux notes from PASS Summit 2016

SQL Server on Linux notes from PASS Summit 2016


SSMS Running remotely

To run SSMS remotely:

runas /netonly /user:domain\username “C:\Program Files (x86)\Microsoft SQL Server\130\Tools\Binn\ManagementStudio\Ssms.exe”


runas /netonly /user:WIN-P9OQ9GF24HV\justdave “C:\Program Files (x86)\Microsoft SQL Server\130\Tools\Binn\ManagementStudio\Ssms.exe”

SQL1227N during replaying db2look -m output



db2look -m -r

The “-r” option is used to generate db2look output without runstats command output. However, current db2look code cannot reset SYSSTAT.COLUMNS and SYSSTAT.INDEXES when -r is applied. As a result, SQL1227N sometimes occur when applying the mimic when COLCARD etc, and CARD for the table is inconsistent. In db2look up to version in V10.5 please use db2look -m without -r option or insert resetting SYSSTAT.COLUMNS and SYSSTAT.INDEXES manually in db2look output with “-m” and “-r”. This limitation will be changed in releases later than V10.5. In most cases it should not cause SQL1227N error, but still the error can occur when the statistics on the source system is inconsistent. Here are examples:
Why COLCARD is sometimes bigger than CARD after RUNSTATS?

Runstats may update unexpected HIGH2KEY and LOW2KEY statistic values which may cause SQL1227N

As documented in above technotes, you can bypass the error by setting following undocumented registry variable even if the statistics are inconsistent:

recycle the instance

This registry variable can be used from 9.7FP9/10.1FP4/10.5.


.NET Runtime Optimization Service

To run .NET Runtime Optimization Service:

Wondering why mscorsvw.exe has high CPU usage? You can speed it up.

c:\Windows\Microsoft.NET\Framework64\v4.0.30319\ngen.exe executeQueuedItems
schTasks /run /Tn “\Microsoft\Windows\.NET Framework\.NET Framework NGEN v4.0.30319 64”

Using vim as a man pager


export MANPAGER=”col -b | vim -c ‘set ft=man ts=8 nomod nolist nonu’ -c ‘nnoremap i <nop>’ -”

export MANPAGER=”col -b | vim -c ‘set ft=man ts=8 nomod nolist nonu noma’ -”

For gnu man:

export MANPAGER=”/bin/sh -c \”col -b | vim -c ‘set ft=man ts=8 nomod nolist nonu noma’ -\””