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

Document ID : KB000005173
Last Modified Date : 14/02/2018
Show Technical Document Details
Issue:

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.

 

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.