GETSQLPARTONLYPURGEDATAS | IGNORESQLPARTONLYPURGEDATAS

Valid for

Extract, Replicat

Description

Use GETSQLPARTONLYPURGEDATAS or IGNORESQLPARTONLYPURGEDATAS 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 GETSQLPARTONLYPURGEDATAS is entered, for example, it remains in effect until an IGNORESQLPARTONLYPURGEDATAS.

Before using GETSQLPARTONLYPURGEDATAS consider the following restrictions and repercussions.

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

• GETSQLPARTONLYPURGEDATAS is not supported for bi-directional configurations.

• When you use GETSQLPARTONLYPURGEDATAS, 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 table is out of range for the target table of the same number.

• Executing a PURGEDATA on any partition using PartOnly, will cause the specific partition to be purge data, but if Extract is using IGNORESQLPARTONLYPURGEDATAS (default), then a PURGEDATA record will be output for the whole table.

• Executing a PURGEDATA on any partition without PartOnly, will cause the full table to be purge data, but if using GETSQLPARTONLYPURGEDATAS, Extract will output a PARTONLY PURGEDATA record by partition for all partitions.

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

• GETSQLPARTONLYPURGEDATAS is not supported for Enscribe files. GETSQLPARTONLYPURGEDATAS has no effect on GETPURGEDATAS, and neither GETDEFAULTS nor GETFILEOPS have an effect on GETSQLPARTONLYPURGEDATAS.

The following parameters turn off (disable) GETSQLPARTONLYPURGEDATAS:

• IGNOREFILEOPS

• IGNORESQLPURGEDATAS

  Note: If PARTONLY PURGEDATA operations are received by open systems Replicats, there will be no attempt to process the PARTONLY PURGEDATA operations.

Default

IGNORESQLPARTONLYPURGEDATA

Syntax

GETSQLPARTONLYPURGEDATAS | IGNORESQLPARTONLYPURGEDATAS