ARC1027 The bounding condition for PPI table %s.%s is not considered to be well-defined . Therefore, the ALL PARTITIONS option will not be allowed when doing a restore/copy. - Teradata Tools and Utilities

Archive/Recovery (ARC Prefix) Messages

prodname
Teradata Tools and Utilities
vrm_release
15.10
category
Programming Reference
featnum
B035-1096-151K

ARC1027 The bounding condition for PPI table %s.%s is not considered to be well-defined . Therefore, the ALL PARTITIONS option will not be allowed when doing a restore/copy.

Explanation:

The database has determined that the bounding condition for the archived PPI table is not well-defined . The implication of this determination is that the ALL PARTITIONS option will not be allowed when doing a restore/copy. This is because the bounding condition is not specific enough to determine which partitions must be deleted during the restore/copy operation.

For Whom:

End User.

Notes:

The bounding condition is generated by the database from the PARTITIONS WHERE option when the PPI backup of selected partitions is generated. It defines the logical scope of rows stored on the archive file. However, there are cases such as when the UNKNOWN partition is backed up where the restore semantics may be imprecise. A restore/copy that invokes the ALL PARTITIONS option uses the bounding condition stored on the archive file to define the logical scope of what partitions are deleted and restored so we want to ensure precise semantics. This particular warning message is generated at backup time to let you know that you will NOT be able to restore the backup using the ALL PARTITIONS option. You can still restore selected partitions if you explicitly define the PARTITIONS WHERE option for the restore/copy statement.

Remedy:

None.