Capabilities for Db2 for Linux, Unix and Windows
This section lists the Capabilities of Fivetran HVR when using 'Db2 for Linux, Unix and Windows'. For more information about the pre-requisites, access privileges, and other configuration requirements, see Db2 for Linux, Unix and Windows Requirements.
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 10.5 to version 12.1).
- Log-based capture (capture from DBMS logging system) (Db2 for Linux, Unix and Windows from version 10.5 to version 12.1).
- Log-based capture of DDL statements using action AdaptDDL (Db2 for Linux, Unix and Windows from version 10.5 to version 12.1).
- Log-based capture of tables without a primary key (Db2 for Linux, Unix and Windows from version 10.5 to version 12.1).
- Access to logs using SQL interface (Db2 for Linux, Unix and Windows from version 10.5 to version 12.1).
- Log-based capture of tables with LOB column (Db2 for Linux, Unix and Windows from version 10.5 to version 12.1).
- Rewind log-based capture to specific time (hvractivate option -i) (Db2 for Linux, Unix and Windows from version 10.5 to version 12.1).
- Online refresh using accurate LSN/SCN (Db2 for Linux, Unix and Windows from version 10.5 to version 12.1).
- Populates column hvr_cap_user for use in ColumnProperties {hvr_cap_user} substitutions (Db2 for Linux, Unix and Windows from version 10.5 to version 12.1).
- Log-based capture of truncate table statements (Db2 for Linux, Unix and Windows from version 10.5 to version 12.1).
- Multiple log-based capture jobs can capture from same database (Db2 for Linux, Unix and Windows from version 10.5 to version 12.1).
- Capture from tables with value compression (Db2 for Linux, Unix and Windows from version 10.5 to version 12.1).
- Capture from tables with row compression (Db2 for Linux, Unix and Windows from version 10.5 to version 12.1).
- Log-based capture checkpointing using location property Capture_Checkpoint_Frequency (Db2 for Linux, Unix and Windows from version 10.5 to version 12.1).
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 (AdaptDDL) without refresh.
- Direct access to logs on a file system.
- Log-based capture from hidden rowid/RRN column (ColumnProperties with parameter CaptureFromRowId).
- Rewind log-based capture to the beginning of currently active oldest transaction.
- Read archives from an alternative directory (location property Archive_Log_Path on the capture location).
- Trigger-based capture (using the location property Capture_Method=DB_TRIGGER at the capture location). This method has been deprecated since 6.2.0/0..
Repository Database
HVR supports Repository 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 10.5 to version 12.1).
- Burst integration (Integrate with parameter Method=BURST) (Db2 for Linux, Unix and Windows from version 10.5 to version 12.1).
- Integrate with parameter BurstCommitFrequency (Db2 for Linux, Unix and Windows from version 10.5 to version 12.1).
- Continuous integration (Integrate with parameter Method=CONTINUOUS) (Db2 for Linux, Unix and Windows from version 10.5 to version 12.1).
- Tables without a key and without TableProperties with NoDuplicateRows for continuous integration (Db2 for Linux, Unix and Windows from version 10.5 to version 12.1).
- Continuous integrate with parameter OnErrorSaveFailed (Db2 for Linux, Unix and Windows from version 10.5 to version 12.1).
- ColumnProperties with parameter SoftDelete (Db2 for Linux, Unix and Windows from version 10.5 to version 12.1).
- Creation and update of HVR state tables (Db2 for Linux, Unix and Windows from version 10.5 to version 12.1).
HVR does not support the following capabilities on Db2 for Linux, Unix and Windows:
- Disable/enable database triggers during integrate (with parameter NoTriggerFiring).
- Integrate with parameter DbProc.
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 10.5 to version 12.1, state table needs to be created before replication starts).
- CollisionDetect with parameter TimestampColumn (Db2 for Linux, Unix and Windows from version 10.5 to version 12.1).
HVR does not support the following capabilities on Db2 for Linux, Unix and Windows:
- CollisionDetect with Log-based Capture (without parameter 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 10.5 to version 12.1).
- hvrrefresh into target location (Db2 for Linux, Unix and Windows from version 10.5 to version 12.1).
- Row-wise hvrrefresh into target location (option -g) (Db2 for Linux, Unix and Windows from version 10.5 to version 12.1).
Other Capabilities
HVR supports the following capabilities on Db2 for Linux, Unix and Windows:
- Call database procedure dbproc during replication jobs (AgentPlugin with parameter DbProc) (Db2 for Linux, Unix and Windows from version 10.5 to version 12.1).
- DbObjectGeneration with parameter IncludeSQLFile (Db2 for Linux, Unix and Windows from version 10.5 to version 12.1).
- International table and column names where DBMS is not configured with UTF-8 encoding (Db2 for Linux, Unix and Windows from version 10.5 to version 12.1).
- Treat DBMS table names and columns as case sensitive if configured (location property Case_Sensitive_Names) (Db2 for Linux, Unix and Windows from version 10.5 to version 12.1).
- Treat DBMS schema names as case sensitive if configured (location property Case_Sensitive_Names) (Db2 for Linux, Unix and Windows from version 10.5 to version 12.1).
- Distinguish and support capture from 'materialized views' (Db2 for Linux, Unix and Windows from version 10.5 to version 12.1).
HVR does not support the following capabilities on Db2 for Linux, Unix and Windows:
- Use distribution key for parallelizing changes within a table (ColumnProperties with parameter DistributionKey).
- Log-based capture from persisted computed columns.
- Distinguish and support capture from 'column store tables'.
- Log-based capture from non-persisted (virtual) computed columns.