Content Manager OnDemand for z/OS command ARSMAINT fails with ARS0020E
What is the meaning of this Content manager Ondemand for z/OS error message when running ARSMAINT?:
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.10.1.2<-
Mostly likely a missing bind or rebind.
When RC=11 is present in the ARS0020E message, the 0000000C-7412FCDB corresponds to the object access method (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.
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.