Just follow link and watch linked video [ complete advance level hadr setup step by step]. Hope it will resolve your issues after watch described link video

https://community.ibm.com/community/user/datamanagement/discussion/port-and-hadr#bme1080b6b-5e8d-43cd-9c92-ba1787628d1a

thanks for the comment

but the problem has nothing todo with db2 cfg/setup.  this was done correctly

db2 is complaining about O/S error and get socket....

as the system person does not know what is wrong, I posted this question. maybe someone has seen this before and a hint could help to resolve

small remark : Just follow link ....     the link is pointing to this entry and not to the video.

Just follow link and watch linked video [ complete advance level hadr setup step by step]. Hope it will resolve your issues after watch described link video

https://community.ibm.com/community/user/datamanagement/discussion/port-and-hadr#bme1080b6b-5e8d-43cd-9c92-ba1787628d1a

t looks like there's an error in your DB2 database system. The error message indicates an access denied issue when trying to perform a socket-related operation (getsockopt). Here's a breakdown of the information provided:

• Error Code (ZRC): 0x840F0001=-2079391743=SQLO_ACCD

  • This code corresponds to an access denied error in the DB2 system.

• Message: DIA8701C Access denied for resource "", operating system return code was "".

  • The system is reporting an access denied situation. It seems that the resource is not specified in the error message ("").

• Operating System Error (OSERR): EACCES (13)

  • The operating system returned an error code indicating permission denied. In this case, the permission issue is denoted by the error code 13, which is EACCES.

• Context Information:

  • PID: Process ID of the application encountering the error (db2sysc with PID 10565).
  • INSTANCE: Database instance (dbadma).
  • NODE: Node number (000).
  • DB: Database name (ACC1).
  • HOSTNAME: Hostname of the machine (uhdb2accdr.uhasselt.be).
  • EDUID: Execution Unit ID.
  • EDUNAME: Execution Unit Name (db2hadrs.0.0 (ACC1) 0).
  • FUNCTION: The function in the DB2 UDB code where the error occurred (sqloPdbQuerySocketErrorStatus).
  • PROBE: A specific point in the code where the error was detected (probe:15).

Action Steps:

1. Review the access permissions for the resource mentioned in the error message.
2. Check the operating system logs for additional information on why the access is denied.
3. Verify the configuration settings related to the DB2 instance and ensure they are set correctly.
4. Consider checking if there are any recent changes in the system, such as security policy updates or changes in permissions.

thanks for the comment

but the problem has nothing todo with db2 cfg/setup.  this was done correctly

db2 is complaining about O/S error and get socket....

as the system person does not know what is wrong, I posted this question. maybe someone has seen this before and a hint could help to resolve

small remark : Just follow link ....     the link is pointing to this entry and not to the video.

Just follow link and watch linked video [ complete advance level hadr setup step by step]. Hope it will resolve your issues after watch described link video

https://community.ibm.com/community/user/datamanagement/discussion/port-and-hadr#bme1080b6b-5e8d-43cd-9c92-ba1787628d1a

Hi,

A bit of an aside that probably will help ease the setup an eliminate an error point.  Set the hadr ports for send and receive to the same value.  There is no performance benefit in having different ports.  

t looks like there's an error in your DB2 database system. The error message indicates an access denied issue when trying to perform a socket-related operation (getsockopt). Here's a breakdown of the information provided:

• Error Code (ZRC): 0x840F0001=-2079391743=SQLO_ACCD

  • This code corresponds to an access denied error in the DB2 system.

• Message: DIA8701C Access denied for resource "", operating system return code was "".

  • The system is reporting an access denied situation. It seems that the resource is not specified in the error message ("").

• Operating System Error (OSERR): EACCES (13)

  • The operating system returned an error code indicating permission denied. In this case, the permission issue is denoted by the error code 13, which is EACCES.

• Context Information:

  • PID: Process ID of the application encountering the error (db2sysc with PID 10565).
  • INSTANCE: Database instance (dbadma).
  • NODE: Node number (000).
  • DB: Database name (ACC1).
  • HOSTNAME: Hostname of the machine (uhdb2accdr.uhasselt.be).
  • EDUID: Execution Unit ID.
  • EDUNAME: Execution Unit Name (db2hadrs.0.0 (ACC1) 0).
  • FUNCTION: The function in the DB2 UDB code where the error occurred (sqloPdbQuerySocketErrorStatus).
  • PROBE: A specific point in the code where the error was detected (probe:15).

Action Steps:

1. Review the access permissions for the resource mentioned in the error message.
2. Check the operating system logs for additional information on why the access is denied.
3. Verify the configuration settings related to the DB2 instance and ensure they are set correctly.
4. Consider checking if there are any recent changes in the system, such as security policy updates or changes in permissions.

thanks for the comment

but the problem has nothing todo with db2 cfg/setup.  this was done correctly

db2 is complaining about O/S error and get socket....

as the system person does not know what is wrong, I posted this question. maybe someone has seen this before and a hint could help to resolve

small remark : Just follow link ....     the link is pointing to this entry and not to the video.

Just follow link and watch linked video [ complete advance level hadr setup step by step]. Hope it will resolve your issues after watch described link video

https://community.ibm.com/community/user/datamanagement/discussion/port-and-hadr#bme1080b6b-5e8d-43cd-9c92-ba1787628d1a

thanks for the comment

but the problem has nothing todo with db2 cfg/setup.  this was done correctly

db2 is complaining about O/S error and get socket....

as the system person does not know what is wrong, I posted this question. maybe someone has seen this before and a hint could help to resolve

small remark : Just follow link ....     the link is pointing to this entry and not to the video.

