This portal is to open public enhancement requests against products and services offered by the IBM Data & AI organization. To view all of your ideas submitted to IBM, create and manage groups of Ideas, or create an idea explicitly set to be either visible by all (public) or visible only to you and IBM (private), use the IBM Unified Ideas Portal (https://ideas.ibm.com).
Shape the future of IBM!
We invite you to shape the future of IBM, including product roadmaps, by submitting ideas that matter to you the most. Here's how it works:
Search existing ideas
Start by searching and reviewing ideas and requests to enhance a product or service. Take a look at ideas others have posted, and add a comment, vote, or subscribe to updateson them if they matter to you. If you can't find what you are looking for,
Post your ideas
Post ideas and requests to enhance a product or service. Take a look at ideas others have posted and upvote them if they matter to you,
Post an idea
Upvote ideas that matter most to you
Get feedback from the IBM team to refine your idea
Specific links you will want to bookmark for future use
DB2 Pacemaker upgrade break cluster when Red Hat Satellite is not accessible
My idea is to add some check if Red Hat satellite is visible into db2installPCMK because if it's not, update will break cluster and DB2 will be unusable until visibility is fixed and db2installPCMK is executed again. As workaround you should before every PM update run some dnf test command (e.g. dnf whatprovides ksh). I've opened PMR for it, but I've got recommendation to open Idea as well.
Below you can see my findings:
My goal was to do manual update of pacemaker from 184.108.40.206 to 220.127.116.11 by db2installPCMK -i , which I run successfully on one node of cluster but failed on second due to lost visibility to satellite.
Errors during downloading metadata for repository 'kt-bootstrap':
- Status code: 404 for https://xxxxx.xxxx.xxx.net:8443/bootstrap/8/ppc64le/repodata/repomd.xml (IP: xx.xx.xx.xx)
Error: Failed to download metadata for repo 'kt-bootstrap': Cannot download repomd.xml: Cannot download repodata/repomd.xml: All mirrors were tried
DBI1065E Program db2installPCMK terminated prematurely.
An error has occurred during the execution and that has caused this program to terminate prematurely.
Correct the problem and try the command again.
5. db2installPCMK log file
[root@db2lop4 tmp]# cat db2installPCMK.log.3538264 Pacemaker 2.0.5-10.db2pcmk.el8 Written by Andrew Beekhof Pacemaker version in the media: 18.104.22.168\n Corosync version in the media: 22.214.171.124\n 126.96.36.199 188.8.131.52 Updating Subscription Management repositories. Subscription-manager dependencies for katello-c 23 kB/s | 1.5 kB 00:00 [root@db2lop4 tmp]#
I understand, that problem is on OS side, when PM has problem to reach satellite, because also commands like dnf are failing with same error. However, this update failure shot down db2 instance, which cannot be manually started again, same as PM cluster:
[root@db2lop4 ~]# systemctl start pacemaker [root@db2lop4 ~]# crm status Could not connect to the CIB: Transport endpoint is not connected crm_mon: Error: cluster is not available on this node ERROR: status: crm_mon (rc=102): [root@db2lop4 ~]# [db2prod@db2lop4 ~]$ db2start 08/08/2023 11:30:35 0 0 SQL1042C An unexpected system error occurred. SQL1032N No start database manager command was issued. SQLSTATE=57019 [db2prod@db2lop4 ~]$
2023-08-08-184.108.40.206361+180 I261066691E455 LEVEL: Event PID : 2221528 TID : 140736009840240PROC : db2star2 INSTANCE: db2prod NODE : 000 HOSTNAME: db2lop4.tieto.com FUNCTION: DB2 UDB, base sys utilities, DB2StartMain, probe:7783 MESSAGE : ZRC=0xFFFFF973=-1677 SQL1677N DB2START or DB2STOP processing failed due to a DB2 cluster services error.
Even when I disable cluster via:
crm cluster disable
db2 instance still has:
Cluster manager = PACEMAKER
so manual start is not working. I believe drop of entire cluster configuration will help, but I don't want to do it.
Do not place IBM confidential, company confidential, or personal information into any field.