0

Db2 11.1.4.6, AIX, 2 members + 2 CFs.

Db2 pureScale CF is periodically restarted with the following message in the CF's db2diag.log:

                                                    LEVEL: Warning
PID     : xxx                  TID : 1              PROC : db2rocme 128 [db2sdin1]
INSTANCE: db2sdin1             NODE : 128
HOSTNAME: cf128
EDUID   : 1                    EDUNAME: db2rocme 128 [db2sdin1]
FUNCTION: DB2 UDB, high avail services, rocmCAKillProcesses, probe:4299
MESSAGE : CF process group file read but process group IDs are invalid -
          attempting to force stop.
DATA #1 : Codepath, 8 bytes
1:7:16

I have the following, for example, when it works normally:

# ps -ef -o pid,ppid,pgid,args | grep -v grep | grep db2
 8454558        1  8388876 ca-wdog 128 [db2sdin1]
15401326 17891750  8388876 /home/db2sdin1/sqllib/cf/ca-server -i 128 -p 56000 -k 333448195 -s 0 -r 131073031 -f
17891750  8454558  8388876 ca-mgmnt-lwd -i128 -p56000 -ke32e317a -d/home/db2sdin1/sqllib/db2dump/DIAG0128 -e/home/db2sdin1/sqllib/cf/ca-server -f

What's the problem and how to resole it?

7
  • Have you noticed anything weird with the process group id when it happens? Commented May 10, 2023 at 9:58
  • I even don't have any idea what is normal or what is weird with this. It's not clear from this message what's the "problematic" process which process group is invalid. I've edited the question to show the "normal" situation... Commented May 10, 2023 at 13:30
  • What (third party) packages are running on the same lpar as the cf? Anything in the AIX system message log immediately before the timestamp of the cf restarting? Presumably you already opened a ticket with ibm db2 support?
    – mao
    Commented May 10, 2023 at 14:02
  • Nothing third party is running that would change a db2 process group id. Nothing appears in the AIX syslog. Commented May 12, 2023 at 18:10
  • Is it LDAP that is managing the users/groups for both CFs, or what is it that keeps them in sync?
    – mao
    Commented May 14, 2023 at 20:21

0

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Browse other questions tagged or ask your own question.