Db2 Sql Error Sqlcode=-1060
Contents |
Technote (FAQ) Question This technote provides details on the error message sqlcode: -1060, which appears in the sqlcode 1060 db2diag.log file. Answer Problem DB2 reports the following error in db2diag.log
Sqlstate=42601
when a client attempts to connect to the database server: 2007-08-08-09.28.41.743921-240 I10291947A425 LEVEL: Error PID : 1720384 TID sqlstate=57011 db2 : 1 PROC : db2agent (DPADB) 0 INSTANCE: XXXXX NODE : 000 DB : DPADB APPHDL : 0-154 APPID: GA381C80.O107.00D748132841 FUNCTION: DB2 UDB, relation data serv, sqlrr_appl_init, probe:180 RETCODE 58004 sqlstate : ZRC=0x8012006D=-2146303891=SQLR_CA_BUILT "SQLCA has already been built" 2007-08-08-09.28.41.745208-240 I10292373A694 LEVEL: Error PID : 1720384 TID : 1 PROC : db2agent (DPADB) 0 INSTANCE: XXXXX NODE : 000 DB : DPADB APPHDL : 0-154 APPID: GA381C80.O107.00D748132841 DATA #1 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes sqlcaid : SQLCA sqlcabc: 136 sqlcode: -1060 sqlerrml: 8 sqlerrmc: YYYYY sqlerrp : sqlrrait sqlerrd : (1)
Db2 Sqlstate=42501
0x8012006D (2) 0x00000000 (3) 0x00000000 (4) 0x00000000 (5) 0x00000000 (6) 0x00000000 sqlwarn : (1) (2) (3) (4) (5) (6) (7) (8) (9) (10) (11) sqlstate: Cause You can ignore the initial part of this message. The SQLR_CA_BUILT portion indicates that the SQLR_CA structure has already been built. This can occur as a result of a previous error. The "sqlcode: -1060" is the error that causes the problem. This results from a user without CONNECT privileges for your database trying to connect to the database. db2 ? sql1060 SQL1060N User "
sophisticated digital experiences Web content & Customer Journey Sitefinity CMS Build engaging websites with intuitive web content management Application Development, Testing & Deployment DevCraft Leverage a complete UI toolbox for web, mobile and desktop development OpenEdge Build, db2 sql error sqlcode 1060 sqlstate 08004 protect and deploy apps across any platform and mobile device Kendo UI Build db2 sql error sqlcode list rich, smart HTML5 and JavaScript apps for any platform, browser or device Telerik Platform Build mobile apps for iOS,
Db2 Sql Error Sqlcode 305
Android and Windows Phone Nativescript Use Angular, TypeScript or JavaScript to build truly native mobile apps Rollbase Rapidly develop, manage and deploy business apps, delivered as SaaS in the cloud Test Studio http://www-01.ibm.com/support/docview.wss?uid=swg21289255 Automate UI, load and performance testing for web, desktop and mobile Modulus Host, deploy and scale Node.js, Java and .NET Core apps on premise or in the cloud Data Connectivity DataDirect Connectors Optimize data integration with high-performance connectivity Business Rules Management Corticon Automate decision processes with a no-code business rules engine View All Products Solutions Digital Business Transformation Transform your businesses in order to survive http://knowledgebase.progress.com/articles/Article/00033571 in a completely digitized and connected world driven by software innovation. Web Scale Globally scale websites with innovative content management and infrastructure approaches Modernization UX and app modernization to powerfully navigate todays digital landscape Omni-Channel Engagement Content-focused web and mobile solution for empowering marketers aPaaS Fuel agility with ever-ready applications, built in the cloud Enterprise Mobility Faster, tailored mobile experiences for any device and data source New & Trending E-book The Digital Ultimatum: Why Businesses Must Digitally Transform to Survive â€" and Thrive Survey Report The State of Digital Business Support & Learning Support Support Services Knowledge Base Customer Order Management Download Center Services Training Consulting Services Managed Database Offering Learning Documentation Webinars How-To Videos Whitepapers Community Blogs Success Stories Partners Company Login Progress Support Rollbase DataDirect Cloud PartnerLink Telerik Your Account Telerik Platform Global Sites Brazil France Germany Netherlands United States Menu 1-800-477-6473 CONTACT SLAES Knowledge Base 000033571 < Back to search results Unknown error: SQLCODE -1060 occurs when trying to connect to DB2 with the Connect for ODBC DB2 driverPrintable View «Go BackInformation EnvironmentProduct: Connect for ODBC DB2 driver OS: All supported platforms Database: DB2 Application: All supported appl
a anonymous started a topic over 1 year ago [This topic is migrated from our old forums. The original author name https://support.dbvis.com/support/discussions/topics/1000077719 has been removed]While trying to connect to DB2 UDB (db2 on unix) through dbvisualiser 9.1.2 the following error is coming when we 'connect' An error occurred while establishing the connection: Long Message: DB2 SQL Error: SQLCODE=-1060, SQLSTATE=08004, SQLERRMC=A0265558, DRIVER=4.15.82 Details: Type: com.ibm.db2.jcc.am.SqlNonTransientConnectionException Error Code: -1060 SQL State: 08004 Please assist. Thanks. 1 Comment Hans Bergsten said over 1 year ago db2 sql [This reply is migrated from our old forums.]Re: DB2 UDB connection issueHi, Googling a bit I found that SQLCODE=-1060 means that the user does not have the CONNECT privilege, so the DBA needs to grant this privilege to the user. If you check the Show Detailed Error Messages checkbox in the Options area of the Connection tab, you will get error db2 sql error codes translated into meaningful text automatically. Best Regards, Hans Comments to this discussion are now closed! More topics in Support Forward Engineering DB2 Database Connection Dropping every 20-30mins or so ? roles are not unfolded Install4j: Java(Tm) VM could not be started Worksheet name default when exporting to Excel? sqlformatter and extract Bug with empty password dbvis 5.0 gives error after opening Saving file makes it incompatible with other SQL tools!!!?!?!?!? Error Schema Name in References view. See all 1063 topics Home Solutions Forums Cookie policy We use cookies to try and give you a better experience in Freshdesk. You can learn more about what kind of cookies we use, why, and how from our Privacy Policy. If you hate cookies, or are just on a diet, you can disable them altogether too. Just note that the Freshdesk service is pretty big on some cookies (we love the choco-chip ones), and some portions of Freshdesk may not work properly if you disable cookies. We’ll also assume you agree to the way we use cookies and are ok with it as descr