Unable to recover ILDS when RECOV NEEDED = ON in DBRC.

book

Article ID: 5173

calendar_today

Updated On:

Products

CA Database Analyzer (IMS Tools) CA Mainframe Configuration Manager for IMS for z/OS IMS TOOLS - MISC CA Compress Data Compression (IMS Tools) CA Database Analyzer for IMS for z/OS CA Database Copier for IMS for z/OS CA Database Organizer for IMS for z/OS CA Mainframe Extended Terminal Manager (IMS Tools) CA High Performance Recovery for IMS for z/OS CA Database Organizer (IMS Tools) CA Mainframe Program Restart Manager for IMS for z/OS CA Secondary Index Builder for IMS for z/OS CA Secondary Index for IMS for z/OS

Issue/Introduction

Unable to recover the ILDS using Secondary Index Builder (SIB) when the recovery needed flag for the database is on in DBRC.

FUNCTION=INDEXCREATE,DBDNAME=dbname,BUILDILDS=ONLY

 

The SIB job fails with the following error messages:

ITKC200E DBRC AUTH ERROR, RETURN CODE     8 REASON "C1000206" ON DB dbname .   

ITKC201E AUTH ERROR REASON=DB MARKED AS NEEDING RECOVERY                        

IDI2502E DBRC REFUSED TO GRANT ACCESS TO DATA BASE "dbname " - DBRC RETURN CODE = 008.

SIBH012E DBRC DATA BASE AUTHORIZATION FAILED.                                   

Cause

The recovery needed flag in DBRC is on.

RECOV NEEDED = ON

 

This problem only occurs on release r16 and below.

 

Environment

Release:
Component: SIB

Resolution

To resolve the problem on r16, you can add the AUTH=N control statement to your SIB control cards. This tells SIB to bypass DBRC database authorization. 

 

With r18 and above you will not need to add the AUTH control statement. In this same scenario on r18, SIB now processes the INDEXCREATE for the ILDS, despite the 'RECOV NEEDED =ON' flag for the ILDS. If the index create is successful it will then reset the recovery needed counter.

CHANGE.DBDS DBD(name ) DDN(name) NORECOV 

 

The following PTFs are recommend on r18; PTFs RO75669, RO75719 and RO75941.