What is sqlcode -922 & -923?

Answers were Sorted based on User's Feedback



What is sqlcode -922 & -923?..

Answer / rahul raj

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

Is This Answer Correct ?    6 Yes 1 No

What is sqlcode -922 & -923?..

Answer / rahul raj

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

Is This Answer Correct ?    7 Yes 2 No

Post New Answer

More MySQL Errors Interview Questions

I want query to find the students name who have second highest marks in a table

1 Answers  


mount: mount to NFS server failed: System Error: Connection timed out

0 Answers  


what is the instrument that used in Mechanical Energy??

0 Answers  


what will be the program output if it tries to access 11th item in an array of 10 and it is coded with NOSSRANGE

2 Answers   Cognizant,


hi friends , could u please suggest the best institute in hyd or bangalore for Oracle apps and pl/sql

1 Answers  






What is sqlcode -922 & -923?

2 Answers   Cap Gemini,


what is new g/l functionality

0 Answers  


how can i get the question papers of year 2006 and 2007 of 12th commerce gujarat board

0 Answers  


How to select particular number using rownum? Example: i need only the second max number using rownum.

2 Answers   Maveric,


hi. i m Anil patel when reconcile 57f4 chalan(subcontraction with out excise)i m facing error like short by material 220 kg. even i have migo all material.

0 Answers   Capita India Pvt Ltd,


Trying to transfer data from Prod region to Test region.So,exporting data from Prod table(e.g xyz in prod) into a temporary table(e.g abc) and then inserting into Test table(e.g xyz in prod),but not able to insert data from one db2 table to another,the error coming out is 'foreign key vaue is not valid'

1 Answers  


Categories