MySQL Errors Question:
Download Job Interview Questions and Answers PDF
Explain What is sqlcode -922 & -923?
Answer:
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
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
Download MySQL Errors Interview Questions And Answers
PDF