Implement Change Data Capture Technology in IBM DB2 for i

I would request you add Change Data Capture technology to the IBM i.

Currently IBM i has the ability to journal changes, and there are some basic capabilities for viewing that data. However viewing it via a 5250 screen is very challenging, and often just shows cryptic ascii characters for some data types.

Instead I propose a much more user friendly implementation, modeling off of Microsoft SQL Server's change data capture technology introduced in SQL Server 2012.

How it works in SQL Server is you right click a database, click "Enable change tracking", then set a retention period.

After that is complete you right click a table and say "Activate change tracking".

The moment you hit activate change tracking on a table, some system views get created. The most important being the "cdc.tablename" view.

For instance, if I right click a table called "ItemMaster" and activated change data capture, a corresponding view gets creatd in that database called "cdc.ItemMaster".

I merely need to do a "select * from cdc.ItemMaster where type=1 and changedate between XXX and YYY" to get all inserts between a date range, or type=2 for all update befores, or type=3 for all update afters, or type=4 for all deletes (consult their help manual, may have gotten the type #'s incorrect).

Anyways, the gist of this is you can easily query events that have happened to a table just as easy as you can query a regular table.

Replication scenarios
Data fixing scenarios
Fraud investigation scenarios
Compliance scenarios