Db2

Your first problem to be addressed is OS error:

2024-05-21-09.55.54.138000-180 E117726182F599       LEVEL: Error (OS)PID     : 26836                TID : 32460          PROC : db2syscs.exeINSTANCE: DB2                  NODE : 000           DB   : JMJSSAPPHDL  : 0-3235               APPID: *LOCAL.DB2.240521132540AUTHID  : ADMINISTRADOR        HOSTNAME: sercoEDUID   : 32460                EDUNAME: db2agent (JMJSS) 0FUNCTION: DB2 UDB, oper system services, sqloAuthzGetInformationFromSid, probe:10MESSAGE : ZRC=0x83000057=-2097151913          CALLED  : OS, -, AuthzInitializeContextFromSidOSERR   : 87 "Parâ­¥tro incorreto."

------------------------------
Jan Nelken

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
------------------------------

Hi Ricardo,

if i translate the error message right, it says something wrong with parameters. Maybe Parameters of instance configuration. Maybe call of authentication Parameters.

First check

Try to connect from Db2cmdline

db2 connect to JMJAB

What is the error message?

You can provide a user id and a password with 

db2 connect to JMJAB user <your_user> using <user_pwd>

What is the error message in both cases?

Next step

There is a thread discussing a similar issue

DB2 log file error: SQL1092N "USERID does not have the authority to perform the requested command or operation"

.

Check your instance configuration first

db2 get dbm cfg 

• What is in SYSIBM_GROUP     ->?
• What groups are in your windows environment?
• Is this group there? Is the db2admin part of the group?
  Do you work with any central authentication system like windows active directory?

Group names matches and for server purposes the authentication is local?

If not change by 

• adding a group in windows with admin rights
• add db2admin to it
• add same group to db2 instance

If Everything is right there and system still didn't work. 

Next step 

Check db2set parameters with 

Try the following Parameter

Restart instance

Check db2diag.log message after firstconnect

 failure sample here  The error after FirstConnect should disappear

2024-05-21-09.31.57.849000-180 E114025009F509       LEVEL: EventPID     : 26836                TID : 26208          PROC : db2syscs.exeINSTANCE: DB2                  NODE : 000           DB   : JMJABAPPHDL  : 0-26                 APPID: 10.0.0.4.58599.240521123211AUTHID  : SERCO                HOSTNAME: sercoEDUID   : 26208                EDUNAME: db2agent (JMJAB) 0FUNCTION: DB2 UDB, base sys utilities, sqeLocalDatabase::FirstConnect, probe:1000START   : DATABASE: JMJAB    : ACTIVATED: NO2024-05-21-09.31.57.943000-180 E114025520F599       LEVEL: Error (OS)PID     : 26836                TID : 17944          PROC : db2syscs.exeINSTANCE: DB2                  NODE : 000           DB   : JMJABAPPHDL  : 0-27                 APPID: *LOCAL.DB2.240521123212AUTHID  : SERCO                HOSTNAME: sercoEDUID   : 17944                EDUNAME: db2agent (JMJAB) 0FUNCTION: DB2 UDB, oper system services, sqloAuthzGetInformationFromSid, probe:10MESSAGE : ZRC=0x83000057=-2097151913
CALLED  : OS, -, AuthzInitializeContextFromSidOSERR   : 87 "Parâ­¥tro incorreto."

• • Does it work? If not reset by using
    • db2set DB2_GRP_LOOKUP=

If above isn't working you have to investigate more
What has changed ?

• Only Db2 version or
• Operating system or
• Security environment

There are more threads outside,but we have to know in which direction we investigate .

-------------------------------------
Kind regards
Joachim Stumpf

Original Message:
Sent: Wed May 22, 2024 03:33 AM
From: Jan Nelken
Subject: db2 constantly stopping

Your first problem to be addressed is OS error:

2024-05-21-09.55.54.138000-180 E117726182F599       LEVEL: Error (OS)PID     : 26836                TID : 32460          PROC : db2syscs.exeINSTANCE: DB2                  NODE : 000           DB   : JMJSSAPPHDL  : 0-3235               APPID: *LOCAL.DB2.240521132540AUTHID  : ADMINISTRADOR        HOSTNAME: sercoEDUID   : 32460                EDUNAME: db2agent (JMJSS) 0FUNCTION: DB2 UDB, oper system services, sqloAuthzGetInformationFromSid, probe:10MESSAGE : ZRC=0x83000057=-2097151913          CALLED  : OS, -, AuthzInitializeContextFromSidOSERR   : 87 "Parâ­¥tro incorreto."

------------------------------
Jan Nelken

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
------------------------------

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.

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

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.

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,

is DB2ADMIN a local user or an AD-User?

If an AD-User, try using a local user

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.

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

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 ..

Ricardo,

is DB2ADMIN a local user or an AD-User?

If an AD-User, try using a local user

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.

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

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.

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 ..

