Db2 Error 1390
Contents |
IZ04271 Technote (troubleshooting) Problem(Abstract) IBM InfoSphereâ„¢ DataStage jobs using DB2 Enterprise Edition stage cannot connect to remote IBM DB2 databases with the sql10007n reason code 3 following levels: DB2, Version 8, FP16 (and higher) DB2, Version 9.1, FP5 (and
Sqlcode
higher) DB2, Version 9.5, FP2 (and higher). Symptom The following error message is displayed: REF_DFLT_REC_COUNTS,0: Error Idx = 1; DB2 Driver Embedded SQL message: ; sqlcode = -1390; sqlstate = Failed to connect to the database Error Idx = 5; DB2 Driver Embedded SQL message: ; sqlcode = -1024; sqlstate = 080. Cause A change introduced in DB2 (APAR IZ04271) on the timing for initializing environment variables is the cause for not being able to access remote DB2 databases. As a result of this change, after the DB2INSTANCE value is loaded and cached in memory, this value cannot be reset by setenv which affects the way InfoSphere DataStage establishes the IBM DB2 environment for remote connectivity. Resolving the problem Use the InfoSphere DataStage startup.apt script to set the IBM DB2 environment. InfoSphere DataStage Parallel Extender (PX) provides the ability to run a startup script on each PX node. Locate this script in the PX installation as $APT_ORCHHOME/etc/startup.apt . Otherwise, if there is a shared disk for all of the PX nodes, replace this default location with the environmental variable, APT_STARTUP_SCRIPT. You can use the following sample script to set IBM DB2 environment: #startup.apt #!/bin/sh if [ `hostname`!= "
retrieved. Reason code: "3" SQL10007N db2start -1390 SQL1390C Technote (troubleshooting) Problem(Abstract) DB2START can fail, reporting SQL1390C, for various reasons. Symptom The db2start command will fail with the following error message: SQL10007N Message "-1390" could not be retrieved. Reason code: "3" Cause The problem can be due to several reasons. The common culprits are: Incorrect DB2INSTANCE environment variable setting. The db2profile has not be sourced properly. IZ36615 Inconsistencies in /etc/group or /etc/passwd Resolving the problem First, it is a good idea http://www.ibm.com/support/docview.wss?uid=swg21381234 to run db2iupdt as the root user if you're receiving this error message. If db2start continues to fail you should check the following: The "DB2INSTANCE" environment variable should be set to the instance name of the instance you wish to start. You can check this value by running "env". On UNIX and Linux the db2profile should be sourced properly http://www-01.ibm.com/support/docview.wss?uid=swg21474604 (db2cshrc for C shell). This may mean the user's profile contains a command similar to: . sqllib/db2profile If you're on AIX and receiving this message you should check the password algorithm being used for the user. The sha256 algorithm, for example, is not supported in DB2 V9.1 (at V9.5 Fix Pack 4 it is). You can check the password rules for each DB2 version in the respective Information Center. Check the "id" output of the user running db2start. Then, check to make the user and user's group exist in the /etc/passwd and /etc/group files respectively. Make sure permissions correctly set (at least 644). Related information SQL1390C Password Rules for DB2 V9.1 Password Rules for DB2 V9.5 IZ36615 DB2IUPDATE command Starting Instances (db2profile) Document information More support for: DB2 for Linux, UNIX and Windows Software version: 9.1, 9.5, 9.7 Operating system(s): AIX, Linux, Solaris, Windows Reference #: 1474604 Modified date: 2011-03-31 Site availability Site assistance Contact and feedback Need support? Submit feedback to IBM Support 1-800-IBM-7378 (USA) Directory of worldwide contacts Contact Privacy Terms of use Accessibility
Technology and Trends Enterprise Architecture and EAI ERP Hardware IT Management and Strategy Java Knowledge Management Linux Networking Oracle PeopleSoft Project and Portfolio Management SAP SCM Security Siebel Storage UNIX Visual Basic Web Design and Development Windows http://database.ittoolbox.com/groups/technical-functional/db2-l/failed-to-connect-to-database-4530765 < Back CHOOSE A DISCUSSION GROUP Research Directory TOPICS Database Hardware Networking SAP Security Web http://stackoverflow.com/questions/2553899/sqlcode-1390-connecting-to-db2-64-bit-client-from-32-bit-app Design MEMBERS Paul_Pedant DACREE MarkDeVries Inside-ERP MacProTX VoIP_News Inside-CRM PCMag I_am_the_dragon maxwellarnold Michael Meyers-Jouan TerryCurran Chris_Day Andrew.S.Baker JoeTorre bracke Locutus Ramnath.Awate Richard DukeGanote Craig Borysowich Dennis Stevenson Nikki Klein mircea_luca AbhaiTripathi knowscognosdoi Clinton Jones bluesguyAZ59 Iqbalyk blrvenkat COMPANIES Juniper Networks CloudLock Avaya Adaptive Planning View All Topics View All Members View All Companies Toolbox for IT Topics Database db2 error Groups Ask a New Question DB2 LUW The DB2 LUW (Linux, Unix, Windows) group is for the discussion of technical issues related to the installation, configuration, or daily administration of IBM DB2 LUW databases. Home | Invite Peers | More Database Groups Your account is ready. You're now being signed in. Solve problems - It's Free Create your account in seconds E-mail address is taken If this is your account,sign in here Email address db2 error 1390 Username Between 5 and 30 characters. No spaces please The Profile Name is already in use Password Notify me of new activity in this group: Real Time Daily Never Keep me informed of the latest: White Papers Newsletter Jobs By clicking "Join Now", you agree to Toolbox for Technology terms of use, and have read and understand our privacy policy. Failed to Connect to Database DS... asked Nov 28, 2011 | Replies (11) Hi , DB2 ENTERPRISE STAGE I have following error while reading data from DB2 TABLES V8: DB2_UDB_Enterprise_0: Error Idx = 1; DB2 Driver Embedded SQL message: ; sqlcode = -1390; sqlstate = Failed to connect to the database. using Aix : SELECT * FROM SCHEMA.TABLENAME Giving input correctly. Please let me know whats wrong with the connection. Thank you Join this group Best Answer Updated html error Hi all, The DB2 Enterprise is not configured to the current Development Environment. That is the error message showing. Thank you. Help the community by fixing grammatical or spelling errors, summarizing or clarifying the solution, and adding supporting information or resources. Always respect the original author. Edits are subject to review by community moderators. Original answer by DS... Dec 9, 2011 Contributors: Top Hi all, The DB2 Enterprise is not configured to the current... Reply from DS... |
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 SQLCODE -1390 connecting to DB2 64 bit client from 32 bit app up vote 0 down vote favorite I've got a 32 bit application that connects normally to a DB2 database. (written in C) When I run it on a machine with a DB2 64 bit client, I get a SQLCODE -1390 from connect. (Win7 64 Bit, DB2 V9.7 client 64 bit) Connecting from the command line works (db2 connect to ...) With a 32 Bit DB2 client on the same Win7 64 Bit machine, the connect also works. Does anyone has an idea how to fix it ? Best regards Oliver windows-7 db2 database-connection windows-7-x64 share|improve this question edited May 9 '10 at 19:26 Jon Seigel 9,46254381 asked Mar 31 '10 at 14:46 Oliver Abraham 535 add a comment| 1 Answer 1 active oldest votes up vote 1 down vote IBM DB2 Fixpack 1 solved the problem ! share|improve this answer answered Apr 8 '10 at 5:48 Oliver Abraham 535 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 discard By posting your answer, you agree to the privacy policy and terms of service. Not the answer you're looking for? Browse other questions tagged windows-7 db2 database-connection windows-7-x64 or ask your own question. asked 6 years ago viewed 1175 times active 5 years ago Related 2