Troubleshooting scenario 6: ARSMAINT fails with ARS0020E

Symptom

ARSMAINT receives this error message:

ARS0020E ARSMAINT SM ERROR: ARSMVSDW: 0000000B(0000000C-7404FCDB) 
PROD.ONDEMAND.DATA(BAA.R11), RC=11, REASON=0, FILE =ARSSMSMS.C, LINE=304  
SRVR->SERVER.FQDN.COM 10.5.0.0<-

Possible causes

When RC=11 is present in the ARS0020E message, the 0000000C-7412FCDB corresponds to the OAM return code-reason code. In this case, the OAM return code is 12 (hexadecimal C). Byte 0 of the OAM reason code is hexadecimal 74, which indicates a Db2® error with SQLCODE of bytes 2 and 3 of the OAM reason code (hexadecimal FCDB, which is decimal -805). SQLCODE = -805 indicates DBRM or PACKAGE NAME ... NOT FOUND IN PLAN. As an additional diagnostic aid, issuing the following TSO OSREQ command using the collection and object name from the ARS0020E message should yield the same OAM return code/reason code:

OSREQ QUERY PROD.ONDEMAND.DATA BAA.R11 OSREQ QUERY unsuccessful. 
Return code = 0000000C, reason code =  7412FCDB. 
OSREQ QUERY response time is 53 milliseconds.

Action

It is likely that a bind is needed for the CBRIDBS plan. If you recently applied OAM maintenance, ensure binds indicated by hold data have been performed.