Capabilities for DB2 for i

From HVR
Jump to: navigation, search

This section describes the capabilities supported by HVR on DB2 for i. For more information about the requirements, access privileges, and other features of HVR when using Aurora MySQL for replication, see Requirements for DB2 for i.

Capture

HVR supports the following capabilities on DB2 for i:

  • Capture changes from location (DB2 for i version 7.1 and above)
  • Log-based capture (capture from DBMS logging system) (DB2 for i version 7.1 and above)
  • Log-based capture of tables without a primary key (DB2 for i version 7.1 and above)
  • Access to logs using SQL interface (DB2 for i version 7.1 and above)
  • Log-based capture of tables with LOB column (DB2 for i version 7.1 and above)
  • Rewind log-based capture to specific time (hvrinit option -i) (DB2 for i version 7.1 and above)
  • Online refresh using accurate LSN/SCN (DB2 for i version 7.1 and above, since HVR 5.3.1/12)
  • Populates column hvr_cap_user for use in ColumnProperties {hvr_cap_user} substitutions (DB2 for i version 7.1 and above)
  • Log-based capture of truncate table statements (DB2 for i version 7.1 and above, support depends on system setting)
  • Multiple log-based capture jobs can capture from same database (DB2 for i version 7.1 and above)
  • Log-based capture checkpointing (action Capture /CheckpointingFrequency) (DB2 for i version 7.1 and above)


HVR does not support the following capabilities on DB2 for i:

  • Direct access to logs on a file system
  • Log-based capture from hidden rowid column (ColumnProperties /CaptureFromRowId)
  • Rewind log-based capture to the beginning of currently active oldest transaction
  • Capture from tables with basic compression
  • hvrlogrelease to preserve journal/archives
  • Read archives from an alternative directory (Capture /ArchiveLogPath)
  • Trigger-based capture (action Capture /TriggerBased)


HVR Hub

HVR supports Hub database (DB2 for i version 7.1 and above)


Integrate

HVR supports the following capabilities on DB2 for i:

  • Integrate changes into location (DB2 for i version 7.1 and above)
  • Integrate with /Burst (DB2 for i version 7.1 and above)
  • Integrate with /BurstCommitFrequency (DB2 for i version 7.1 and above)
  • Continuous integration (Integrate without /Burst) (DB2 for i version 7.1 and above)
  • Action TableProperties with /DuplicateRows for continuous integration (DB2 for i version 7.1 and above)
  • Continuous integrate with /OnErrorSaveFailed (without /Burst) (DB2 for i version 7.1 and above)
  • Action Transform /SoftDelete (DB2 for i version 7.1 and above)
  • Creation and update of HVR state tables


HVR does not support the following capabilities on DB2 for i:

  • Disable/enable database triggers during integrate (/NoTriggerFiring)
  • Integrate with /DbProc


Bi-directional Replication

HVR supports the following capabilities on DB2 for i:

  • Detection of changes made by HVR in a bidirectional channel to prevent loop-back (DB2 for i version 7.1 and above)
  • Collision Detect with /TimestampColumn (DB2 for i version 7.1 and above)


HVR does not support the following capabilities on DB2 for i:


Refresh and Compare

HVR supports the following capabilities on DB2 for i:


Other Capabilities

HVR supports the following capabilities on DB2 for i:

  • International table and column names where DBMS is not configured with UTF-8 encoding


HVR does not support the following capabilities on DB2 for i:

  • Use distribution key for parallelizing changes within a table (ColumnProperties /DistributionKey)