Db2 On Premise and Cloud

Expand all | Collapse all

DB2 Connection Error

  • 1.  DB2 Connection Error

    Posted Fri July 05, 2019 10:57 AM
    I have DB2 V11.5 ubuntu V16.04 when I try to connect to Database it gives an error fail to connect so I tried to update the instance with db2iupdt command a new error rises "DBI20127E The command failed because it is not supported or is invalid. "

    ------------------------------
    Mohammed Ashraf
    ------------------------------


  • 2.  RE: DB2 Connection Error

    Posted Mon July 08, 2019 08:31 AM
    I also installed 11.5 dev edition on ubuntu
    had a problem to connect remotely to the database

    after rebooting the vm - the problem was resolved
    what is the iupdt log file telling as message

    ------------------------------
    Guy Przytula
    ------------------------------



  • 3.  RE: DB2 Connection Error

    Posted Tue July 09, 2019 09:03 AM
    There are a couple things to check..

    1. Issue "db2set -all" and see if DB2COMM=TCPIP is set. If not, you want to set it "db2set db2comm tcpip"
    2. Make sure that your db2 instance is set to a port to communicate on - db2 "get dbm cfg" - the SVCENAME should be set to a port number. If it is set to a string like "db2c_db2inst1" confirm that string is in /etc/services and set to a port like 50051
    3. Look in your error log after you try to connect and see if there is an error message reported with more details. The default location is in the instance home directory /sqllib/db2dump and the file is called db2diag.log

    And as mentioned before, reboot the VM or the docker image, it may clear things up.

    ------------------------------
    Michael Krafick
    ------------------------------



  • 4.  RE: DB2 Connection Error

    Posted Tue July 09, 2019 09:13 AM
    Ok thank you all its done

    ------------------------------
    Mohammed Ashraf
    ------------------------------