Db2

Db2

Where DBAs and data experts come together to stop operating and start innovating. Connect, share, and shape the AI era with us.


#Data


#Data
#Databases
#Operatingsystems
#Db2
#Databasesolutions
 View Only
  • 1.  pacemaker vip

    Posted 05/03/23 06:56 AM

    pacemaker was setup on db2 linux 11.5.8
    now trying to add the vip and according the doc 
    [root@pacemkrp ~]# /home/db2ins11/sqllib/adm/db2cm -create -primaryVIP 192.168.44.129 -db QUERYDB -instance db2ins11

    this command is accepted - does not return/ends and no error presented
    looking at second node : crm status - the resource is not present/defined
    is there any logging about db2cm and where to  find



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


  • 2.  RE: pacemaker vip

    Posted 05/04/23 09:36 AM

    Hello Guy,

    When you run:

    /opt/ibm/db2/V11.5/bin/db2cm -list

    Do you see the resource there?
    By default, I have logged events in these files:

    /var/log/crmsh/crmsh.log
    /var/log/pacemaker/pacemaker.log

    Hope this helps.

    Regards
    Ondrej



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



  • 3.  RE: pacemaker vip

    Posted 05/05/23 02:22 AM

    Hello Guy,

    the logs of db2cm reside in the /tmp directory.

    Hopefully the respective log can give you more information why the creation of the VIP does not end.

    Kind regards, Hans-Jürgen



    ------------------------------
    Hans-Juergen Zeltwanger
    ------------------------------