The Analyze DPR Journals (ANZDPRJRN) command helps you determine which journal receivers are no longer needed by the DataPropagator Capture component, and optionally deletes the journal receivers that are not needed.

Journal receivers are analyzed for the following types of source tables:

• source tables that have been registered under DataPropagator, and
• source tables that have started differential refresh (that is, a base file for which a row exists in its change data table).

The term base file includes SQL tables, SQL views, local and remote physical files, and logical files built on physical file members of multi-member physical files.

You can run this command whether or not the Capture process is running; however, it is recommended that you run it when the Capture process is not running.

For each receiver that is eligible for deletion, the command issues informational message ASN602E (if you do not choose automatic deletion), or informational message ASN602D (if you do choose automatic deletion).

The command creates a file named QZSNSPLF in library QTEMP with four members.

Note: The ANZDPRJRN command decides whether or not a journal receiver can be deleted only on the basis of its usefulness to the Capture component. Some of your journal receivers might be used for other purposes outside of DataPropagator. Unless you have complete knowledge about the journals that the registered files use, use caution when you specify that you want to have the eligible receivers automatically deleted for you.

• Note: Do not precede an entry with an asterisk unless that entry is shown on the display itself or in the help information with an asterisk.

Error Messages for ANZDPRJRN

*ESCAPE Messages

ASN2023

Error occurred on file in .

ASN6021

Attempt to get member information for base table in library failed with message .

ASN6022

Failed to read the journal list from the PCB.

ASN6024

Could not read any registration records.

ASN6025

Could not open table in library .

ASN6026

Attempt to get file information for base table in library failed with message .

ASN6027

Number of journals used for capturing data for propagation exceeds the limit of .

ASN6028

Could not delete journal receiver in library for journal in library .

ASN6029

Could not open member of file QZSNSPLF in library QTEMP.

ASN602A

Number of receivers for journal in library exceeds the limit of .

ASN602B

Could not delete journal receiver in library because of cancel reply to message CPA7025.

ASN602C

Could not establish starting sequence number or ending sequence number of a journal receiver.

ASN602D

Journal receiver in library for journal in library has been deleted.

ASN602E

Journal receiver in library for journal in library is eligible for deletion.

ASN602F

No journal receivers eligible for deletion were found for journal in library .

ASN604F

WRKJRNA command failed with escape message when working with journal in library .

Parameters

Keyword	Description	Choices	Notes
DLTJRNRCV	Delete journal receiver	*YES, *NO	Optional

Top

Delete journal receiver (DLTJRNRCV)

Specifies whether or not you want to have the command delete those receivers that are no longer needed by the Capture component. Messages are issued for each receiver that is eligible for deletion, and the information is displayed in the job log as well.

*NO

Eligible receivers are not automatically deleted.

You might want to run the command using this option first to verify which journal receivers will be deleted.

*YES

Eligible receivers are automatically deleted.

Note: Unless you have complete knowledge about the journals that the registered files use, use caution when you specify that you want to have the eligible receivers automatically deleted for you.

Examples

None

Error messages

*ESCAPE Messages

ASN2023

Error occurred on file in .

ASN6021

Attempt to get member information for base table in library failed with message .

ASN6022

Failed to read the journal list from the PCB.

ASN6024

Could not read any registration records.

ASN6025

Could not open table in library .

ASN6026

Attempt to get file information for base table in library failed with message .

ASN6027

Number of journals used for capturing data for propagation exceeds the limit of .

ASN6028

Could not delete journal receiver in library for journal in library .

ASN6029

Could not open member of file QZSNSPLF in library QTEMP.

ASN602A

Number of receivers for journal in library exceeds the limit of .

ASN602B

Could not delete journal receiver in library because of cancel reply to message CPA7025.

ASN602C

Could not establish starting sequence number or ending sequence number of a journal receiver.

ASN602D

Journal receiver in library for journal in library has been deleted.

ASN602E

Journal receiver in library for journal in library is eligible for deletion.

ASN602F

No journal receivers eligible for deletion were found for journal in library .

ASN604F

WRKJRNA command failed with escape message when working with journal in library .