Exit Program Reason Codes (DB2 for i Source)

SQDR Plus does not delete journal receivers itself; this is typically done by the host operating system (when the journals are configured for system-managed deletion), by user actions, or by a third party journal management tool.

Instead, SQDR Plus installs an exit program to prevent the premature removal of journal receivers it needs when working with subscribed tables.  If the system or user attempts to delete a receiver, then the exit program is invoked and either approves or vetoes the deletion. The action is logged and can be viewed in the SQDR Plus staging agent's diagnostic log; see the table below for possible outcomes. Note that some actions are displayed only when the logging level of the agent is increased from the default of WARNING to INFO or FINE.

Definitions:

Candidate: the name of the journal receiver to be deleted

Current: the journal receiver currently being examined by SQDR Plus. Note that this is different than the Attached receiver, which is where the operating system is currently writing new entries.

Reason Code

logLevel

OK to delete?

Reason Text

Source

Remote

Comments

0

FINE

Y

Journal not monitored

Y

Y

Common - but displayed in the Agent Diagnostics only when LogLevel=FINE

1

FINE

Y

SQDR Plus not managing journals

Y

Y

Uncommon configuration

2

INFO

N

Candidate matches Current

Y

Y

Common - Slightly lagging agent on a "quick" iSeries

3

INFO

Y

Candidate is prior to Current

Y

N/A

Common - the typical result for a capture agent that is keeping pace

4

INFO

Y

Broken Chain Detected

Y

N/A

environmental issue

5

WARNING

N

OS API reported error

Y

N/A

environmental issue

6.1

WARNING

N

OS API reported error

 

Y

environmental issue

6.2

WARNING

N

Would Break Chain (Capture not running?)

Y

Y

significantly lagging agent (i.e. more than 1 receiver behind)

7

INFO

Y

[Remote] Receiver is prior to Current Receiver

 

Y

Common for a remote journal - the typical result for a capture agent that is keeping pace

8

INFO

Y

Sequence Number is greater than current

 

Y

Rare - happens when CHGJRN SEQOPT(*RESET) is issued