Home > database >  MAC db2start error SQL1042C
MAC db2start error SQL1042C

Time:10-04

Error: SQL1042C An unexpected system error occurred.


Relevant information
The MAC mini
System version: OS X 10.11.4 (15 e65)
The kernel version: Darwin 15.4.0

DB2 Express - C 10.1
Below is the db2diag.
the content of the log=============================
=============================
The 2017-02-17-18.53.22.213136 + 480 I1E1310 LEVEL: the Event
PID: 16527 dar: 140735126765568 proc: db2start
INSTANCE: db2inst1 NODE: 000
The HOSTNAME: zhoupindeMac - mini. Local
FUNCTION: DB2 UDB, RAS/PD component, pdLogInternal, the probe: 120
START: New Diagnostic Log file
DATA # 1: Build Level, 152 bytes
The Instance "db2inst1" USES "64" bits and the DB2 code release "SQL10010
"With level identifier "0201010 e".
Informational tokens are "DB2 v10.1.0.0 s120905", ""," DARWIN64101 ", Fix Pack "0".
DATA # 2: the System Info, 1568 bytes
System: Darwin zhoupindeMac - mini. Local 15.4.0 Darwin Kernel Version 15.4.0: Fri Feb 26 22:08:05 PST 2016; Root: xnu - 3248.40.184 ~ 3/RELEASE_X86_64 x86_64
CPU: total: 4 online: 4 Threading degree per core: 1
Physical Memory (MB) : total: 8190 free: 4876
Virtual Memory (MB) : total: 8190 free: 4876
Free Swap Memory (MB) : total: 0:0
Cur CPU time limit (seconds)=0 x7fffffffffffffff
Cur the file size limit (bytes)=0 x7fffffffffffffff
Cur data size (bytes)=0 x7fffffffffffffff
Cur stack size (bytes)=0 x0000000000800000
Cur core size (bytes)=0 x0000000000000000
Cur the memory size (bytes)=0 x7fffffffffffffff
X000000000000fde8 nofiles (descriptors)=0

Information in this record is only valid at the time when this file was
Created (see this record 's time stamp)

The 2017-02-17-18.53.22.212495 + 480 I1312E401 LEVEL: the Event
PID: 16527 dar: 140735126765568 proc: db2start
INSTANCE: db2inst1 NODE: 000
The HOSTNAME: zhoupindeMac - mini. Local
FUNCTION: DB2 UDB, base sys utilities, sqleGetStStLockFile, the probe: 12741
MESSAGE: Obtained exclusive mode the lock on the file:
DATA # 1: String, 40 bytes
/Users/db2inst1/sqllib/CTRL/db2strst LCK

The 2017-02-17-18.53.22.213792 + 480 I1714E1672 LEVEL: the Event
PID: 16527 dar: 140735126765568 proc: db2start
INSTANCE: db2inst1 NODE: 000
The HOSTNAME: zhoupindeMac - mini. Local
FUNCTION: DB2 UDB, base sys utilities, sqleStartStopSingleNode, the probe: 1130
DATA # 1: String, 35 bytes
/Users/db2inst1/sqllib/adm/db2star2
DATA # 2: the Hexdump), 256 bytes
7365, 7273, 2 0 x00007fff5fbed010:2 f55 f64 6232 696 e, 7374, 312 f/Users/db2inst1/
0 x00007fff5fbed020:7371 6 6962 f61 646 d 2 c6c f64 6232 7374 sqllib/adm/db2st
0 x00007fff5fbed030:6172 3200 0000 0000 0000 0000 0000 0000 ar2...
0 x00007fff5fbed040:0000 0000 0000 0000 0000 0000 0000 0000...
0 x00007fff5fbed050:0000 0000 0000 0000 0000 0000 0000 0000...
0 x00007fff5fbed060:0000 0000 0000 0000 0000 0000 0000 0000...
0 x00007fff5fbed070:0000 0000 0000 0000 0000 0000 0000 0000...
0 x00007fff5fbed080:0000 0000 0000 0000 0000 0000 0000 0000...
0 x00007fff5fbed090:0000 0000 0000 0000 0000 0000 0000 0000...
0 x00007fff5fbed0a0:0000 0000 0000 0000 0000 0000 0000 0000...
0 x00007fff5fbed0b0:0000 0000 0000 0000 0000 0000 0000 0000...
0 x00007fff5fbed0c0:0000 0000 0000 0000 0000 0000 0000 0000...
0 x00007fff5fbed0d0:0000 0000 0000 0000 0000 0000 0000 0000...
0 x00007fff5fbed0e0:0000 0000 0000 0000 0000 0000 0000 0000...
0 x00007fff5fbed0f0:0000 0000 0000 0000 0000 0000 0000 0000...
0 x00007fff5fbed100:0000 0000 0000 0000 0000 0000 0000 0000...

The 2017-02-17-18.53.22.260836 + 480 I3387E401 LEVEL: the Event
PID: 16529 dar: 140735126765568 proc: db2star2
INSTANCE: db2inst1 NODE: 000
The HOSTNAME: zhoupindeMac - mini. Local
FUNCTION: DB2 UDB, base sys utilities, sqleGetStStLockFile, the probe: 12741
MESSAGE: Obtained exclusive mode the lock on the file:
DATA # 1: String, 40 bytes
/Users/db2inst1/sqllib/CTRL/db2stst 0000
WARNING: Switching back to savedE3789E1419 uid in ossSetAnyEUID inside the function "openLogFile" failed with the error: (db2diag - rc 0 x90000001)
EUID before switch: "0", RUID before switch: "501"
EUID after switch: "501", RUID after switch: "501"

The 2017-02-17-18.53.22.345008 + 480 LEVEL: the Event
PID: 16531 dar: 4515459072 PROC: db2sysc
INSTANCE: db2inst1 NODE: 000
The HOSTNAME: zhoupindeMac - mini. Local
FUNCTION: DB2 UDB, base sys utilities, DB2main, the probe: 1
START: DB2 DBM
nullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnull
  •  Tags:  
  • DB2
  • Related