| |
- Causa
- AUTHORIZATION FAILURE: error-type ERROR. REASON reason-code
Authorization failed because of the error indicated by error-type
- error-type
-
- Types of authorization failure
- User authorization
- Plan access
- Duplicate exit requested
- Installation error
- Connect
- reason-code
- DB2 reason code associated with authorization failure
- Ação do sistema
- The statement cannot be processed. The connection to DB2 is not established.
- Resposta ao Desenvolvedor
- If error-type is user authorization:, the authorization-ID specified to DB2 through your attachment facility is not valid for DB2.
See your system programmer or your CICS, IMS, or TSO system administrator.
If error-type is plan access, then the authorization ID associated with this connection is not authorized to use the specified plan name or the
specified plan name does not exist. See your system administrator.
If error-type is duplicate exit, then you requested a duplicate exit.
If error-type is installation error, a connection or sign-on exit denied your request.
See your system programmer.
If error-type is Connect, an SQL CONNECT request failed to connect to the local DB2 with USER/USING specified.
See the reason code for a description of the failure.
The application program has been palced in the connectable and unconneted state.
The only SQL statements that can be successfully completed in this state are CONNET, COMMIT, ROLLBACK, and local SET statements.
Any
attempt to execute other SQL statements will result in an error (SQLCODE -900).
Look up the reason code in "Section 4. DB2 Codes" in topic 4.0 for further information.
Any attempts to issue SQL statements following the -922 SQLCODE when error-type is not Connect causes unpredictable results.
SQLSTATE: 42505
© Copyright IBM Corp.
|
| |
