Db2 Sql Error Code 923
Contents |
MySQL Errors Suggest New Category What is sqlcode -922 & -923? Question Posted / guest 2 Answers 5311 Views Cap Gemini, I also Faced E-Mail Answers Answers were Sorted based on db2 sql error code 811 User's Feedback Answer / rahul raj Reason why SQLcode -922 generated: Authorization failed
Db2 Sql Error Code 204
because of the error indicated by error-type It can be any of the following.. * User authorization. * Plan access * connect * db2 sql error code 206 Installation error * Duplicate exit requested. Reason code: DB2® reason code associated with authorization failure Is This Answer Correct ? 6 Yes 1 No Answer / rahul raj Reason why SQLcode -922 generated: Authorization failed because of http://www.ibm.com/support/knowledgecenter/SSEPEK_10.0.0/codes/src/tpc/n923.html 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 http://www.allinterview.com/showanswers/119724/what-is-sqlcode-922-923.html * 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 Categories Oracle Errors (16400)SQLServer Errors (34)MySQL Errors (10) More MySQL Errors Interview Questions How to select particular number using rownum? Example: i need only the second max number using rownum. 2 Answers Maveric, what is new g/l functionality 0 Answers mount: mount to NFS server failed: System Error: Connection timed out 0 Answers 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, what is the instrument that used in Mechanical Energy?? 0 Answers What is sqlcode -922 & -923? 2 Answers Cap Gemini, how can i get the question papers of year 2006 and 2007 of 12th commerce gujarat board 0 Answers hi friends , could u please suggest the best institute in hyd or bangalore for Oracle apps and pl/sql 1 Answers Trying to transfer data from Prod region to Test region.So,exporting data from Prod ta
View next topic Author Message aceBeginnerJoined: 24 Feb 2004Posts: 58Topics: 23 Posted: Fri Jan 14, 2005 1:43 pm Post subject: DB2 Program http://www.mvsforums.com/helpboards/viewtopic.php?t=3517&sid=92b1873b20ed29144db28eda1f819a65 abending with -923 Hi I was doing some testing for a COBOL-DB2 https://sites.google.com/site/mainframeprogrames/sql-error-coeds program. The program was running without any problem for some time but suddenly I started getting the following error message. Quote: ---------- SQLCA FOLLOWS --------------- DSNT408I SQLCODE = -923, ERROR: CONNECTION NOT ESTABLISHED: DB2 NOT UP, REASON , TYPE , NAME DSNT411I SQLCAID = LCA SQLCA IDENTIFIER DSNT418I db2 sql SQLSTATE = 57015 SQLSTATE RETURN CODE DSNT415I SQLERRP = DSNAET03 SQL PROCEDURE DETECTING ERROR ---------- END OF SQLCA --------------- The compilation and bind are successful. Also there is no problem with the connection. All I did was added some DISPLAY statements for testing. Then compiled and bound. Is there any other reason I'm getting a -923 error?_________________Thank You -Ace Back to db2 sql error top aceBeginnerJoined: 24 Feb 2004Posts: 58Topics: 23 Posted: Fri Jan 14, 2005 2:31 pm Post subject: Hi Ravi Thanks for the response. I did a QW before I post this message and that was the reason I have mentioned that the BIND was successful. Also the new codes that I inserted are a couple of DISPLAY statements. I don't think it's relevant here._________________Thank You -Ace Back to top Display posts from previous: All Posts1 Day7 Days2 Weeks1 Month3 Months6 Months1 YearOldest FirstNewest First MVSFORUMS.com Forum Index -> Database All times are GMT - 5 Hours Page 1 of 1 Jump to:Select a forumAnnouncements----------------MVSFORUMS - AnnouncementsHelp Boards----------------Application ProgrammingDatabaseUtilitiesJob Control Language(JCL)CICS and MiddlewareIMSTSO and ISPFData ManagementProblem DeterminationMainframe ChallengeAbout MvsforumsOther Technical TopicsRelated Non-Technical TopicsInterview Q & AGeneral----------------Tools and DownloadsIT NewsTechnical FAQ (Tips)----------------Programming LanguagesDB2/IMSJCL/SORTTSO and ISPF You cannot post new topics in this forumYou cannot reply to topics in this forumYou cannot edit your posts in this forumYou cannot delete your posts in this forumYou cannot vote in polls in this forum MVSFORUMS Powered by phpBB © 2001, 2005 phpBB Group
QUESTIONSCOBOL INTERVIEW QUESTIONSDB2 INTERVIEW QUESTIONSCICS INTERVIEW QUESTIONSCICS INTERVIEW QUESTIONS 2 ABEND CODESJCL ABEND CODESVSAM FILE STATUS CODESSQL ERROR COEDSCICS ABEND CODES TOOLSABEND-AIDENDEVORXPEDIATOR DownloadesMAINFRAME MATERIALS SQL ERROR COEDS DB2 Return Codes 00 - Successful +100 - End of cursor / Successful Row not found -104 - SQL Syntax Error -180 to -189 String representation of DATE, TIIME, TIMESTAMP is invalid / format error -204 - Object not defined to DB2 / Table or Column not found -205 - Column name not in specified DB2 table -206 - Column does not exist in any table in the SELECT -302 to -309 Type mismatch error -501 - Fetch without opening the Cursor -530 to –542 Referential Integrity Error -551 - Not authorized to access DB2 -803 - Unique index violation. Try to insert duplicate record (Duplicate Error) -805 - Invalid Plan. DBRM or PACKAGE not found in PLAN -811 - Cursor should be used, when more than one row returned as a result of a singleton SELECT query -818 - Timestamp mismatch between plan and load module -904 - Resources not found -911 - Deadlock with rollback -913 - Deadlock without rollback -923 - DB2 Down -925 - SQL commit used in CICS programDB2 Return Codes SQLCODE +100 SQLSTATE 02000 Row not