Capabilities for DB2 for z/OS

From HVR
Jump to: navigation, search

This section describes the capabilities supported by HVR on DB2 for z/OS.

Capture

HVR supports the following capabilities on DB2 for z/OS:

  • Capture changes from location (DB2 for z/OS from version 10.01.00 to version 11.01.05)
  • Log-based capture (capture from DBMS logging system) (DB2 for z/OS from version 11.01.00 to version 11.01.05)
  • Log-based capture of tables without a primary key (DB2 for z/OS from version 11.01.00 to version 11.01.05)
  • Log-based capture of tables with LOB column (DB2 for z/OS from version 11.01.00 to version 11.01.05)
  • Populates column hvr_cap_user for use in ColumnProperties {hvr_cap_user} substitutions (DB2 for z/OS from version 11.01.00 to version 11.01.05)
  • Log-based capture of truncate table statements (DB2 for z/OS from version 11.01.00 to version 11.01.05)
  • Multiple log-based capture jobs can capture from same database (DB2 for z/OS from version 11.01.00 to version 11.01.05)
  • Log-based capture checkpointing (action Capture /CheckpointingFrequency) (DB2 for z/OS from version 11.01.00 to version 11.01.05)


HVR does not support the following capabilities on DB2 for z/OS:

  • Capture from Archive log files only (DB2 for z/OS from version 10.01.00 to version 11.01.05)
  • Log-based capture of DDL statements using action AdaptDDL (DB2 for z/OS from version 10.01.00 to version 11.01.05)
  • Direct access to logs on a file system (DB2 for z/OS from version 10.01.00 to version 11.01.05)
  • Access to logs using SQL interface (DB2 for z/OS from version 10.01.00 to version 11.01.05)
  • Log-based capture from hidden rowid column (ColumnProperties /CaptureFromRowId) (DB2 for z/OS from version 10.01.00 to version 11.01.05)
  • Rewind log-based capture to specific time (hvrinit option -i) (DB2 for z/OS from version 10.01.00 to version 11.01.05)
  • Online refresh using accurate LSN/SCN (DB2 for z/OS from version 10.01.00 to version 11.01.05)
  • Capture from tables with basic compression (DB2 for z/OS from version 10.01.00 to version 11.01.05)
  • hvrlogrelease to preserve journal/archives (DB2 for z/OS from version 10.01.00 to version 11.01.05)
  • Read archives from an alternative directory (Capture /ArchiveLogPath) (DB2 for z/OS from version 10.01.00 to version 11.01.05)
  • Trigger-based capture (action Capture /TriggerBased) (DB2 for z/OS from version 10.01.00 to version 11.01.05)


HVR Hub

HVR does not support Hub database (DB2 for z/OS from version 10.01.00 to version 11.01.05)


Integrate

HVR supports the following capabilities on DB2 for z/OS:

  • Integrate changes into location (DB2 for z/OS from version 10.01.00 to version 11.01.05)
  • Integrate with /BurstCommitFrequency (DB2 for z/OS from version 10.01.00 to version 11.01.05)
  • Continuous integration (Integrate without /Burst) (DB2 for z/OS from version 10.01.00 to version 11.01.05)
  • Action TableProperties with /DuplicateRows for continuous integration (DB2 for z/OS from version 10.01.00 to version 11.01.05)
  • Continuous integrate with /OnErrorSaveFailed (without /Burst) (DB2 for z/OS from version 10.01.00 to version 11.01.05)
  • Action Transform /SoftDelete (DB2 for z/OS from version 10.01.00 to version 11.01.05)
  • Creation and update of HVR state tables (DB2 for z/OS from version 10.01.00 to version 11.01.05)


HVR does not support the following capabilities on DB2 for z/OS:

  • Integrate with /Burst (DB2 for z/OS from version 10.01.00 to version 11.01.05)
  • Disable/enable database triggers during integrate (/NoTriggerFiring) (DB2 for z/OS from version 10.01.00 to version 11.01.05)
  • Integrate with /DbProc (DB2 for z/OS from version 10.01.00 to version 11.01.05)


Bi-directional Replication

HVR supports the following capabilities on DB2 for z/OS:

  • Detection of changes made by HVR in a bidirectional channel to prevent loop-back (DB2 for z/OS from version 10.01.00 to version 11.01.05)
  • Collision Detect with /TimestampColumn (DB2 for z/OS from version 10.01.00 to version 11.01.05)


HVR does not support the following capabilities on DB2 for z/OS:

  • Collision Detect with Log-based Capture (without /TimestampColumn) (DB2 for z/OS from version 10.01.00 to version 11.01.05)


Refresh and Compare

HVR supports the following capabilities on DB2 for z/OS:

  • Refresh or Compare from source location (DB2 for z/OS from version 10.01.00 to version 11.01.05)
  • Refresh into target location (DB2 for z/OS from version 10.01.00 to version 11.01.05)
  • Row-wise refresh into target location (option -g) (DB2 for z/OS from version 10.01.00 to version 11.01.05)


Other Capabilities

HVR supports the following capabilities on DB2 for z/OS:

  • International table and column names where DBMS is not configured with UTF-8 encoding (DB2 for z/OS from version 10.01.00 to version 11.01.05)


HVR does not support the following capabilities on DB2 for z/OS:

  • Use distribution key for parallelizing changes within a table (ColumnProperties /DistributionKey) (DB2 for z/OS from version 10.01.00 to version 11.01.05)