Skip to content

db2start throws SQL1042C An unexpected system error occurred. #23

@RekhaDS

Description

@RekhaDS

Trying to deploy on Mac (macOS High Sierra)

Created a /db2 folder on the host, added /db2 mount point via Docker - Preferences

Ran the following -
docker run -i -t --privileged=true --name="db2inst1" -p 50000:50000 -v /db2:/home angoca/db2-instance

./createInstance
su - db2inst1
. ~db2inst1/sqllib/db2profile
su - db2inst1

db2inst1@ace6e0af1103:~$ db2start
SQL1042C An unexpected system error occurred.

db2 diag log shows -

2017-12-13-19.41.42.838165+000 E7247E1026 LEVEL: Error (OS)
PID : 7930 TID : 140601058523008 PROC : db2star2
INSTANCE: db2inst1 NODE : 000
HOSTNAME: ace6e0af1103
FUNCTION: DB2 UDB, oper system services, sqloopenp, probe:80
MESSAGE : ZRC=0x870F0002=-2029060094=SQLO_BPSE "Debug logic error detected"
DIA8501C A buffer pool logic error has occurred.
CALLED : OS, -, open OSERR: EINVAL (22)
DATA #1 : Codepath, 8 bytes
5:11:18:20:24:40
DATA #2 : File name, 55 bytes
/home/db2inst1/sqllib/ctrlha/.db2.000.ace6e0af1103.pgrp
DATA #3 : SQO Open File Options, PD_TYPE_SQO_FILE_OPEN_OPTIONS, 4 bytes
SQLO_CRTREV, SQLO_READWRITE, SQLO_SHAREWRITE, SQLO_FORCE_NON_BUFFERED, SQLO_WRITETHRU, SQLO_SECURE
DATA #4 : Hex integer, 4 bytes
0x000001B4
DATA #5 : signed integer, 4 bytes
0
DATA #6 : Hex integer, 4 bytes
0x00004000
DATA #7 : String, 105 bytes
Search for ossError*Analysis probe point after this log entry for further
self-diagnosis of this problem.

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions