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.
SAP Knowledge Base Article - Preview