MySQL Errors Interview Question:

Explain What is sqlcode -922 & -923?

Submitted by: Administrator

Reason why SQLcode -922 generated:

Authorization failed because of the error indicated by error-type

It can be any of the following..

* User authorization.
* Plan access
* connect
* Installation error
* Duplicate exit requested.

Reason code: DB2® reason code associated with authorization failure


Reason why SQLcode -923 generated:

The connection to DB2® failed for the reason indicated by condition, which can be any of the following:
* DB2 not up
* DB2 not operational
* DB2 shutdown in progress
* DB2 restricted access mode
* Allocation error
* DB2 - CICS® attachment not up
* DB2 - CICS ENTRY disabled
* The object is dependent on facilities of a release of DB2 that is newer than the release that you are currently running (fall back).
* DB2 restarted in light mode
Submitted by: Administrator