Topic
  • 20 replies
  • Latest Post - ‏2014-11-27T06:59:33Z by sadravid
Miguel_Sanders
Miguel_Sanders
4 Posts

Pinned topic Registry Services DB2 install issue

‏2013-09-29T09:10:59Z |

Hi guys

When configuring the DB2 part of the registry services installation, I'm getting the following errors.

JazzSMInstall : TCP IP not configured

The DB2 instance is set up for TCP/IP communication properly (db2set DB2COMM=tcpip and SVCENAME is set).

When running the installer in debug mode, I can see the following

<entry num='37431' time='1380444237558' elapsed='01:08.01' level='DEBUG' thread='main'>
 <logger>JazzSMInstallLogger</logger>
 <class>com.ibm.cic.agent.internal.core.IMLoggerImpl</class>
 <method>debug</method>
 <message>JazzSMInstall : Retrieving protocol associated with instance: db2dwc</message>
</entry>
<entry num='37432' time='1380444237672' elapsed='01:08.12' level='DEBUG' thread='main'>
 <logger>JazzSMInstallLogger</logger>
 <class>com.ibm.cic.agent.internal.core.IMLoggerImpl</class>
 <method>debug</method>
 <message>JazzSMInstall : Going to run command . null/sqllib/db2profile &amp;&amp; null/sqllib/adm/db2set DB2COMM</message>
</entry>

So apparently, it's not able to resolve the DB2 home directory of the instance (which is /db2/DWC in my case). Instead it's returning null ...

Anyone an idea?

Thanks

Updated on 2013-09-29T09:11:39Z at 2013-09-29T09:11:39Z by Miguel_Sanders
  • sadravid
    sadravid
    20 Posts

    Re: Registry Services DB2 install issue

    ‏2013-09-30T13:10:05Z  

    Hi Miguel,

    Can you please provide answer to following questions.

    (1) Which version of JazzSM installer you are trying ?

    (2) We get the DB2 instance home path from file "/etc/passwd", can you check if this file contains the entry for the username that you are providing on database configuration panel ?

    thanks

  • Miguel_Sanders
    Miguel_Sanders
    4 Posts

    Re: Registry Services DB2 install issue

    ‏2013-09-30T17:46:14Z  
    • sadravid
    • ‏2013-09-30T13:10:05Z

    Hi Miguel,

    Can you please provide answer to following questions.

    (1) Which version of JazzSM installer you are trying ?

    (2) We get the DB2 instance home path from file "/etc/passwd", can you check if this file contains the entry for the username that you are providing on database configuration panel ?

    thanks

    Hi

    I'm using JazzSM 1.1

    Apparently, the DB2 instance owner is not a local user but an LDAP user (on AIX, using the LDAP LAM module).

    Let me try to add the instance owner to the local registry and see if that solves the install issue.

    Shouldn't the installer use the getuserattr call to find out the home directory?

     

    Cheers

  • sadravid
    sadravid
    20 Posts

    Re: Registry Services DB2 install issue

    ‏2013-10-01T07:58:37Z  

    Hi

    I'm using JazzSM 1.1

    Apparently, the DB2 instance owner is not a local user but an LDAP user (on AIX, using the LDAP LAM module).

    Let me try to add the instance owner to the local registry and see if that solves the install issue.

    Shouldn't the installer use the getuserattr call to find out the home directory?

     

    Cheers

    Hi,

    JazzSM supports only Local database instance user (it does not support LDAP database user).


    We need to get DB2 instance home directory for credential validation, "getuserattr" API will provide us user home directory which might be different than the DB2 instance home directory.

    thanks

  • Miguel_Sanders
    Miguel_Sanders
    4 Posts

    Re: Registry Services DB2 install issue

    ‏2013-10-03T10:42:01Z  
    • sadravid
    • ‏2013-10-01T07:58:37Z

    Hi,

    JazzSM supports only Local database instance user (it does not support LDAP database user).


    We need to get DB2 instance home directory for credential validation, "getuserattr" API will provide us user home directory which might be different than the DB2 instance home directory.

    thanks

    Thanks but still not getting there...

     

    /opt/IBM/JazzSM/install/frs/frs_db_config.xml:111: CTGFI3007E: Failed in configuring Registry Services Database. Check /opt/IBM/JazzSM/registry/logs directory for more information.
      <stack>Caused by:/opt/IBM/JazzSM/install/frs/frs_config.xml:173: The following error occurred while executing this line:
    /opt/IBM/JazzSM/install/frs/frs_config.xml:183: The following error occurred while executing this line:
    /opt/IBM/JazzSM/install/frs/frs_db_config.xml:51: The following error occurred while executing this line:
    /opt/IBM/JazzSM/install/frs/frs_db_config.xml:111: CTGFI3007E: Failed in configuring Registry Services Database. Check /opt/IBM/JazzSM/registry/logs directory for more information.</stack>
     

    /opt/IBM/JazzSM/registry/logs is empty

    /opt/IBM/JazzSM/install/frs/frs_db_config.xml:51 shows it's running /opt/IBM/JazzSM/registry/bin/frs-wrapper.sh install -type db, but no indication as of why it failed. Is it possible to retrieve these errors?

     

    Thanks for your help

  • sadravid
    sadravid
    20 Posts

    Re: Registry Services DB2 install issue

    ‏2013-10-03T11:00:49Z  

    Thanks but still not getting there...

     

    /opt/IBM/JazzSM/install/frs/frs_db_config.xml:111: CTGFI3007E: Failed in configuring Registry Services Database. Check /opt/IBM/JazzSM/registry/logs directory for more information.
      <stack>Caused by:/opt/IBM/JazzSM/install/frs/frs_config.xml:173: The following error occurred while executing this line:
    /opt/IBM/JazzSM/install/frs/frs_config.xml:183: The following error occurred while executing this line:
    /opt/IBM/JazzSM/install/frs/frs_db_config.xml:51: The following error occurred while executing this line:
    /opt/IBM/JazzSM/install/frs/frs_db_config.xml:111: CTGFI3007E: Failed in configuring Registry Services Database. Check /opt/IBM/JazzSM/registry/logs directory for more information.</stack>
     

    /opt/IBM/JazzSM/registry/logs is empty

    /opt/IBM/JazzSM/install/frs/frs_db_config.xml:51 shows it's running /opt/IBM/JazzSM/registry/bin/frs-wrapper.sh install -type db, but no indication as of why it failed. Is it possible to retrieve these errors?

     

    Thanks for your help

    Hi,

    Can you check if BASH is installed on your AIX machine ? Because BASH is prereq for Registry services 1.1

    Also can you provide us folder /var/ibm/InstallationManager/*

    thanks

  • Miguel_Sanders
    Miguel_Sanders
    4 Posts

    Re: Registry Services DB2 install issue

    ‏2013-10-03T11:43:47Z  
    • sadravid
    • ‏2013-10-03T11:00:49Z

    Hi,

    Can you check if BASH is installed on your AIX machine ? Because BASH is prereq for Registry services 1.1

    Also can you provide us folder /var/ibm/InstallationManager/*

    thanks

    Installing BASH solved the issue.

    Many thanks Saurabh!

  • Jannas007
    Jannas007
    8 Posts

    Re: Registry Services DB2 install issue

    ‏2014-11-21T15:18:25Z  

    I have the same issue ( JazzSMInstall : TCP IP not configured ) , however bash is installed:

     

    /usr/bin # ls -ltr |grep bash
    lrwxrwxrwx    1 root     system           30 Oct 17 17:11 bashbug -> ../../opt/freeware/bin/bashbug
    lrwxrwxrwx    1 root     system            7 Oct 17 17:11 bash2bug -> bashbug
    lrwxrwxrwx    1 root     system            4 Oct 17 17:11 bash2 -> bash
    lrwxrwxrwx    1 root     system           24 Oct 17 17:11 bash -> ../opt/freeware/bin/bash

     

    And I confirmed I could connect remotely to the DB on port 50002.

     

    Any other thing I can check?

  • sadravid
    sadravid
    20 Posts

    Re: Registry Services DB2 install issue

    ‏2014-11-24T07:23:43Z  
    • Jannas007
    • ‏2014-11-21T15:18:25Z

    I have the same issue ( JazzSMInstall : TCP IP not configured ) , however bash is installed:

     

    /usr/bin # ls -ltr |grep bash
    lrwxrwxrwx    1 root     system           30 Oct 17 17:11 bashbug -> ../../opt/freeware/bin/bashbug
    lrwxrwxrwx    1 root     system            7 Oct 17 17:11 bash2bug -> bashbug
    lrwxrwxrwx    1 root     system            4 Oct 17 17:11 bash2 -> bash
    lrwxrwxrwx    1 root     system           24 Oct 17 17:11 bash -> ../opt/freeware/bin/bash

     

    And I confirmed I could connect remotely to the DB on port 50002.

     

    Any other thing I can check?

    Hi,

    Can you please check if reply provided on below post helps your problem ?

    https://www.ibm.com/developerworks/community/forums/html/topic?id=44219a44-23af-4493-b299-e1b96d47711a&ps=25

    thanks

  • Jannas007
    Jannas007
    8 Posts

    Re: Registry Services DB2 install issue

    ‏2014-11-24T08:22:19Z  
    • sadravid
    • ‏2014-11-24T07:23:43Z

    Hi,

    Can you please check if reply provided on below post helps your problem ?

    https://www.ibm.com/developerworks/community/forums/html/topic?id=44219a44-23af-4493-b299-e1b96d47711a&ps=25

    thanks

    Unfortunately not, since my installation is all on the local box (DB2 instances and WAS on same local box). So I am not sure why it's not picking up the local DB2 instance config correctly, since TCP/IP services is configured correctly. When connecting local does it still even need the TCP/IP services?

  • Jannas007
    Jannas007
    8 Posts

    Re: Registry Services DB2 install issue

    ‏2014-11-24T15:02:49Z  
    • sadravid
    • ‏2014-11-24T07:23:43Z

    Hi,

    Can you please check if reply provided on below post helps your problem ?

    https://www.ibm.com/developerworks/community/forums/html/topic?id=44219a44-23af-4493-b299-e1b96d47711a&ps=25

    thanks

    I have since upgraded to Fixpack 3 so now I get the following error when trying to create the Databases (see attachment ):

     

    Invalid username/password, however I know it is correct.

     

    Any ideas?

     

     

    Attachments

  • sadravid
    sadravid
    20 Posts

    Re: Registry Services DB2 install issue

    ‏2014-11-24T16:06:33Z  
    • Jannas007
    • ‏2014-11-24T15:02:49Z

    I have since upgraded to Fixpack 3 so now I get the following error when trying to create the Databases (see attachment ):

     

    Invalid username/password, however I know it is correct.

     

    Any ideas?

     

     

    Hi,

    Please follow these steps :-

    (1) Run following command on the shell prompt                              
                                                                               
    export deployment_debug=true                                               
                                                                               
    (2) From the same shell prompt, run command (to start Installation Manager)                         
                                                                               
    /opt/IBM/InstallationManager/eclipse/IBMIM

    (3) Reproduce installation error scenario

    (4) Download JazzSM install pd collection scripts from url http://www-01.ibm.com/support/docview.wss?uid=swg21627669 and run custom_installation_PD.sh script. Before running custom_installation_PD.sh script, modify "JazzSM_PD_Script_Home/Unix/unix_custom_pd.properties" file for details of "jazzsm.home, was.home, db2.home, user.is.admin".

  • Jannas007
    Jannas007
    8 Posts

    Re: Registry Services DB2 install issue

    ‏2014-11-25T07:10:55Z  
    • sadravid
    • ‏2014-11-24T16:06:33Z

    Hi,

    Please follow these steps :-

    (1) Run following command on the shell prompt                              
                                                                               
    export deployment_debug=true                                               
                                                                               
    (2) From the same shell prompt, run command (to start Installation Manager)                         
                                                                               
    /opt/IBM/InstallationManager/eclipse/IBMIM

    (3) Reproduce installation error scenario

    (4) Download JazzSM install pd collection scripts from url http://www-01.ibm.com/support/docview.wss?uid=swg21627669 and run custom_installation_PD.sh script. Before running custom_installation_PD.sh script, modify "JazzSM_PD_Script_Home/Unix/unix_custom_pd.properties" file for details of "jazzsm.home, was.home, db2.home, user.is.admin".

    Thanks , I followed the steps as requested and uploaded the output:

  • sadravid
    sadravid
    20 Posts

    Re: Registry Services DB2 install issue

    ‏2014-11-25T07:33:20Z  
    • Jannas007
    • ‏2014-11-25T07:10:55Z

    Thanks , I followed the steps as requested and uploaded the output:

    Hi,

    Can you run following commands as root user in your system and paste the output of them ?
    Assuming "dashdb" is the username and "passw0rd" is the password for the "dashdb" user

    cd /db2/software/V10.1/bin
    . /dashdb/sqllib/db2profile && /db2/software/V10.1/bin/db2 "attach to dashdb user dashdb using 'passw0rd'"
    echo $?

    thanks

  • Jannas007
    Jannas007
    8 Posts

    Re: Registry Services DB2 install issue

    ‏2014-11-25T07:50:46Z  
    • sadravid
    • ‏2014-11-25T07:33:20Z

    Hi,

    Can you run following commands as root user in your system and paste the output of them ?
    Assuming "dashdb" is the username and "passw0rd" is the password for the "dashdb" user

    cd /db2/software/V10.1/bin
    . /dashdb/sqllib/db2profile && /db2/software/V10.1/bin/db2 "attach to dashdb user dashdb using 'passw0rd'"
    echo $?

    thanks

    That was successfull :

     

       Instance Attachment Information

     Instance server        = DB2/AIX64 10.1.0
     Authorization ID       = DASHDB
     Local instance alias   = DASHDB

    [prdTEPS2] /db2/software/V10.1/bin # echo $?
    0
     

     

    I also went through the logs and see I miss a few pre-reqs:

    [2014-11-21 16:42:52 ] INFO :     PropertyName : /opt
    [2014-11-21 16:42:52 ] INFO :     Result : FAIL
    [2014-11-21 16:42:52 ] INFO :     Found Value : 4.06GB
    [2014-11-21 16:42:52 ] INFO :     Expected Value : 7.71GB



    2014-11-21 16:42:53 ] INFO :     PropertyName : /usr
    [2014-11-21 16:42:53 ] INFO :     Result : FAIL
    [2014-11-21 16:42:53 ] INFO :     Found Value : 2.54GB
    [2014-11-21 16:42:53 ] INFO :     Expected Value : 5.09GB

    En lyk my hy soek Mozilla vir een of ander rede:

    [2014-11-21 16:42:20 ] INFO :     PropertyName : os.MozillaVersion
    [2014-11-21 16:42:20 ] INFO :     Result : FAIL
    [2014-11-21 16:42:20 ] INFO :     Found Value : Unavailable
    [2014-11-21 16:42:20 ] INFO :     Expected Value : 2.0+
     

     

    Not sure if that would cause the error I am seeing though?

     

  • sadravid
    sadravid
    20 Posts

    Re: Registry Services DB2 install issue

    ‏2014-11-25T08:07:43Z  
    • Jannas007
    • ‏2014-11-25T07:50:46Z

    That was successfull :

     

       Instance Attachment Information

     Instance server        = DB2/AIX64 10.1.0
     Authorization ID       = DASHDB
     Local instance alias   = DASHDB

    [prdTEPS2] /db2/software/V10.1/bin # echo $?
    0
     

     

    I also went through the logs and see I miss a few pre-reqs:

    [2014-11-21 16:42:52 ] INFO :     PropertyName : /opt
    [2014-11-21 16:42:52 ] INFO :     Result : FAIL
    [2014-11-21 16:42:52 ] INFO :     Found Value : 4.06GB
    [2014-11-21 16:42:52 ] INFO :     Expected Value : 7.71GB



    2014-11-21 16:42:53 ] INFO :     PropertyName : /usr
    [2014-11-21 16:42:53 ] INFO :     Result : FAIL
    [2014-11-21 16:42:53 ] INFO :     Found Value : 2.54GB
    [2014-11-21 16:42:53 ] INFO :     Expected Value : 5.09GB

    En lyk my hy soek Mozilla vir een of ander rede:

    [2014-11-21 16:42:20 ] INFO :     PropertyName : os.MozillaVersion
    [2014-11-21 16:42:20 ] INFO :     Result : FAIL
    [2014-11-21 16:42:20 ] INFO :     Found Value : Unavailable
    [2014-11-21 16:42:20 ] INFO :     Expected Value : 2.0+
     

     

    Not sure if that would cause the error I am seeing though?

     

    Hi,

    I would like you to follow these steps to reproduce Installation Manager related debug details.
    I hope with this, we can get some more information on why you are getting invalid credentials message.
    We are running the same command in our code as I have pasted in above post, so it should work fine in Installer UI also.
    If this does not work, then we can bypass the validation.

    (1) Create file "/var/ibm/InstallationManager/logs/log.properties" with following content in it
        
        InstallOperation=DEBUG
        com.ibm.cic.agent.internal.core.Director=DEBUG
        com.ibm.cic.agent.internal.core.InstallRegistry=DEBUG
        JazzSMInstallLogger=DEBUG
        
    (2) Restart Installation Manager and reproduce error scenario.

    (3) Run custom pd collection data and provide the collected data.

    thanks

  • Jannas007
    Jannas007
    8 Posts

    Re: Registry Services DB2 install issue

    ‏2014-11-25T09:21:50Z  
    • sadravid
    • ‏2014-11-25T08:07:43Z

    Hi,

    I would like you to follow these steps to reproduce Installation Manager related debug details.
    I hope with this, we can get some more information on why you are getting invalid credentials message.
    We are running the same command in our code as I have pasted in above post, so it should work fine in Installer UI also.
    If this does not work, then we can bypass the validation.

    (1) Create file "/var/ibm/InstallationManager/logs/log.properties" with following content in it
        
        InstallOperation=DEBUG
        com.ibm.cic.agent.internal.core.Director=DEBUG
        com.ibm.cic.agent.internal.core.InstallRegistry=DEBUG
        JazzSMInstallLogger=DEBUG
        
    (2) Restart Installation Manager and reproduce error scenario.

    (3) Run custom pd collection data and provide the collected data.

    thanks

    Thanks! I see this is what it's complaining about (strange as all those paths are valid..) :

     

    JazzSMInstall : isSupportedDB2VersionFound() db2InstallationPath =/db2/software/V10.1
      JazzSMInstall : Running attachCommand as . /dashdb/sqllib/db2profile && /db2/software/V10.1/bin/db2 "attach to $DB2INSTANCE user dashdb using '*****'"
      JazzSMInstall : Output of command . /dashdb/sqllib/db2profile && /db2/software/V10.1/bin/db2 "attach to $DB2INSTANCE user dashdb using '*****'"
      JazzSMInstall : SQL1027N  The node directory cannot be found.
     

     

    Attached the pdcollect as well:

  • sadravid
    sadravid
    20 Posts

    Re: Registry Services DB2 install issue

    ‏2014-11-25T12:27:00Z  
    • Jannas007
    • ‏2014-11-25T09:21:50Z

    Thanks! I see this is what it's complaining about (strange as all those paths are valid..) :

     

    JazzSMInstall : isSupportedDB2VersionFound() db2InstallationPath =/db2/software/V10.1
      JazzSMInstall : Running attachCommand as . /dashdb/sqllib/db2profile && /db2/software/V10.1/bin/db2 "attach to $DB2INSTANCE user dashdb using '*****'"
      JazzSMInstall : Output of command . /dashdb/sqllib/db2profile && /db2/software/V10.1/bin/db2 "attach to $DB2INSTANCE user dashdb using '*****'"
      JazzSMInstall : SQL1027N  The node directory cannot be found.
     

     

    Attached the pdcollect as well:

    Hi,

    I see that your "db2level" command provide the output as

    DB21085I  Instance "tepsdb" uses "64" bits and DB2 code release "SQL10010" with
    level identifier "0201010E".
    Informational tokens are "DB2 v10.1.0.0", "s120403", "AIX64101", and Fix Pack
    "0".
    Product is installed at "/db2/software/V10.1".

    Is "dashdb" instance is created on local machine ? or it is created on remote machine and you have done the catalog of remote database instance to your local machine ?

    Regarding message "SQL1027N  The node directory cannot be found", some of the links suggested that Node might not be cataloged (http://database.ittoolbox.com/groups/technical-functional/db2-l/sql1027n-the-node-directory-cannot-be-found-5147869)

    thanks
     

  • Jannas007
    Jannas007
    8 Posts

    Re: Registry Services DB2 install issue

    ‏2014-11-25T12:51:28Z  
    • sadravid
    • ‏2014-11-25T12:27:00Z

    Hi,

    I see that your "db2level" command provide the output as

    DB21085I  Instance "tepsdb" uses "64" bits and DB2 code release "SQL10010" with
    level identifier "0201010E".
    Informational tokens are "DB2 v10.1.0.0", "s120403", "AIX64101", and Fix Pack
    "0".
    Product is installed at "/db2/software/V10.1".

    Is "dashdb" instance is created on local machine ? or it is created on remote machine and you have done the catalog of remote database instance to your local machine ?

    Regarding message "SQL1027N  The node directory cannot be found", some of the links suggested that Node might not be cataloged (http://database.ittoolbox.com/groups/technical-functional/db2-l/sql1027n-the-node-directory-cannot-be-found-5147869)

    thanks
     

    Yip it is on the local machine where I am running the Installation Manager Install from and where all the other components is installed , so I don't understand it. I have asked my DBA's to check if cataloging the node locally might work. Will let you know.

  • Jannas007
    Jannas007
    8 Posts

    Re: Registry Services DB2 install issue

    ‏2014-11-26T08:57:58Z  
    • Jannas007
    • ‏2014-11-25T12:51:28Z

    Yip it is on the local machine where I am running the Installation Manager Install from and where all the other components is installed , so I don't understand it. I have asked my DBA's to check if cataloging the node locally might work. Will let you know.

    Hi There,

    I think it's a problem with the installer, as it seems not to cater for the scenario where all the components are on the same box?

     

    I cannot catalog a local node with the same name as the $DB2INSTANCE . I can only   create a node with a different name pointing to the same local instance name.

     

    Or is there maybe another option I need to select in the installer?

  • sadravid
    sadravid
    20 Posts

    Re: Registry Services DB2 install issue

    ‏2014-11-27T06:59:33Z  
    • Jannas007
    • ‏2014-11-26T08:57:58Z

    Hi There,

    I think it's a problem with the installer, as it seems not to cater for the scenario where all the components are on the same box?

     

    I cannot catalog a local node with the same name as the $DB2INSTANCE . I can only   create a node with a different name pointing to the same local instance name.

     

    Or is there maybe another option I need to select in the installer?

    Hi,

    Installer is trying to running the same command that you ran manually, not sure why "The node directory cannot be found" message is appearing.
    For now, you can bypass the validation by following these steps -

    (1) Edit file "/opt/IBM/InstallationManager/eclipse/configuration/config.ini" by adding new key as
        com.ibm.tivoli.tacct.psc.install.validation.skip=true
        
    (2) Restart Installation Manager and perform the installation.

    (3) Once installation is done successfully, remove the key "com.ibm.tivoli.tacct.psc.install.validation.skip" from file "config.ini".

    thanks