I am trying to user the command db2star in my new DB2 Express instance and I receive:
SQL1042C An unexpected system error occurred.
Looking at db2diag.log I got:
2015-10-14-23.31.46.395310-180 I87772E394 LEVEL: Warning
PID : 1980 TID : 140735278235648PROC : db2start
INSTANCE: db2inst1 NODE : 000
HOSTNAME: Renatos-MacBook-Pro.local
FUNCTION: DB2 UDB, base sys utilities, sqleReleaseStStLockFile, probe:12463
MESSAGE : Released lock on the file:
DATA #1 : String, 40 bytes
/Users/db2inst1/sqllib/ctrl/db2strst.lck
I installed DB2 express in my MAC Machine (OSX El Captain) using the following guide:
Solved. Just run:
where "db2inst1" is your DB2 user.
A more up-to-date for Installing DB2 on Mac OS El Capitan is available.
This is the crucial step:
Enable OS authentication. (You need to be an admin user to run these commands):
I'm also using DB2 V10.1 on my mac. I have used it since mac OS 10.6 snow leopard. And I encountered same situation recently and resolved with the same way that Renato tried. Just sharing the capture from my dirty note.
db2diag.log
After doing
I could do 'db2start' successfully.