PL/I · DB2 SQLCODE

SQLCODE -902: Pointer to Essential Control Block Is Zero, Rebind Required

What does SQLCODE -902: Pointer to Essential Control Block Is Zero, Rebind Required mean in PL/I?

DB2's internal control block pointer (CT or RDA) for the running plan or package is zero, so no further SQL statements — including ones a recovery routine might try to issue — can be processed for the rest of the unit of work.

SQLCODE -902: Pointer to Essential Control Block Is Zero, Rebind RequiredDB2 for z/OS · PL/I (embedded SQL)

Condition

DB2's internal control block pointer (CT or RDA) for the running plan or package is zero, so no further SQL statements — including ones a recovery routine might try to issue — can be processed for the rest of the unit of work.

Fix

Rebind the plan/package and rerun the job; if it recurs, compare the currently bound DBRM against the program's actual source to rule out a bind/DBRM mismatch.

Related db2 sqlcode