Db2 Sql Error Sqlcode=-923
Contents |
FAQ by clicking the link above. You may have to register before you can post: click the register link above to
Db2 Sql Error Sqlcode 440 Sqlstate 42884 Stored Procedure
proceed. To start viewing messages, select the forum that you want to db2 sql error sqlcode 804 visit from the selection below. Results 1 to 5 of 5 Thread: SQL code -923 Tweet Thread Tools Show db2 sql error sqlcode 204 sqlstate 42704 Printable Version Subscribe 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 Profile View Forum Posts http://www.ibm.com/support/knowledgecenter/SSEPEK_10.0.0/codes/src/tpc/n923.html 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 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 http://www.dbforums.com/showthread.php?493130-SQL-code-923 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,, 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 VAL
AllOther 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 https://kb.informatica.com/solution/23/Pages/53/328356.aspx 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.
location is: KBSolution23Pages53328356 Sign In Log In | Sign Up | Log out Feedback Authoring Home Toggle navigation Network Home Informatica.com Communities Big Data Management Big Data Management Edition Big Data Parser Big Data Management Trial Edition Cloud Integration Cloud Application Integration Cloud Data Integration Cloud Customer 360 DiscoveryIQ Cloud Data Wizard Informatica Cloud for Amazon AWS Complex Event Processing Proactive Healthcare Decision Management Proactive Monitoring Real-Time Alert Manager Rule Point Data Integration B2B Data Exchange B2B Data Transformation Data Integration Hub Data Replication Data Services Data Validation Option Fast Clone Informatica Platform Metadata Manager PowerCenter PowerCenter Express PowerExchange PowerExchange Adapters Data Quality Address Doctor Address Doctor Cloud Data as a Service Data Explorer Data Quality Data Quality Services (Strike Iron) Data Security Group (Formerly ILM) Data Archive Data Centric Security Secure@Source Secure Testing Master Data Management Identity Resolution MDM Big Data Relationship Management MDM Multidomain Edition MDM Registry Edition Process Automation ActiveVOS Cloud Extend Product Information Management Informatica Procurement Product Information Management Ultra Messaging Ultra Messaging Options Ultra Messaging Persistence Edition Ultra Messaging Queuing Edition Ultra Messaging Streaming Edition Vibe Data Stream Documentation Knowledge Base Resources PAM (Product Availability Matrices) Support TV Informatica Expert Assistant Velocity (Best Practices) Mapping Templates Debugging Tools User Groups Informatica Network Knowledge Base 23 KB > Solution > 23 > Pages > 53 > 328356 KB Home Page Authoring Home Top Link Bar KBCurrently selected FAQHowToSolution 6789 WhitepapersKBOktaSyncAdminKBOktaSync KB Search Authoring Home Search Demo Quick Launch Rate It: Average Rating: ERROR: "PWX-09256 No full image copy has been taken for table