Db2 Sql 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 following levels: DB2, Version 8, FP16 (and sql10007n higher) DB2, Version 9.1, FP5 (and higher) DB2, Version 9.5, FP2 (and higher).
Sqlcode
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`!= "
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 1 to 8 of 8 Thread: Sqlcode= -1390 Tweet Thread Tools Show Printable Version Subscribe to this Thread… Search Thread Advanced Search Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode 05-12-03,14:04 #1 Rick-dba View Profile View Forum Posts Registered User Join Date Apr 2003 Location Florida Posts 79 Unanswered: Sqlcode= -1390 I can't find any documentation on this SQLCODE.... -1390 http://www.ibm.com/support/docview.wss?uid=swg21381234 We had to drop and recreate our db2admin server - we got it restarted ok but I still cannot connect (attach) to it via "Task Center") db2 udb v8.1 on Linux. Any ideas? Thanks! Rick Reply With Quote 05-13-03,03:07 #2 zkajfez View Profile View Forum Posts Registered User Join Date Jan 2002 Posts 165 On Win2000,in directory SQLLIB there is a folder DB2DAS00 (name of db2admin server).Under that,you can find log for http://www.dbforums.com/showthread.php?781874-Sqlcode-1390 db2admin server.Try check that log. Cheers,Zvonimir Reply With Quote 05-13-03,03:10 #3 jsander View Profile View Forum Posts Registered User Join Date Apr 2003 Posts 191 Re: Sqlcode= -1390 Hi, did you try: db2 "? sql1390n" Johann Originally posted by Rick-dba I can't find any documentation on this SQLCODE.... -1390 We had to drop and recreate our db2admin server - we got it restarted ok but I still cannot connect (attach) to it via "Task Center") db2 udb v8.1 on Linux. Any ideas? Thanks! Rick Reply With Quote 05-13-03,08:03 #4 Rick-dba View Profile View Forum Posts Registered User Join Date Apr 2003 Location Florida Posts 79 SQL1390N doesn't return anything either.... The actual code is "DBA1177N" which returns: DBA1177N A database connection to the Tools Catalog Database database-name cannot be made. SQLCODE sqlcode Explanation: A database connection to the Tools Catalog Database database-name cannot be made. SQLCODE sqlcode User Response: Refer to the user response for the SQLCODE returned from the connect operation. But I can't find a definition of the problem because SQLCODE -1390 is not explained anywhere........ There is nothing in either log referring to the problem: db2dasdiag.log or db2diag.log I can connect to the DB and run queries against it - but "Task Center" cannot connect. Reply With Quote 05-13-03,08:31
Technology and Trends Enterprise Architecture and EAI ERP Hardware IT Management and Strategy Java Knowledge Management http://database.ittoolbox.com/groups/technical-functional/db2-l/failed-to-connect-to-database-4530765 Linux Networking Oracle PeopleSoft Project and Portfolio Management SAP SCM Security Siebel Storage UNIX Visual Basic Web Design and Development Windows < Back CHOOSE A DISCUSSION GROUP Research Directory TOPICS Database Hardware Networking SAP Security Web 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 db2 sql Andrew.S.Baker JoeTorre bracke Locutus Ramnath.Awate Richard DukeGanote Craig Borysowich Dennis Stevenson Nikki Klein mircea_luca AbhaiTripathi knowscognosdoi bluesguyAZ59 Iqbalyk Clinton Jones blrvenkat COMPANIES Juniper Networks CloudLock Avaya Adaptive Planning View All Topics View All Members View All Companies Toolbox for IT Topics Database Groups Ask a New Question DB2 LUW The DB2 LUW db2 sql error (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 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_