The Clear pending and Clear error prompts on the STRDG command provide flexibility when starting a data group by allowing you to optionally reset error status conditions on data group file entries and discard pending journal entries that are
stored in the journal log space. Clear pending resets the starting point for all data group file entries and object entries. Clear error clears the hold log spaces.
When clearing pending entries, you can optionally specify which system to use for determining database file network relationships when distributing files among database apply sessions. The System for DB file relations (DBRSYS) prompt identifies which system is used to assign data group file entries to apply sessions when the start request specifies to clear pending entries in all apply sessions.
Table 34 shows the processing that occurs based on the selection made for the Clear pending (CLRPND) and Clear error (CLRERR) prompts. The Clear pending and Clear error prompts work independently. For example, when CLRPND(*NO) is selected, no clear pending processing occurs.
Table 34. CLRPND and CLRERR processing
CLRPND CLRERR Processing Description Notes
*NO *NO Data groups start with regular processing:
• Data group file entry status remains unchanged.
• Hold logs remain unchanged.
*NO *CLRPND The value selected for the CLRPND parameter is used for CLRERR. Same processing as
CLRPND(*NO) CLRERR(*NO).
*NO *YES • Data group file entries in *HLDERR, *HLDRGZ,
*HLDRNM, *HLDPRM, and *HLDRLTD status are cleared.
• Tracking entries in *HLDERR status are cleared.
• Hold log space is deleted.
See File entry states See Log spaces
*YES *NO Note: CLRPND(*YES) will not start a data group when there are open commit cycles on files defined to the data group.
• Data group file entries in *HLDRGZ, *HLDRNM, and *HLDPRM status are cleared and reset to active.
• Data group tracking entries in *HLDRNM are cleared and reset to active.
• Data group file entries and tracking entries in
*HLDERR status remain unchanged.
• If there is a requested status at the time of starting, it is cleared.
• Journal, hold, tracking entry hold, and apply history log spaces are deleted.
• The apply session to which data group file entries are assigned may change.
*YES *YES Note: CLRPND(*YES) will not start a data group when there are open commit cycles on files defined to the data group.
• Data group file entries in *HLDERR, *HLDRGZ,
*HLDRNM, *HLDPRM, and *HLDRLTD status are cleared and reset to active.
• Data group file entries in *HLDRTY status remain unchanged.
• Data group object activity entries in any failed or active status are changed to CC (Completed by clear request).
• Tracking entries in *HLDERR and *HLDRNM status are cleared and reset to active.
• Tracking entries are primed if any configuration changes occurred for data group object entries or data group IFS entries.
• If there is a requested status at the time of starting, it is cleared.
• Journal, hold, and apply history log spaces are deleted.
• The apply session to which data group file entries are assigned may change.
*YES *CLRPND Note: CLRPND(*YES) will not start a data group when there are open commit cycles on files defined to the data group.
The value selected for the CLRPND parameter is used for CLRERR. Same processing as
File entry states: Files in specific states will not reset to active when you specify *YES on the Clear Error prompt. If you have set data group file entries to any of these states, the following process exception applies:
Note: The only states that can be set using the Set Data Group File Entry (SETDGFE) command are *HLD,
*RLSWAIT, *ACTIVE, and *HLDIGN. All other states are the result of internal processing.
• *HLD - Journal entries cached before *YES is specified are discarded. If *ALL or *ALLSRC is specified on the Start processes prompt, all subsequent entries from the specified starting point will be cached again.
• *RLSWAIT - Journal entries are discarded as they wait for the synchronization point to arrive in the journal stream. This occurs regardless of the value specified for Clear Error or Clear Pending.
• *HLDIGN - Journal entries are discarded until the file status is changed to something else.
• *HLDSYNC - Journal entries are ignored since an external process is actively synchronizing the file.
When that event completes normally, the file is set to *RLSWAIT.
Table 34. CLRPND and CLRERR processing
CLRPND CLRERR Processing Description Notes
File entry apply session assignment: Clear pending processing attempts to load balance the data group file entries among the defined apply sessions. If the requested apply session in the data group file entry definition is *ANY, or if it is *DGDFT and the requested apply session for the data group definition is *ANY, then the apply session to which the data group file entry is assigned may be changed when processing occurs. For data groups configured to replicate through the user journal, the requested apply session may be ignored to ensure that related files are handled by the same apply session.
The value specified for System for DB file relations (DBRSYS) determines the system used to determine database file relationships while assigning files to apply sessions. This parameter is evaluated only when the start request specifies to clear pending entries for all database apply sessions. The default value, *TGT, uses the target system to determine the file relationships.
Single apply session processing: In most situations, you will perform clear pending processing on all apply sessions belonging to a data group by specifying *ALL or *DBALL on the Start processes (PRC) prompt. MIMIX also supports the ability to perform clear pending processing on a single apply session, which is useful for recovery purposes in certain error situations. The System for DB file relations (DBRSYS) parameter is ignored when the start request specifies a specific apply session.To perform clear pending processing on a single apply session, specify PRC(*DBAPY) and the specific apply session (APYSSN).
Log spaces: Because they have not been applied, journal entries that exist in the journal log space are considered pending. Journal entries that exist in the hold log space, however, are considered in error. The Clear pending and Clear error prompts affect which log spaces are deleted (and recreated) when a data group is started.
Table 34. CLRPND and CLRERR processing
CLRPND CLRERR Processing Description Notes