BMC50285E SQL -911 RETRIES UNSUCCESSFUL WHEN OBJECT IS IN RO STATUS |
LOADPLUS FOR D2 V13.1 returns error message BMC50285E SQL -911 RETRIES UNSUCCESSFUL when executing LOAD SHRLEVEL NONE when object being loaded is in RO status while utility is unable to get a drain. This problem only occurs with LOADPLUS FOR D2 V13.1 and does not occur with LOADPLUS FOR D2 V11.2. LOADPLUS FOR DB2 V13.1 PTF BQU5385 resolves the BMC50285E SQL -911 RETRIES UNSUCCESSFUL problem. A new parameter DRNBYPASS was introduced in LOAD PLUS FOR DB2 V13.1 which will enable customers to bypass drain for SHRLEVEL NONE loads when object is in RO. The default value is DRNBYPASS=NO, to bypass drain please modify AMU$OPTS options module with DRNBYPASS=YES and reassemble it. As this is a new parameter, development is in the process of adding the DRNBYPASS parameter to LOADPLUS V13.1 documentation. It is recommended that you create a new options module say AMU$OPTD with DRNBYPASS=YES, reassemble the module and reference the AMU$OPTD module in LOAD JCL for LOAD jobs using SHRLEVEL NONE to avoid -911 drain error. You can override the options module in your LOAD JCL. example: //EXAMPLE EXEC PGM=AMUUMAIN, // PARM='DB2SYS,AMUEX05,NEW/RESTART,,MSGLEVEL(1),AMU$OPTD' If you are unable to apply PTF BQU5385 immediately, as a workaround you can run the LOAD with SHRLEVEL REFERENCE or CHANGE to avoid error message BMC50285E SQL -911 RETRIES UNSUCCESSFUL WHEN OBJECT IS IN RO STATUS. |