When running a DCD DB2 database update job (FEYADB2x), I am getting Return Code=4 and SQLCODE=162, How do I address this error?

Document ID : KB000014376
Last Modified Date : 14/02/2018
Show Technical Document Details
Question:

When running a DCD DB2 database update job (FEYADB2x), I am getting Return Code=4 and SQLCODE=162, How do I address this error?

Answer:

The Return Code=4 and SQLCODE=162 error can occur if the applicable tablespace is in the check pending state.

Follow these steps:

  1. Retrieve the RUN.CFEYJCL(FEYCHECK) job.
  2. Review the entire job and submit it.
    The expected return code is 0.

The check pending state is reset.

If the problem persists, contact CA Support.