Just follow link and watch linked video [ complete advance level hadr setup step by step]. Hope it will resolve your issues after watch described link video

https://community.ibm.com/community/user/datamanagement/discussion/port-and-hadr#bme1080b6b-5e8d-43cd-9c92-ba1787628d1a

I understand that you are facing problem. Now do the following steps:

1. stop firewall and disable it.

[root@~] iptables-save -F

[root@~] iptables-save -X

[root@~] iptables-save -t nat -X

[root@~] systemctl stop iptables ................. or [root@~] systemctl stop firewalld

[root@~] systemctl disable iptables .............. or [root@~] systemctl disable firewalld

2. update /etc/services in both nodes [ primary and secondary]

For example: 

db2_hadr_primises       50064/tcp
db2_hadr_drsite            50070/tcp

----------------------------------------------------------------------------------------------------------------------------------------

primary node: db2_hadr_primises

secondary node: db2_hadr_drsite

# sudo su - db2inst1

[db2inst1@~] db2 update db cfg for acc1 using HADR_LOCAL_SVC db2_hadr_primises

[db2inst1@~] db2 update db cfg for acc1 using HADR_REMOTE_SVC db2_hadr_drsite

..........................

Restart db2

Take new session for monitoring via putty., if you are familiar if windows desktop

[root@~] updatedb; locate db2diag.log

[root@~] sudo su - db2inst

[db2inst1@~] tail -f  /home/db2inst1/sqllib/db2dump/db2diag.log

Do aforesaid mentioned steps and update us asp.

thanks for the comment

but the problem has nothing todo with db2 cfg/setup.  this was done correctly

db2 is complaining about O/S error and get socket....

as the system person does not know what is wrong, I posted this question. maybe someone has seen this before and a hint could help to resolve

small remark : Just follow link ....     the link is pointing to this entry and not to the video.

Just follow link and watch linked video [ complete advance level hadr setup step by step]. Hope it will resolve your issues after watch described link video

https://community.ibm.com/community/user/datamanagement/discussion/port-and-hadr#bme1080b6b-5e8d-43cd-9c92-ba1787628d1a

i do not see why adding an additional translation, by using /etc/services instead of hardcoded hadr svc would resolve the problem

I anyhow tested it and the problem remains the same as expected

I understand that you are facing problem. Now do the following steps:

1. stop firewall and disable it.

[root@~] iptables-save -F

[root@~] iptables-save -X

[root@~] iptables-save -t nat -X

[root@~] systemctl stop iptables ................. or [root@~] systemctl stop firewalld

[root@~] systemctl disable iptables .............. or [root@~] systemctl disable firewalld

2. update /etc/services in both nodes [ primary and secondary]

For example: 

db2_hadr_primises       50064/tcp
db2_hadr_drsite            50070/tcp

----------------------------------------------------------------------------------------------------------------------------------------

primary node: db2_hadr_primises

secondary node: db2_hadr_drsite

# sudo su - db2inst1

[db2inst1@~] db2 update db cfg for acc1 using HADR_LOCAL_SVC db2_hadr_primises

[db2inst1@~] db2 update db cfg for acc1 using HADR_REMOTE_SVC db2_hadr_drsite

..........................

Restart db2

Take new session for monitoring via putty., if you are familiar if windows desktop

[root@~] updatedb; locate db2diag.log

[root@~] sudo su - db2inst

[db2inst1@~] tail -f  /home/db2inst1/sqllib/db2dump/db2diag.log

Do aforesaid mentioned steps and update us asp.

thanks for the comment

but the problem has nothing todo with db2 cfg/setup.  this was done correctly

db2 is complaining about O/S error and get socket....

as the system person does not know what is wrong, I posted this question. maybe someone has seen this before and a hint could help to resolve

small remark : Just follow link ....     the link is pointing to this entry and not to the video.

Just follow link and watch linked video [ complete advance level hadr setup step by step]. Hope it will resolve your issues after watch described link video

https://community.ibm.com/community/user/datamanagement/discussion/port-and-hadr#bme1080b6b-5e8d-43cd-9c92-ba1787628d1a

Hello Guy,

Sorry if you already solved the issue, but what about Selinux? What mode is it in? Permissive? Enforcing?

no problem, any answer is welcome

I also tried hadr simulator and we get msg : no route to host, although we can ping both servers

I informed system people about it, they say : we did not change anything..   but now the problem is resolved. I do not know the cause

now also started hadr and all worked.

many thanks for all comments/help

------------------------------
Thanks for all answers
Best Regards,
Guy Przytula
------------------------------


Original Message:
Sent: Wed January 10, 2024 02:01 AM
From: Ondřej Žižka
Subject: port and hadr

Hello Guy,

Sorry if you already solved the issue, but what about Selinux? What mode is it in? Permissive? Enforcing?

------------------------------
Ondřej Žižka

"they say : we did not change anything..."

This should trigger all alarms.

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


Original Message:
Sent: Wed January 10, 2024 03:27 AM
From: Guy Przytula
Subject: port and hadr

no problem, any answer is welcome

I also tried hadr simulator and we get msg : no route to host, although we can ping both servers

I informed system people about it, they say : we did not change anything..   but now the problem is resolved. I do not know the cause

now also started hadr and all worked.

many thanks for all comments/help

------------------------------
Thanks for all answers
Best Regards,
Guy Przytula


Original Message:
Sent: Wed January 10, 2024 02:01 AM
From: Ondřej Žižka
Subject: port and hadr

Hello Guy,

Sorry if you already solved the issue, but what about Selinux? What mode is it in? Permissive? Enforcing?

------------------------------
Ondřej Žižka