A fix is available
APAR status
Closed as program error.
Error description
RECOVER BACKOUT beyond the 100 checkpoints would hint this 00D1032A issue.
Local fix
n/a
Problem summary
**************************************************************** * USERS AFFECTED: All DB2 10 for z/OS users of the RECOVER * * utility with the BACKOUT YES option -or- * * users of FlashCopy image copies (FCIC). * **************************************************************** * PROBLEM DESCRIPTION: This APAR addresses two issues: * * 1. ABEND04E RC00D1032A in DSNJR003 * * and ABEND04E RC00E40106 in DSNUCALC * * during RECOVER utility with the * * BACKOUT YES option. * * 2. Extraneous ICF Catalog Search * * Interface (CSI) invocation during * * the creation of FCICs by COPY, * * REORG, LOAD, or REBUILD INDEX * * utilities. * **************************************************************** * RECOMMENDATION: * **************************************************************** The two issues addressed by this APAR are: 1. ABEND04E RC00D1032A in DSNJR003 and ABEND04E RC00E40106 in DSNUCALC during RECOVER utility with the BACKOUT YES option. .. MsgDSNJ113E RBA '000000000000' NOT IN ANY ACTIVE OR ARCHIVE LOG DATA SET is issued to the console. .. MsgDSNU1550I LOGCSR IS STARTED FOR MEMBER PRIOR CHECKPOINT RBA = X'000000000000' is issued to the job output. .. These abends occur when the recovery point identified by TOLOGPOINT or TORBA is not contained within the most recent DB2 system checkpoints that are recorded in the BSDS for each member. In this case, RECOVER BACKOUT YES cannot proceed, because the checkpoint RBA that is prior to the recovery point for each member is required for backout processing. .. Additional keywords: DSNJ113E DSNU1550I .. 2. During the creation of FCICs by the COPY, REORG, LOAD, or REBUILD INDEX utilities, the ICF Catalog Search Interface (CSI) is invoked to check if the FCIC data set is a duplicate. This check is not necessary because the information in catalog table SYSIBM.SYSCOPY is used to check and prevent duplicate image copy data sets.
Problem conclusion
1. A new error message, MsgDSNU1545I, is issued when the recovery point for RECOVER BACKOUT YES is not contained within the most recent DB2 system checkpoints in the BSDS for each member. .. Documentation change to the DB2 Messages manual: DSNU1545I csect-name RECOVER WITH BACKOUT YES CANNOT PROCEED. THE RECOVERY POINT IS OLDER THAN THE EARLIEST CHECKPOINT IN THE BSDS. Explanation: The recovery point that is identitied by TOLOGPOINT or TORBA is not contained within the most recent DB2 system checkpoints that are recorded in the BSDS for each member. RECOVER with the BACKOUT YES option cannot proceed, because the checkpoint RBA that is before the recovery point for each member is required for backout processing. csect-name: The name of the control section that issued the message. System action: The RECOVER utility ends with return code 8 and does not process any of the objects. The objects are left in the state that they were in before the RECOVER operation. System programmer response: Remove the BACKOUT YES option and resubmit the RECOVER job. This revised job recovers the objects to the same point in time. However, the data is recovered by using a recovery base and applying the logs rather than using backout processing. Recommendation: Use the output from the REPORT utility with the RECOVERY option for all of the objects to ensure that a valid recovery base exists before you run RECOVER. Severity: 8 (error) .. Documentation change to the Utility Guide and Reference manual, Chapter 23 RECOVER utility. A new paragraph is added under the BACKOUT YES option: If you specify BACKOUT YES, the recovery point must be within the most recent DB2 system checkpoints that are recorded in the BSDS for each member. Otherwise, the recovery cannot proceed and returns an error. .. 2. The CSI invocation issued during the check for duplicate FCICs has been removed in the COPY, REORG, LOAD, and REBUILD INDEX utilities.
Temporary fix
Comments
APAR Information
APAR number
PM73758
Reported component name
DB2 OS/390 & Z/
Reported component ID
5740XYR00
Reported release
A10
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2012-09-26
Closed date
2013-04-04
Last modified date
2013-05-03
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UK93153
Modules/Macros
DSNFMDIR DSNFUDRE DSNUBCKD DSNUCALA DSNUGFCB DSNUMSGE
GC19297907 | SC19298407 |
Fix information
Fixed component name
DB2 OS/390 & Z/
Fixed component ID
5740XYR00
Applicable component levels
RA10 PSY UK93153
UP13/04/19 P F304
Fix is available
Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSEPEK","label":"Db2 for z\/OS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"10.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}},{"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SG19M","label":"APARs - z\/OS environment"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"10.1","Edition":"","Line of Business":{"code":"","label":""}}]
Document Information
Modified date:
03 May 2013