PL/I · DB2 SQLCODE

SQLCODE -922: Authorization Failure

What does SQLCODE -922: Authorization Failure mean in PL/I?

The connection or plan-access attempt from the PL/I program's attachment (TSO, CICS, batch, and so on) failed an authorization check — the authorization ID isn't valid for DB2, isn't authorized to the plan, or a connection/sign-on exit rejected it.

SQLCODE -922: Authorization FailureDB2 for z/OS · PL/I (embedded SQL)

Condition

The connection or plan-access attempt from the PL/I program's attachment (TSO, CICS, batch, and so on) failed an authorization check — the authorization ID isn't valid for DB2, isn't authorized to the plan, or a connection/sign-on exit rejected it.

Fix

Check the error-type text (USER AUTHORIZATION, PLAN ACCESS, CONNECT, and so on) to see which layer rejected the connection, and have the DBA grant the missing plan or connect authority to the ID the job or transaction actually runs under.

Related db2 sqlcode