Ricardo,

is DB2ADMIN a local user or an AD-User?

If an AD-User, try using a local user

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.

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

Can you please share the output of below commands

db2pd -

db2 get db cfg

db2 get dbm cfg

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.

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 ..

Ricardo,

is DB2ADMIN a local user or an AD-User?

If an AD-User, try using a local user

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.

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

Of course, no problem, output attached.

Can you please share the output of below commands

db2pd -

db2 get db cfg

db2 get dbm cfg

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.

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 ..

Ricardo,

is DB2ADMIN a local user or an AD-User?

If an AD-User, try using a local user

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.

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

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

Of course, no problem, output attached.

Can you please share the output of below commands

db2pd -

db2 get db cfg

db2 get dbm cfg

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.

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 ..

Ricardo,

is DB2ADMIN a local user or an AD-User?

If an AD-User, try using a local user

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.

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

If this is recurring event then I would suggest:

1. Clean diagnostic subdirectory with all subdirectories in it - you can find location of it like this (example from my laptop):

C:\>db2 get dbm cfg | grep -i diagpath
 Diagnostic data directory path               (DIAGPATH) = C:\PROGRAMDATA\IBM\DB2\DB2V115M9F0\DB2\ $m
 Current member resolved DIAGPATH                        = C:\PROGRAMDATA\IBM\DB2\DB2V115M9F0\DB2\DIAG0000\
 Alternate diagnostic data directory path (ALT_DIAGPATH) =
 Current member resolved ALT_DIAGPATH                    =

If you don't have grep for windows - use this command:

C:\>db2 get dbm cfg | find /i "diagpath"
 Diagnostic data directory path               (DIAGPATH) = C:\PROGRAMDATA\IBM\DB2\DB2V115M9F0\DB2\ $m
 Current member resolved DIAGPATH                        = C:\PROGRAMDATA\IBM\DB2\DB2V115M9F0\DB2\DIAG0000\
 Alternate diagnostic data directory path (ALT_DIAGPATH) =
 Current member resolved ALT_DIAGPATH                    =

2. Recreate one single occurrence of the "sudden stop"

3. Show us content of DB2DIAG location

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

Of course, no problem, output attached.

Can you please share the output of below commands

db2pd -

db2 get db cfg

db2 get dbm cfg

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.

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 ..

Ricardo,

is DB2ADMIN a local user or an AD-User?

If an AD-User, try using a local user

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.

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

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

Of course, no problem, output attached.

Can you please share the output of below commands

db2pd -

db2 get db cfg

db2 get dbm cfg

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.

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 ..

Ricardo,

is DB2ADMIN a local user or an AD-User?

If an AD-User, try using a local user

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.

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

Hi Khalid,

The command output follows.

Thanks.

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

Of course, no problem, output attached.

Can you please share the output of below commands

db2pd -

db2 get db cfg

db2 get dbm cfg

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.

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 ..

Ricardo,

is DB2ADMIN a local user or an AD-User?

If an AD-User, try using a local user

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.

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

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

Hi Khalid,

The command output follows.

Thanks.

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

Of course, no problem, output attached.

Can you please share the output of below commands

db2pd -

db2 get db cfg

db2 get dbm cfg

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.

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 ..

Ricardo,

is DB2ADMIN a local user or an AD-User?

If an AD-User, try using a local user

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.

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

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.

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

Hi Khalid,

The command output follows.

Thanks.

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

Of course, no problem, output attached.

Can you please share the output of below commands

db2pd -

db2 get db cfg

db2 get dbm cfg

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.

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 ..

Ricardo,

is DB2ADMIN a local user or an AD-User?

If an AD-User, try using a local user

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.

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

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.

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.

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

Hi Khalid,

The command output follows.

Thanks.

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

Of course, no problem, output attached.

Can you please share the output of below commands

db2pd -

db2 get db cfg

db2 get dbm cfg

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.

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 ..

Ricardo,

is DB2ADMIN a local user or an AD-User?

If an AD-User, try using a local user

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.

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

I had edited the file until the first stop, after removing it, I am sending the file with the timestamp of the trap file.

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.

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.

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

Hi Khalid,

The command output follows.

Thanks.

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

Of course, no problem, output attached.

Can you please share the output of below commands

db2pd -

db2 get db cfg

db2 get dbm cfg

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.

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 ..

Ricardo,

is DB2ADMIN a local user or an AD-User?

If an AD-User, try using a local user

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.

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

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."

I had edited the file until the first stop, after removing it, I am sending the file with the timestamp of the trap file.

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.

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.

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

Hi Khalid,

The command output follows.

Thanks.

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

Of course, no problem, output attached.

Can you please share the output of below commands

db2pd -

db2 get db cfg

db2 get dbm cfg

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.

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 ..

Ricardo,

is DB2ADMIN a local user or an AD-User?

If an AD-User, try using a local user

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.

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