db2 sql error sqlcode=-923
FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. Results
Db2 Sql Error Sqlcode 440 Sqlstate 42884 Stored Procedure
1 to 5 of 5 Thread: SQL code -923 Tweet Thread Tools Show Printable Version Subscribe db2 sql error sqlcode 804 to this Thread… Search Thread Advanced Search Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode 09-05-02,19:04 #1 anilc View db2 sql error sqlcode 204 sqlstate 42704 Profile View Forum Posts Registered User Join Date Aug 2002 Location Denver,co Posts 8 Unanswered: SQL code -923 When running a COBOL program, I am getting the SQLCODE -923 and reason code 00E30302 and TYPE 00000800. Help says that DB2 http://ibmmainframes.com/about4881.html may be down. But that is not the case in here. I rebound the plan just incase, still that doesnt seem to work. Can anyone help me resolve the problem please....!! This is veri urgent. Thanks, Anil Reply With Quote 09-05-02,22:24 #2 db2rules View Profile View Forum Posts Registered User Join Date Aug 2002 Location Texas, USA Posts 11 Hi Anilc, try looking at the output (SFSF, IOF, ???) of the DB2 Master job's JESMSGLG. Jobname is usually db2subsystemidMSTR,, http://www.dbforums.com/showthread.php?493130-SQL-code-923 ie: DB2PMSTR. Also check the same output DD in the DB2xDBM1. The reason is that I suspect an unavailable resource is getting you and you might be able to find the resource in one of those two spots. ALSO.. think about doing: -DISPLAY DATABASE(dbname) SPACENAM(*) RESTRICT to see if there are any flags up. Hope this helps! DB2 Rules. Reply With Quote 09-06-02,12:44 #3 anilc View Profile View Forum Posts Registered User Join Date Aug 2002 Location Denver,co Posts 8 That didnt work though. any more ideas? Reply With Quote 09-06-02,15:29 #4 db2rules View Profile View Forum Posts Registered User Join Date Aug 2002 Location Texas, USA Posts 11 hmmmm, The TYPE 800 is a PLAN, do: SELECT * FROM SYSIBM.SYSPLAN WHERE NAME = 'planname' ; Check the VALID column, I suspect you'll find an 'N' there. If so, there has to be something in the plan you're using that is unavailable, like a table, index etc... You're sure you found nothing on your RESTRICT command? Try trimming the plan down to just include the DBRM's you need for what you're doing. This is easy for batch, not as easy for CICS. This might help in determining what's unavailable. Reply With Quote 09-06-02,15:32 #5 anilc View Profile View Forum Posts Registered User Join Date Aug 2002 Location Denver,co Posts 8 I created the plan again and it worked. Thanks anyways. Reply With Quote Quick NavAllOther Suggest New Category What is sqlcode -923 ? Question Posted / francesco 1 Answers 5947 Views I also Faced E-Mail Answers http://www.allinterview.com/showanswers/133996/what-is-sqlcode-923.html Answer / aakash kathunia The connection for the 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 Is This Answer Correct ? 6 Yes 2 No Post New Answer Categories Oracle (1869)SQL Server (1096)MS Access (27)MySQL (201)Postgre (50)Sybase (22)DB Architecture (9)DB sql error Administration (215)DB Development (56)SQL PLSQL (838)Databases AllOther (115) More Databases AllOther Interview Questions what is Normalization means..? 8 Answers Bank Of America, TCS, Infosys, AZTEC, Define the following terms i. Inverted List ii. Candidate Key iii. B-Tree iv. Foreign Key 1 Answers Ignou, what is data set ? 1 Answers Which is the best sorting method if i have to sort the students of Harvard db2 sql error University according to their first name? 1 Answers CybAge, WHAT IS NEED BY METION DATFMT AND TIMFMT IN H-SEPICITION IN RPGLE? 0 Answers Is it possible to update AS400 database record while reading it with no lock 1 Answers how node connect with cpu? 0 Answers IBM, What are the two categories of Client-Server application development? 1 Answers can u combine pipeline parallelism and partition parallalism? how and whan? 0 Answers TCS, can any one tell me how i can start database testing mean what should be initial point and how i can write a query for listing page of any item thanks in advance 0 Answers i have windows-xp processor with P4 system. whenever I tried to download foxpro for windows 2.6 on windows XP, my operating system failed to install foxpro for windows 2.6.please. how could i download , install & run foxpro for windows 2.6 easily on windows XP ? 0 Answers What is OQL? 4 Answers For more Databases AllOther Interview Questions Click Here Copyright Policy | Terms of Service | Site Map | Contact Us Copyright © 2016 ALLInterview.com. All Rights Reserved.