An Unexpected System Error Occurred. Sqlstate=58004 Db2
Contents |
This document applies only to the following language version(s): English Problem(Abstract) When running db2start and db2stop locally, DB2 fails with following error: $ db2start SQL1042C An unexpected system error occurred. db2 connect sql1042c an unexpected system error occurred. sqlstate=58004 SQLSTATE=58004 $ db2stop SQL1042C An unexpected system error occurred. SQLSTATE=58004 Symptom When "SQL1042C" error
Db2 Sql Error Sqlcode=-1042 Sqlstate=58004
is encountered on db2start and db2stop, subsequently all other db2 commands (except "db2level") fail with the following: 'SQL5005C' error if the sql1042c an unexpected system error occurred. sqlstate=57019 db2systm file is missing or permission issue such as: $ db2 list db directory SQL5005C System Error. $ db2 get dbm cfg SQL5005C System Error. $ db2 list applications SQL5005C System Error. 'SQL5055C' error sql1042c an unexpected system error occurred windows 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 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
Sqlstate=58004 Sqlcode=-901
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 : ZRC=0xFFFFEC73=-5005 xxxx-xx-xx-xx.xx.xx.xxxxxx-xxx xxxxxxxxxx LEVEL: Severe PID : xxx TID : xxx PROC : db2acd 0 INSTANCE: DB2 NODE : 000 EDUID : xxx EDUNAME: db2acd 0 FUNCTION: DB2 UDB, config/install, sqlf_alert, probe:8 DATA #1 : Hexdump, 4 bytes 0x0000000110505450 : FFFF EC73 ...s xxxx-xx-xx-xx.xx.xx.xxxxxx-xxx xxxxxxxxxx LEVEL: Severe PID : xxx TID : xxx PROC : db2acd 0 INSTANCE: DB2 NODE : 000 EDUID : xxx EDUNAME: db2acd 0 FUNCTION: DB2 UDB, config/install, sqlfGetDbmCfg, probe:8 RE
log in tour help Tour Start 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 db2start sql1042c an unexpected system error occurred developers or posting ads with us Database Administrators Questions Tags Users Badges Unanswered Ask Question sql1042c an unexpected system error occurred. sqlstate=58004 db2start _ Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from
Sql1042c An Unexpected System Error Occurred. Sqlstate=58004 Windows
others in the community. Join them; it only takes a minute: Sign up Here's how it works: Anybody can ask a question Anybody can answer The best answers are voted up and rise to the top “SQL1042C An unexpected system http://www.ibm.com/support/docview.wss?uid=swg21502619 error” when creating a database up vote 0 down vote favorite I installed DB2 Express-C 10.1 on OS X 10.8.4. I installed it in user mode, and it seems to have created an instance with my username (avernet). I checked the instance is indeed there by running db2ilist. The database manager is running, as when I run db2start, I get the message SQL1026N The database manager is already active. Now, I am trying to create a database by running db2 http://dba.stackexchange.com/questions/45449/sql1042c-an-unexpected-system-error-when-creating-a-database from the command line, and typing the command create database orbeon, but it returns: QL1042C An unexpected system error occurred. SQLSTATE=58004 What am I missing here? How can I create a simple database from the command line (I prefer not to bother with Data Studio as it isn't available for OS X)? In db2dump/db2diag.log, I see the follwing error (full file, in case you're interested): 2013-06-29-15.31.38.948217-420 E159047E344 LEVEL: Error (OS) PID : 1766 TID : 140735175762304PROC : db2star2 INSTANCE: avernet NODE : 000 HOSTNAME: huashan.local FUNCTION: DB2 UDB, SQO Memory Management, sqloMemCreateSingleSegment, probe:100 CALLED : OS, -, shmget OSERR: 17 Note that for the install to go through, I increased the OS X shared memory, per this recommendation. db2 mac-os-x share|improve this question edited Jul 5 '13 at 18:37 asked Jun 28 '13 at 23:05 avernet 12118 1 Check the file db2diag.log -- it will be in $INSTANCE_HOME/sqllib/db2dump. It will contain details about the error. –mustaccio Jul 3 '13 at 17:42 @mustaccio I did, and see one error there, which I copied and put in the question. Does that ring a bell? –avernet Jul 3 '13 at 20:22 I'm afraid that's too small a fragment to be useful. How much memory have you got on your Mac? And why did you choose a non-root installation? It has all sorts of limitations. –mustaccio Jul 3 '13 at 20:37 Does that error
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 http://stackoverflow.com/questions/30904240/ibm-db2-10-5-fp3-sql1042c-an-unexpected-system-error-occurred-sqlstate-58004-d 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 IBM DB2 10.5 FP3 -sql1042c an an unexpected unexpected system error occurred. sqlstate=58004 db2 connect windows up vote 3 down vote favorite 2 We recently upgraded some of our employee's DB2 Runtime client from 9.7 (32 bit) to 10.5 FP3 (64 bit) in their windows 7 machines.After that some of them are having issues when trying to connect to our database through an excel macro or even through db2 clp.They are getting the below an unexpected system error IBM CLI Driver SQL1042C An unexpected system error occurred. SQLSTATE=58004 I have checked their db2diag.log and i see this 2015-06-17-17.06.34.820000-240 I11076H445 LEVEL: Error PID : 1216 TID : 5372 PROC : EXCEL.EXE INSTANCE: DB2 NODE : 000 HOSTNAME: MLIW***** EDUID : 5372 FUNCTION: DB2 Common, Cryptography, cryptDynamicLoadGSKitCrypto, probe:998 MESSAGE : ECF=0x90000007=-1879048185=ECF_UNKNOWN Unknown DATA #1 : unsigned integer, 4 bytes 60 DATA #2 : String, 11 bytes gsk8sys.dll* Please advise. db2 share|improve this question edited Jun 17 '15 at 23:46 Brent Washburne 7,22742242 asked Jun 17 '15 at 23:39 Venkata Pakalapati 163 gsk8sys.dll is a 32-bit library. The fact that DB2 attempts to load it means that a 32-bit application wants to connect to the database. To make this work you will need to install a 32-bit DB2 client. –mustaccio Jun 18 '15 at 11:40 Thanks.But if other user logs into the same machine and try,it works.It is just that it does not work for this user.I am lost. –Venkata Pakalapati Jun 18 '15 at 15:35 add a comment| active oldest votes Know someone who can answer? Share a link to this question via email, Google+, Twitter, or Facebook. Your Answer dra