Symptom
db2start
02/09/2024 15:43:13 0 0 SQL1042C An unexpected system error occurred.
SQL1032N No start database manager command was issued. SQLSTATE=57019
Checking the db2diag.log the above errors are also accompanied with error SQL1641N:
2024-02-12-11.19.09.359749+060 I334524E546 LEVEL: Event
PID : 8754 TID : 139927971780416 PROC : db2star2
INSTANCE: db2px3 NODE : 000
HOSTNAME: alipx3ci1s
FUNCTION: DB2 UDB, base sys utilities, DB2StartMain, probe:7667
MESSAGE : ZRC=0xFFFFF997=-1641
SQL1641N The db2start command failed because one or more database
manager program files was prevented from executing with root
privileges by file system mount settings.
DATA #1 : <preformatted>
Db2StartMain:: sqlcode=0
2024-02-12-11.19.09.367505+060 I337191E1268 LEVEL: Event
PID : 8752 TID : 140418658924352 PROC : db2start
INSTANCE: db2px3 NODE : 000
HOSTNAME: alipx3ci1s
FUNCTION: DB2 UDB, base sys utilities, sqleIssueStartStop, probe:11958
DATA #1 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes
sqlcaid : SQLCA sqlcabc: 136 sqlcode: 0 sqlerrml: 0
sqlerrmc:
sqlerrp : SQL11014
sqlerrd : (1) 0x00000000 (2) 0x00000000 (3) 0x00000000
(4) 0x00000000 (5) 0x00000000 (6) 0x00000000
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate:
DATA #2 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes
sqlcaid : SQLCA sqlcabc: 136 sqlcode: -1032 sqlerrml: 0
sqlerrmc:
sqlerrp : SQLEPFIN
sqlerrd : (1) 0x00000000 (2) 0x00000000 (3) 0x00000000
(4) 0x00000000 (5) 0x00000000 (6) 0x00000000
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
Read more...
Environment
- IBM DB2 LUW (DB6) any release
Product
Keywords
DB2 , DB2START , SQL1042C , SQL1032N , SQL1641N , nosuid , KBA , BC-DB-DB6-DBA , Database Administration , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.