An Unexpected System Error Occurred Sqlstate 58004
Contents |
This document applies only to the following language version(s): English Problem(Abstract) When running db2start and db2stop locally, DB2 db2 sqlstate 58004 fails with following error: $ db2start SQL1042C An unexpected system error sql1042c sqlstate 58004 occurred. SQLSTATE=58004 $ db2stop SQL1042C An unexpected system error occurred. SQLSTATE=58004 Symptom When "SQL1042C" error is encountered sql0901n sqlstate 58004 on db2start and db2stop, subsequently all other db2 commands (except "db2level") fail with the following: 'SQL5005C' error if the db2systm file is missing or permission issue such as:
Db2 Connect Sql1042c An Unexpected System Error Occurred. Sqlstate=58004
$ db2 list db directory SQL5005C System Error. $ db2 get dbm cfg SQL5005C System Error. $ db2 list applications SQL5005C System Error. 'SQL5055C' error if the db2systm file is corrupted/invalid such as: $ db2 list db directory SQL5055C The content of the database configuration file is not valid. $ db2 get dbm cfg SQL5055C The content db2 sql error sqlcode=-1042 sqlstate=58004 of the database configuration file is not valid. $ db2 list applications SQL5055C The content of the database configuration file is not valid. Cause The db2systm file is either missing, permission issue or corrupted/invalid. This file is require in order for db2start to function properly. Environment DB2 UDB on Windows and UNIX Diagnosing the problem There is no '1042' error in the db2diag.log however You will see similar to the following error msg in the db2diag.log indicating that DB2 is unable to open the database manager configuration file: xxxx-xx-xx-xx.xx.xx.xxxxxx-xxx xxxxxxxxxx LEVEL: Error PID : xxx TID : xxx PROC : db2acd 0 INSTANCE: DB2 NODE : 000 EDUID : xxx EDUNAME: db2acd 0 FUNCTION: DB2 UDB, config/install, sqlfGetDbmCfg, probe:10 MESSAGE : SQL5005: sqlf_openfile rc = DATA #1 : Hexdump, 4 bytes 0x0000000110505500 : 860F 000A .... xxxx-xx-xx-xx.xx.xx.xxxxxx-xxx xxxxxxxxxx LEVEL: Error PID : xxx TID : xxx PROC : db2acd 0 INSTANCE: DB2 NODE : 000 EDUID : xxx EDUNAME: db2acd 0 FUNCTION: DB2 UDB, config/install, sqlfGetDbmCfg, probe:10 RETCODE :
DB2 4294966254 If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register sql1042c an unexpected system error occurred windows link above to proceed. To start viewing messages, select the forum that
Sql1042c An Unexpected System Error Occurred. Sqlstate=57019
you want to visit from the selection below. Results 1 to 4 of 4 Thread: DB2-SQL1042C An unexpected system
Db2start Sql1042c An Unexpected System Error Occurred
error occurred.SQLSTATE=58004 -Start DB2 4294966254 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-01-08,11:20 http://www.ibm.com/support/docview.wss?uid=swg21502619 #1 SANSSAN View Profile View Forum Posts Registered User Join Date May 2008 Posts 2 Unanswered: DB2-SQL1042C An unexpected system error occurred.SQLSTATE=58004 -Start DB2 4294966254 Friends, We were having an application was running on DB2 8.1 with Fixpack 6. Till then, was running good. When people installed Fixpak 7, unable to start the Server Instance or connect to the Database from Websphere v5.1(Data Source-> http://www.dbforums.com/showthread.php?1629936-DB2-SQL1042C-An-unexpected-system-error-occurred-SQLSTATE-58004-Start-DB2-4294966254 TestConnection)/Java code. Following ways, i have tried to start/connect the DB2. 1. Tried to connect to the Database from Control Center on the same server machine as well as from my desktop. Same Error message "SQL1042C An unexpected system error occurred.SQLSTATE=58004". 2. Tried to connect to the database from the command line in the server instance. Getting same error "SQL1042C An unexpected system error occurred.SQLSTATE=58004" 3. In Services (My Computer(Right Click)->Manage->Services->DB2 - DB2(Right Click)-> Start), Getting the error message as like "The DB2 - DB2 service terminated with service-specific error 4294966254". I have verified the service called "Server" running and Net BIOS over TCP/IP is enabled. 4. When i search with "SQL1042C An unexpected system error occurred.SQLSTATE=58004" in IBM site, they asked to drop instance and re-create. I tried. But,No use. Same error - SQL1042C. Few more details, for you guys to understand the problem. ------------------------------------------------------------- C:\Documents and Settings\Administrator>db2set -all [e] DB2PATH=C:\Program Files\IBM\SQLLIB DB2ACCOUNTNAME=OCS0357\admin DB2INSTOWNER=OCS0357 DB2PORTRANGE=50001:50004 DB2INSTPROF=C:\PROGRA~1\IBM\SQLLIB [g] DB2_EXTSECURITY=YES [g] DB2SYSTEM=OCS0357 [g] DB2PATH=C:\Program Files\IBM\SQLLIB [g] DB2ADMINSERVER=DB2DAS00 C:\Documents and Settings\Administrator> ------------------------------------------------------------- C:\Documents and Settings\Administrator>db2 get dbm cfg Database Manager Configuration Node type = Enterprise Server Edition with local and remote
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 http://stackoverflow.com/questions/10718474/db2-connect-sql1042c-error 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 DB2 connect SQL1042C error up vote 0 down vote favorite When I give DB2 CONNECT command I get the error saying "SQL1042C An unexpected system error occurred". The most weird thing an unexpected is this issue is intermittant. sqlcode: -1042; sqlstate: 58004; DB2 connect command: connect to dbname user db2admin using password; My DB2 version is: DB2/NT64 9.5.0 db2 share|improve this question edited Dec 3 '12 at 13:55 AngocA 5,74021742 asked May 23 '12 at 10:52 user1412385 111 add a comment| 3 Answers 3 active oldest votes up vote 2 down vote There are a few directions in the Information Center on how you might be able to fix this error, an unexpected system one of which involves calling IBM for support. Hope that helps! share|improve this answer answered May 23 '12 at 13:45 bhamby 10.8k1647 add a comment| up vote 1 down vote You might find additional information in the file db2diag.log, which is located in a place like /home/db2inst1/sqllib/db2dump/db2diag.log . Or you can use the command db2diag with an option like db2diag -lastrecords 100 share|improve this answer answered Mar 30 '15 at 14:09 Oliver Schoett 112 add a comment| up vote 1 down vote Try to use db2 "? sql-1042" for more information. On the other hand, if you just installed new db2 software code, try to use db2iupdt instance_name to update db2 instance. share|improve this answer answered May 27 '15 at 5:31 William Kwok 111 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 db2 or ask your own question. asked 4 years ago viewed 6562 times active 1 year ago Visit Chat Related 7Db2 connection problem with java5db2 can't connect from clients after restart0Db2 error : SQL0901N, SQLSTATE=580041User authorization in DB22Java - DB2 Connection Error SQL30082N “U