Resolving Db2 SQLCODE -805 error for DSNACLI plan

If you receive a SQLCODE -805 error, operational jobs fail.

Symptoms

HCL Z Asset Optimizer operational jobs are failing.

Causes

The DSNACLI plan is not bound with the latest Db2® maintenance package, or the plan references a missing package.

Diagnosing the problem

Check the log files for error messages in the Z Asset Optimizer operational jobs. The following log entry provides an example of the failure of the DSNCLIQR package:

Native Error Code-805                                                      
{Db2 FOR OS/390}{ODBC DRIVER}{DSN10015}                                      
 DSNT408I SQLCODE = -805,                                                    
ERROR:  DBRM OR PACKAGE NAME DBA2..DSNCLIQR.18F920E31-                       
          3F8F1D9                                                            
NOT FOUND IN PLAN DSNACLI. REASON 03

Resolving the problem

Rerun db2.SDSNSAMP(DSNTIJCL) for all packages that the DSNACLI plan requires to be bound at the same time. The list of packages is slightly different for each release of Db2® for z/OS.

Ensure that the DSNAOCLI package has the following parameters: 
 BIND PACKAGE (DSNAOCLI) MEMBER(DSNCLIMS) -
    CURRENTDATA(YES) ENCODING(EBCDIC)
    SQLERROR(CONTINUE)