PL/I · DB2 SQLCODE

SQLCODE -904: Unsuccessful Execution Caused by an Unavailable Resource

What does SQLCODE -904: Unsuccessful Execution Caused by an Unavailable Resource mean in PL/I?

A resource the PL/I program's SQL statement needed — a table space, buffer pool, DBD, or similar — wasn't available, often because it's stopped, being reorganized, or was never started after a DB2 restart.

SQLCODE -904: Unsuccessful Execution Caused by an Unavailable ResourceDB2 for z/OS · PL/I (embedded SQL)

Condition

A resource the PL/I program's SQL statement needed — a table space, buffer pool, DBD, or similar — wasn't available, often because it's stopped, being reorganized, or was never started after a DB2 restart.

Fix

Check the reason code and resource name against DB2's resource-unavailable reason codes, and have the DBA START the resource, or wait out the reorg or utility, before retrying.

Related db2 sqlcode