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.  can't open console

    Posted 09/02/20 03:04 PM

    unable to open db2 console from 3 days






    #Db2
    #Support
    #SupportMigration


  • 2.  RE: can't open console

    Posted 09/02/20 03:45 PM

    Hi arjun,

    was stuck up with the same problem for the past week and finally found a solution.Thought of sharing it with you :)

    1.log in to your ibm account on =>cloud.ibm.com.

    2.go to your dashboard

    3.click services on your resource summary => you are directed to your resource list.

    4.click service -> your database instance (eg., db2-xx).

    5.On the side bar click -> service credentials (click new credentials button if you have not already created your service credential)

    6.Maximize your credentials by clicking the downward arrow situated at the left side of your service credential name.

    7.copy the https_url key's value (i.e, your direct acces url)

    8.open a new tab in your browser and paste the url you copied(you will get a login page for your console).

    9.enter the username and password which is specified in your service credentials(the place where you found the https_url key , you will also find the username and password keys)

    10.copy the username and password and paste it in the login page for your console .

    11.Click login and you are logged into your db2 console .

    Hope it works for you too :)

    you can refer(https://stackoverflow.com/questions/62003466/db2-console-does-not-load-in-ibm-cloud)






    #Db2
    #Support
    #SupportMigration


  • 3.  RE: can't open console

    Posted 09/02/20 04:05 PM

    hey it's showing error with state api






    #Db2
    #Support
    #SupportMigration


  • 4.  RE: can't open console

    Posted 09/02/20 06:32 PM

    yeah, faced the same problem after answering you.

    I changed my browser from google chrome to mozilla firefox and did it all over again . after logging in with the password given by the service credential, the page asked me to change the password since it's not strong. so I had to change the password to get into my db2 account.


    Note: if you change the password , then the uri in your service credential is no longer valid , you have to manually make a small change to the uri wherever you paste it to connect to the db2 by changing the previous password to your new one (you cannot change it in the service credential but can do it in the place you paste it).

    for eg;

    your service credential uri:

    it's something like this => "db2://<username>:<old-password>:50000/BLUDB"


    so whenever you copy the uri to connect somewhere else just replace the old password with new one. If your new password contains special characters like '' then replace it with its correspondent code value (for '' it is '%40').

    eg: new password: asdfgf

    password to be changed in uri : asdfgf%40.

    This is how it worked for me. I don't know the replacement value for any other special character other than 't know it is better to use the same in your password since atleast one special character is required for it to be accepted.


    Hope you get it :)






    #Db2
    #Support
    #SupportMigration