Db2 Sql Error 991
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up Got a SQLCODE = -991 up vote http://www.ibm.com/support/knowledgecenter/SSEPEK_10.0.0/codes/src/tpc/n991.html -1 down vote favorite After the sub of the exec JCL, i've got the following error : SQLCODE = -991 Error = ALL ATTACH WAS UNABLE TO ESTABLISH AN IMPLICIT CONNECT OR OPEN TO DB2 This error is triggered when i call a module that allows to query a table. PS : i have the necessary privileges for the table. Thanks. db2 cobol jcl tso sqlcode share|improve http://stackoverflow.com/questions/5847910/got-a-sqlcode-991 this question asked May 1 '11 at 10:50 helication 11 add a comment| 3 Answers 3 active oldest votes up vote 0 down vote accepted From IBM's page: -991 CALL ATTACH WAS UNABLE TO ESTABLISH AN IMPLICIT CONNECT OR OPEN TO DB2. RC1= rc1 RC2= rc2 And some general links for SQL return code information: http://en.wikipedia.org/wiki/DB2_SQL_return_codes http://theamericanprogrammer.com/programming/sqlcodes.shtml http://www-01.ibm.com/support/docview.wss?rs=64&uid=swg27011656 - use the searches here to find lots of things http://publib.boulder.ibm.com/infocenter/dzichelp/v2r2/index.jsp share|improve this answer answered Apr 6 '12 at 15:27 Abacus 914917 add a comment| up vote 0 down vote Ensure you included DSNALI in your program bind (aka link) step, and that you're running on the correct LPAR. share|improve this answer answered May 1 '11 at 14:42 cschneid 4,7391921 add a comment| up vote 0 down vote It is possible you are not running on the same LPAR as DB2 and you don't have sharing enabled. share|improve this answer answered May 2 '11 at 18:53 Joe Zitzelberger 3,3991734 add a comment| Your Answer draft saved draft discarded Sign up or log in Sign up using Google Sign up using Facebook Sign up using Email and Password Post as a guest Name Email Post as a guest Name Email disc
sure to check out the 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 http://www.dbforums.com/showthread.php?1662779-DB2-error-991-can-t-figure-out-why want to visit from the selection below. Results 1 to 3 of 3 Thread: DB2 error -991, can't figure out why? Tweet Thread Tools Show Printable Version Subscribe to this Thread… Search Thread Advanced Search Display Linear http://searchdatamanagement.techtarget.com/tutorial/DB2-SQL-error-codes Mode Switch to Hybrid Mode Switch to Threaded Mode 12-10-10,12:08 #1 Balr14 View Profile View Forum Posts Registered User Join Date Sep 2002 Location Wisconsin Posts 37 Unanswered: DB2 error -991, can't figure out why? SQLCODE --> -991 db2 sql SQLERRML --> 0014 SQLERRMC --> 000800F30049 Explanation: A request was received to connect the requester's TCB to a DB2 subsystem, but the TCB is already connected. My problem is the program doesn't have any DB2 connect logic, so how can it be driven more than once? Reply With Quote 12-10-10,15:02 #2 schintala View Profile View Forum Posts Registered User Join Date Apr 2005 Location USA Posts 130 Are you executing the stored procedure that runs db2 sql error on WLM address space? If so make sure the stored procedure program is compiled correctly with call attachment facility such as DSNRLI during link edit. Reply With Quote 12-10-10,15:52 #3 Balr14 View Profile View Forum Posts Registered User Join Date Sep 2002 Location Wisconsin Posts 37 That was a good tip! Execution program doesn't seem to fit link edit requirements. Reply With Quote Quick Navigation DB2 Top Site Areas Settings Private Messages Subscriptions Who's Online Search Forums Forums Home Forums Non-SQL Forums MongoDB Database Server Software Adabas DB2 Informix Microsoft SQL Server MySQL Oracle Pervasive.SQL PostgreSQL Sybase Other Data Access, Manipulation & Batch Languages ASP Crystal Reports Delphi, C etc JAVA Perl and the DBI PHP ANSI SQL Unix Shell Scripts Visual Basic PC based Database Applications Brilliant Database Corel Paradox FileMaker Microsoft Access Microsoft Excel Other PC Databases General New Members & Introductions Applications & Tools Database Concepts & Design Chit Chat Marketplace Job Opportunities Suggestions & Feedback Links to other iNet owned sites web development forum Web Hosting Talk « Previous Thread | Next Thread » Posting Permissions You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is Off [VIDEO] code is Off HTML code is Off Forum Rules L
IBM DB2 DBMS View All AWS data warehousing DBMS strategy DBMS software Microsoft SQL Server management Oracle database management Integration View All Data virtualization Enterprise application integration (EAI) Data integration software Extract, transform and load (ETL) SOA data services Resources View All Jobs Podcasts Tutorials Quality / governance View All Data governance Data profiling Data quality tools Data quality best practices Data stewardship DBMS View All AWS data warehousing DBMS strategy DBMS software IBM DB2 Microsoft SQL Server management Oracle database management BI View All Advanced analytics Big data analytics BAM BI best practices BI case studies Dashboards / scorecards BI search BI software Compliance reporting software Performance management Data mining Analytics Financial reporting and compliance Text analytics / text mining ECM View All Collaboration platforms Content management software for compliance Content management Enterprise search SharePoint strategy Information governance Data warehouse View All Big data management Data modeling DW appliances Project management DW software Data architecture Hadoop MDM View All CDI MDM best practices PIM Topics Archive View All Enterprise information integration (EII) Verticals View All Financial services Healthcare Manufacturing Retail Please select a category Integration Resources Quality / governance DBMS BI ECM Data warehouse MDM Verticals Section All News Get Started Evaluate Manage Problem Solve Sponsored Communities DB2 SQL error codes Whether you are a total SQL newbie or a seasoned expert looking to tweak query performance, this Crash Course has something for you. These eight chapters can help you decipher common DB2 SQL error codes and figure out how to get the data you need by looking at real-world solutions to real-world problems. In this Article Share this item with your network: Related Content Risks in porting an application – SearchOracle Fast Guide: Solving SQL Server errors – SearchSQLServer Fast guide to common iSeries error messages – Search400 Sponsored News How to scale corporate IT systems with Linux –IBM Hyper-Convergence Delivers Better Mission-Critical Performance –SimpliVity See More Vendor Resources Has D