PL/I · DB2 SQLCODE

SQLCODE -905: Resource Limit Exceeded

What does SQLCODE -905: Resource Limit Exceeded mean in PL/I?

The PL/I program's SQL statement, or a stored procedure it called, ran longer than the CPU or service-unit limit set in the resource limit specification table (or a system default), and DB2 cut it off.

SQLCODE -905: Resource Limit ExceededDB2 for z/OS · PL/I (embedded SQL)

Condition

The PL/I program's SQL statement, or a stored procedure it called, ran longer than the CPU or service-unit limit set in the resource limit specification table (or a system default), and DB2 cut it off.

Fix

Tune the offending statement — check for a missing index causing a table scan — or, if the workload genuinely needs it, have the DBA raise the ASUTIME limit in the RLST for that plan, package, or authorization ID.

Related db2 sqlcode