Original Message:
Sent: Wed May 29, 2024 01:51 PM
From: Jan Nelken
Subject: db2 constantly stopping
Fenced mode process encounters an OS error:
2024-05-27-10.42.10.441000-180 E38461730F471 LEVEL: Error (OS)
PID : 668 TID : 18400 PROC : db2fmp64.exe
INSTANCE: DB2 NODE : 000 DB : JMJSS
APPID : 10.0.0.4.53251.240527134958
HOSTNAME: serco
EDUID : 18400
FUNCTION: DB2 UDB, oper system services, sqloSSemClose, probe:20
MESSAGE : ZRC=0x83000006=-2097151994
CALLED : OS, -, CloseHandle
and terminates:
2024-05-27-10.42.10.451000-180 I38463702F551 LEVEL: Severe
PID : 668 TID : 18400 PROC : db2fmp64.exe
INSTANCE: DB2 NODE : 000 DB : JMJSS
APPID : 10.0.0.4.53251.240527134958
HOSTNAME: serco
EDUID : 18400
FUNCTION: DB2 UDB, trace services, sqlt_logerr_data (secondary logging function), probe:50
MESSAGE : Fenced mode process encountered an abnormal situation...terminating
DATA #1 : Hexdump, 4 bytes
0x0000006A29BEF6C0 : 0000 0000
Your best option is to open a problem with IBM Support.
OSERR : 6 "Identificador invßlido."
------------------------------
Jan Nelken
Original Message:
Sent: Wed May 29, 2024 10:14 AM
From: Ricardo Cândido de Oliveira
Subject: db2 constantly stopping
I had edited the file until the first stop, after removing it, I am sending the file with the timestamp of the trap file.
------------------------------
Ricardo Cândido de Oliveira
Original Message:
Sent: Tue May 28, 2024 06:33 AM
From: Jan Nelken
Subject: db2 constantly stopping
Last entry in your supplied db2diag.log of 36,998,996 bytes has timestamp: 2024-05-27-05.26.39.984000-180
As per your picture above db2diag.log was 41,446 kb and was last updated on 2024-05-27-11.42; there is also a trap file 668.18400.trap.bin created on 2024-05-27-10.42.
Can I see db2diag.log covering this timeframe of trap?
To analyze trap - if it is relevant - best way is to open a support ticket with IBM.
------------------------------
Jan Nelken
Original Message:
Sent: Mon May 27, 2024 03:20 PM
From: Ricardo Cândido de Oliveira
Subject: db2 constantly stopping
This REPODB database was created recently, after the start of the stops, I believe that this is not the cause because on other servers there is no such error in the log, but there is the problem of the stop. In any case, I gave the necessary permissions.
------------------------------
Ricardo Cândido de Oliveira
Original Message:
Sent: Mon May 27, 2024 01:10 PM
From: Jan Nelken
Subject: db2 constantly stopping
Your first problem:
2024-05-26-13.30.10.803000-180 I684207F461 LEVEL: Error
PID : 11744 TID : 7252 PROC : db2fmp64.exe
INSTANCE: DB2 NODE : 000 DB : REPODB
APPID : *LOCAL.DB2.240526164244
HOSTNAME: serco
EDUID : 7252
FUNCTION: DB2 UDB, Health Monitor, hmonCheck Authority, probe:600
DATA #1 : String, 51 bytes
User authorization ID does not have DBADM authority
DATA #2 : String, 8 bytes
DB2ADMIN
------------------------------
Jan Nelken
Original Message:
Sent: Mon May 27, 2024 10:48 AM
From: Ricardo Cândido de Oliveira
Subject: db2 constantly stopping
Hi Khalid,
The command output follows.
Thanks.
------------------------------
Ricardo Cândido de Oliveira
Original Message:
Sent: Fri May 24, 2024 05:05 PM
From: Khalid Qrines
Subject: db2 constantly stopping
I see there are a lot of default values which is not good, but I'm not sure if this will relate to your issue or not.
But do you "implicitly" activate your database before connecting to the database, because if you don't where there are no connections db2 will deactivate itself. Activating the database will ensure the database up and running always even if there is no connection.
Can you share the output of the following
db2 get snapshot for db on <dbname>
Thanks ..
Khalid
------------------------------
Khalid Qrines
Original Message:
Sent: Fri May 24, 2024 03:42 PM
From: Ricardo Cândido de Oliveira
Subject: db2 constantly stopping
Of course, no problem, output attached.
------------------------------
Ricardo Cândido de Oliveira
Original Message:
Sent: Fri May 24, 2024 03:12 PM
From: Khalid Qrines
Subject: db2 constantly stopping
Can you please share the output of below commands
db2pd -
db2 get db cfg
db2 get dbm cfg
------------------------------
Khalid Qrines
Original Message:
Sent: Fri May 24, 2024 12:56 PM
From: Ricardo Cândido de Oliveira
Subject: db2 constantly stopping
Hi,
Yes, the instance is running with user DB2ADMIN, he is in the administrators and db2admns group, I believe it is not a problem with the user as the instance goes up without problems, but it works for 10 or 20 minutes, 1 or 2 hours or even all day without stopping .
I don't have a cluster configured.
There is one more detail that I didn't mention, users connect via RDP to the server to use the system, I don't know if it helps anything.
Anyway, yesterday it started happening to users who don't use the server directly, they use it on their local network machine.
Thanks.
------------------------------
Ricardo Cândido de Oliveira
Original Message:
Sent: Fri May 24, 2024 07:37 AM
From: Khalid Qrines
Subject: db2 constantly stopping
Hello,
Just for the record, some group policy (GPO) denied local users from running a service. I prefer always to use AD user if the server is joined to domain.
My points just make sure the user who is running the instance is added in administrator group and db2admns group.
Is there any cluster configured? (HADR, FCI) if so try to failover to start the instance from the other node.
Thanks
Khalid ..
------------------------------
Khalid Qrines
Original Message:
Sent: Fri May 24, 2024 03:32 AM
From: Miguel Sanjurjo
Subject: db2 constantly stopping
Ricardo,
is DB2ADMIN a local user or an AD-User?
If an AD-User, try using a local user
------------------------------
Miguel Sanjurjo
Original Message:
Sent: Wed May 22, 2024 01:52 PM
From: Ricardo Cândido de Oliveira
Subject: db2 constantly stopping
Hi
Thank you for the feedback, the service user is the DB2ADMIN, anyway I changed it to a full admin user, even so the error event is still in the log and the service stopping, would you have any other ideas?
Thanks.
------------------------------
Ricardo Cândido de Oliveira
Original Message:
Sent: Tue May 21, 2024 11:30 AM
From: Ricardo Cândido de Oliveira
Subject: db2 constantly stopping
Good afternoon,
Sorry for the English, I'm Brazilian.
I have a dataflex application using IBM DB2 Version 11.5.6 (updated yesterday to 11.5.9), I am trying several daily stops of the database, this is happening on more than one client and different servers, I can't find anything in the db2diag .log Give me some guidance, could you help me, I'm sending 30 minutes of log from one DB point to another.
Thanks
------------------------------
Ricardo Cândido de Oliveira
------------------------------