1. Reference Guide for Oracle GoldenGate for HP NonStop (Guardian)
  2. Oracle GoldenGate Parameters
  3. GETPARTONLYPURGEDATAS | IGNOREPARTONLYPURGEDATAS

2.109 GETPARTONLYPURGEDATAS | IGNOREPARTONLYPURGEDATAS

Valid for

Extract, Replicat

Description

Use GETPARTONLYPURGEDATAS or IGNOREPARTONLYPURGEDATAS to include or exclude PARTONLY PURGEDATA operations. From the point it is entered in the parameter file, the parameter remains in effect until its opposite is encountered. If GETPARTONLYPURGEDATAS is entered, for example, it remains in effect until an IGNOREPARTONLYPURGEDATAS.

GETPARTONLYPURGEDATAS is required to capture PURGEDATA operations on Enhanced Key Sequenced Enscribe files (files that have more than 16 partitions.)

Note:

If a file has more than 16 partitions, PURGEDATA operations can only be captured on a per-partition basis because the primary partition will always be empty.

Before using GETPARTONLYPURGEDATAS carefully consider the following restrictions.

  • GETPARTONLYPURGEDATAS applies only to like-to-like replication and cannot be used in heterogeneous configurations.

  • GETPARTONLYPURGEDATAS is not supported for bi-directional configurations.

  • When you use GETPARTONLYPURGEDATAS, the key range of the partitions on the target must match the key range of those on the source. The PARTONLY PURGEDATA operation will be rejected if the source partition file is out of range for the target file of the same number.

  • GETPARTONLYPURGEDATAS is not supported for non-audited files.

  • GETPARTONLYPURGEDATAS is not supported for SQL tables.

  • If you want an Extract pump to pass on PARTONLY PURGEDATA operations, you must explicitly specify GETPARTONLYPURGEDATAS.

  • PARTONLY PURGEDATA operations will have a side effect in Replicat of never knowing if all partitions have been purge of data, and therefore, no Altfiles can ever be purged automatically. The user must code their own User Exit to track PARTONLY PURGEDATA and decide if and when to purge the Altfiles. The user exit callback GET_FILEOP_INFO is provided to aid in this effort.

GETPARTONLYPURGEDATAS has no effect on GETPURGEDATAS, and neither GETDEFAULTS nor GETFILEOPShave an effect on GETPARTONLYPURGEDATAS.

The following parameters turn off (disable) GETPARTONLYPURGEDATAS:

  • IGNOREFILEOPS

  • IGNOREPURGEDATAS

    Note:

    If PARTONLY PURGEDATA operations are received by older (previous to version 9.5) or open systems Replicats, there will be no attempt to process the PARTONLY PURGEDATA operations.

Default

IGNOREPARTONLYPURGEDATA

Syntax

GETPARTONLYPURGEDATAS | IGNOREPARTONLYPURGEDATAS