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.  DB2 Purescale installation in AIX

    Posted 01/28/25 10:05 AM

    Hi, 

    I was trying to install db2 11.5.9 on AIX server with Purescale feature. 
    Upon reaching the point of creating a instance, i encountered a issue where the precheck was throwing a error on /etc/hosts file. 

    Validating "/etc/hosts" ...
    DBT3616E  The db2prereqcheck utility found that the /etc/hosts file does not match the expected format:
            LINE  57: IPADDRESS0         hop10hmc_BMC
            LINE  58: IPADDRESS1         hop10hmc_BMC...
            LINE  63: IPADDRESS2         hop10fs5300_...
            LINE  64: IPADDRESS3         hop10fs5300_...
           
    Ensure that each entry in the /etc/hosts file begins with a valid IP address, followed by a valid full hostname and
    matching short alias for standard IPv4 addresses, or any number of valid hostnames for loopback and IPv6 addresses.
       ERROR : Requirement not matched.

    As mentioned in the error i had checked on /etc/hosts file and it to have only 
    <IP_Address>  <short_name>,
    and  <fully_qualified_name>  is missing, 

    When checked with AIX admin team, they said they do not have this in the environment.
    how we can proceed in the instance creation, how can this be resolved without having <fully_qualified_name> 
    Please let me know, any kind of help is appreciated. 

    With regards,
    Rebin



    ------------------------------
    rebin varkey
    ------------------------------


  • 2.  RE: DB2 Purescale installation in AIX

    Posted 01/28/25 11:20 AM

    Please check:

    https://www.ibm.com/docs/en/db2/11.5?topic=crna-configuring-network-settings-hosts-roce-network-ip-support-aix

    An example of hosts:

     10.1.1.1       cf1-en1.example.com cf1-en1
 10.1.2.1       cf1-en2.example.com cf1-en2
 10.1.3.1       cf1-en3.example.com cf1-en3
 10.1.4.1       cf1-en4.example.com cf1-en4
 10.1.1.2       cf2-en1.example.com cf2-en1
 10.1.2.2       cf2-en2.example.com cf2-en2
 10.1.3.2       cf2-en3.example.com cf2-en3
 10.1.4.2       cf2-en4.example.com cf2-en4
 10.1.1.3       member1-en1.example.com member1-en1
 10.1.2.3       member1-en2.example.com member1-en2
 10.1.1.4       member2-en1.example.com member2-en1
 10.1.2.4       member2-en2.example.com member2-en2
 10.1.1.5       member3-en1.example.com member3-en1
 10.1.2.5       member3-en2.example.com member3-en2
 10.1.1.6       member4-en1.example.com member4-en1
 10.1.2.6       member4-en2.example.com member4-en2


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



  • 3.  RE: DB2 Purescale installation in AIX

    Posted 01/29/25 02:58 AM

    Hi Jan,

    In this Environment they do not have a <fully_qualified_name>  as mentioned in the Document. 
    But they claim that they have a working existing environment in that manner.   
    I also was skeptical on that point. 

    Is there any possibility for such a environment to exist , is this format in /etc/hosts file <IP_Address> <fully_qualified_name> <short_name>, a new check in latest DB2 product ? 



    ------------------------------
    rebin varkey
    ------------------------------

    Original Message


  • 4.  RE: DB2 Purescale installation in AIX

    Posted 01/30/25 11:54 AM

    Hi Rebin, 

    In pureScale environment, the /etc/hosts file must have this format: <IP_Address> <fully_qualified_name> <short_name>. All hosts in the cluster must have the same /etc/hosts format. This is mandatory requirement for pureScale enviroment. We added this check in db2prereqcheck starting V11.5.6.0 to validate the /etc/hosts format. Before version V11.5.6.0, customers encountered issues when they didn't follow the correct format. As a result, we added a check in db2prereqcheck starting with version V11.5.6.0.

    best regards,
    Vicki



    ------------------------------
    Vicki Chen
    ------------------------------

    Original Message


  • 5.  RE: DB2 Purescale installation in AIX

    Posted 01/30/25 11:54 AM
     
    Hi Rebin, 
     
    In pureScale environment, the /etc/hosts file must have this format: <IP_Address> <fully_qualified_name> <short_name>. All hosts in the cluster must have the same /etc/hosts format. Starting with version 11.5.6.0, we introduced a check in db2prereqcheck because, prior v11.5.6.0, we see customers encountered issues when the correct format was not followed.
     
     
    best regards,
    Vicki


    ------------------------------
    Vicki Chen
    ------------------------------

    Original Message


  • 6.  RE: DB2 Purescale installation in AIX

    Posted 01/30/25 11:54 AM
    Hi Rebin, 
     
    In pureScale environment, the /etc/hosts file must have this format: <IP_Address> <fully_qualified_name> <short_name>. All hosts in the cluster must have the same /etc/hosts format. Starting with version 11.5.6.0, we introduced a check in db2prereqcheck because, prior v11.5.6.0, we see customers encountered issues when the correct format was not followed.
     
     
    best regards,
    Vicki



    ------------------------------
    Vicki Chen
    ------------------------------

    Original Message


Related Content