Db2 Sql Error Code 1042
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. ibm db2 sql error code SQLSTATE=58004 $ db2stop SQL1042C An unexpected system error occurred. SQLSTATE=58004 Symptom When "SQL1042C" error
Db2 Sql Error Code 805
is encountered on db2start and db2stop, subsequently all other db2 commands (except "db2level") fail with the following: 'SQL5005C' error if the db2 sql error code 404 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
Db2 Sql Error Code 104
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 db2 sql error code 803 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 : 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
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss
Db2 Sql Error Code 811
the workings and policies of this site About Us Learn more
Db2 Sql Error Code 204
about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Stack Overflow db2 sql error code 206 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 http://www.ibm.com/support/docview.wss?uid=swg21502619 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 is this issue is intermittant. sqlcode: -1042; sqlstate: 58004; DB2 connect command: connect to dbname user db2admin http://stackoverflow.com/questions/10718474/db2-connect-sql1042c-error 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,75621744 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, 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
log in tour help Tour Start here for a quick overview of the site Help Center Detailed answers to any questions you might http://dba.stackexchange.com/questions/45449/sql1042c-an-unexpected-system-error-when-creating-a-database 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 Database Administrators Questions Tags Users Badges Unanswered Ask Question _ Database Administrators Stack Exchange is a question and answer site for database professionals who wish db2 sql to improve their database skills and learn from 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 error” when creating a database up vote 0 db2 sql error 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 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:10