This documentation is for an older version of HVR.
Capabilities for DB2 for Linux, UNIX and Windows
This section lists the Capabilities of HVR when using 'DB2 for Linux, UNIX and Windows'. For more information about the pre-requisites, access privileges, and other configuration requirements, see Requirements for DB2 for Linux, UNIX and Windows.
Capture
HVR supports the following capabilities on DB2 for Linux, UNIX and Windows:
- Capture changes from location (DB2 for Linux, UNIX and Windows from version 9.7 to version 11.5).
- Log-based capture (capture from DBMS logging system) (DB2 for Linux, UNIX and Windows from version 9.7 to version 11.5).
- Log-based capture of tables without a primary key (DB2 for Linux, UNIX and Windows from version 9.7 to version 11.5).
- Access to logs using SQL interface (DB2 for Linux, UNIX and Windows from version 9.7 to version 11.5).
- Log-based capture of tables with LOB column (DB2 for Linux, UNIX and Windows from version 9.7 to version 11.5, since HVR 5.3.1/4).
- Online refresh using accurate LSN/SCN (DB2 for Linux, UNIX and Windows from version 9.7 to version 11.5).
- Populates column hvr_cap_user for use in ColumnProperties {hvr_cap_user} substitutions (DB2 for Linux, UNIX and Windows from version 9.7 to version 11.5).
- Log-based capture of truncate table statements (DB2 for Linux, UNIX and Windows from version 9.7 to version 11.5).
- Multiple log-based capture jobs can capture from same database (DB2 for Linux, UNIX and Windows from version 9.7 to version 11.5).
- Capture from tables with value compression (DB2 for Linux, UNIX and Windows from version 9.7 to version 11.5).
- Capture from tables with row compression (DB2 for Linux, UNIX and Windows from version 9.7 to version 11.5).
- Log-based capture checkpointing (action Capture /CheckpointingFrequency) (DB2 for Linux, UNIX and Windows from version 9.7 to version 11.5).
- Trigger-based capture (action Capture /TriggerBased) (DB2 for Linux, UNIX and Windows from version 9.7 to version 11.5).
HVR does not support the following capabilities on DB2 for Linux, UNIX and Windows:
- Capture from Archive log files only.
- Log-based capture of DDL statements using action AdaptDDL.
- Direct access to logs on a file system.
- Log-based capture from hidden rowid/RRN column (ColumnProperties /CaptureFromRowId).
- Rewind log-based capture to specific time (Hvrinit option -i).
- Hvrlogrelease to preserve journal/archives.
- Read archives from an alternative directory (Capture /ArchiveLogPath).
Hub Database
HVR supports Hub database on DB2 for Linux, UNIX and Windows.
Integrate
HVR supports the following capabilities on DB2 for Linux, UNIX and Windows:
- Integrate changes into location (DB2 for Linux, UNIX and Windows from version 9.7 to version 11.5).
- Integrate with /Burst (DB2 for Linux, UNIX and Windows from version 9.7 to version 11.5).
- Integrate with /BurstCommitFrequency (DB2 for Linux, UNIX and Windows from version 9.7 to version 11.5).
- Continuous integration (Integrate without /Burst) (DB2 for Linux, UNIX and Windows from version 9.7 to version 11.5).
- Action TableProperties with /DuplicateRows for continuous integration (DB2 for Linux, UNIX and Windows from version 9.7 to version 11.5).
- Continuous Integrate with /OnErrorSaveFailed (without /Burst) (DB2 for Linux, UNIX and Windows from version 9.7 to version 11.5).
- Action Transform /SoftDelete (DB2 for Linux, UNIX and Windows from version 9.7 to version 11.5).
- Creation and update of HVR state tables (DB2 for Linux, UNIX and Windows from version 8.1.5 to version 11.5).
HVR does not support the following capabilities on DB2 for Linux, UNIX and Windows:
Bi-directional Replication
HVR supports the following capabilities on DB2 for Linux, UNIX and Windows:
- Detection of changes made by HVR in a bidirectional channel to prevent loop-back (DB2 for Linux, UNIX and Windows from version 9.7 to version 11.5, state table needs to be created before replication starts).
- CollisionDetect with /TimestampColumn (DB2 for Linux, UNIX and Windows from version 9.7 to version 11.5).
HVR does not support the following capabilities on DB2 for Linux, UNIX and Windows:
- CollisionDetect with Log-based Capture (without /TimestampColumn).
Refresh and Compare
HVR supports the following capabilities on DB2 for Linux, UNIX and Windows:
- Hvrrefresh or Hvrcompare from source location (DB2 for Linux, UNIX and Windows from version 8.1.5 to version 11.5).
- Hvrrefresh into target location (DB2 for Linux, UNIX and Windows from version 8.1.5 to version 11.5).
- Row-wise Hvrrefresh into target location (option -g) (DB2 for Linux, UNIX and Windows from version 8.1.5 to version 11.5).
Other Capabilities
HVR supports the following capabilities on DB2 for Linux, UNIX and Windows:
- Call database procedure dbproc during replication jobs (action AgentPlugin /DbProc) (DB2 for Linux, UNIX and Windows from version 9.7 to version 11.5).
- DbObjectGeneration with /IncludeSQLFile (DB2 for Linux, UNIX and Windows from version 9.7 to version 11.5).
- International table and column names where DBMS is not configured with UTF-8 encoding (DB2 for Linux, UNIX and Windows from version 8.1.5 to version 11.5).
- Treat DBMS table names and columns as case sensitive if configured (action LocationProperties /CaseSensitiveNames defined) (DB2 for Linux, UNIX and Windows from version 8.1.5 to version 11.5, since HVR 5.6.5/1).
- Distinguish and support capture from 'materialized views' (DB2 for Linux, UNIX and Windows from version 9.7 to version 11.5).
HVR does not support the following capabilities on DB2 for Linux, UNIX and Windows:
- Use distribution key for parallelizing changes within a table (ColumnProperties /DistributionKey).
- Distinguish and support capture from 'column store tables'.