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

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

book

Article ID: 14376

calendar_today

Updated On:

Products

Data Content Discovery

Issue/Introduction



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

Environment

Release:
Component: DCD

Resolution

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.