Cloud Pak for Data

Cloud Pak for Data

Come for answers. Stay for best practices. All we’re missing is you.

 View Only

  • 1.  DB2 WH

    Posted Mon March 09, 2020 06:21 PM
    Hi 

    After deployment of DB2 WH I can't create Database.

    Error: Unable to retrieve available databases.


    Thx
    Andrzej


    ------------------------------
    Andrzej Bugowski
    ------------------------------

    #CloudPakforDataGroup


  • 2.  RE: DB2 WH

    Posted Tue March 10, 2020 03:52 AM

    Hi Andrzej,

    Can you check if your metastoredb pods are running fine ?

    Thanks



    ------------------------------
    TOMASZ HANUSIAK
    ------------------------------

    Original Message


  • 3.  RE: DB2 WH

    Posted Tue March 10, 2020 04:38 AM
    Hi

    I have 3 zem-metastoredb

    zen-metastoredb-0 1/1 Running 0 10d
    zen-metastoredb-1 1/1 Running 0 13d
    zen-metastoredb-2 1/1 Running 0 13d

    thx


    ------------------------------
    Andrzej Bugowski
    ------------------------------

    Original Message


  • 4.  RE: DB2 WH

    Posted Tue March 10, 2020 09:50 AM

    Can you try running this test?

    1) Request auth token

    curl -k -X GET https://test.ibm.com/v1/preauth/validateAuth -H 'content-type: application/json' -H 'username: admin' -H 'password: password'

    where test.ibm.com is your server name (CP4D route).

    2) Collect the value of accessToken

    3) Run the query (replace <token> with accessToken value:

    curl 'https://test.ibm.com/zen-data/v1/addOn/query' --data '{"add_on_type":"database"}' -k -H "Authorization: Bearer <token>" -H 'Content-Type: application/json'

    Thanks



    ------------------------------
    TOMASZ HANUSIAK
    ------------------------------

    Original Message


  • 5.  RE: DB2 WH

    Posted Tue March 10, 2020 02:07 PM
      |   view attached
    Hi Tomasz

    Look attached file

    Thx

    ------------------------------
    Andrzej Bugowski
    ------------------------------

    Attachment(s)

    txt
    output_com.txt   10 KB 1 version
    Original Message


  • 6.  RE: DB2 WH

    Posted Wed March 11, 2020 08:16 AM

    Hi,

    It seems that the database is no aware that you installed the DB2WH add-on.

    Can you try restarting the zen-watcher pod, and check the same results as above?

    Are you an IBM customer/BP ? We may need to do a webex to troubleshoot/resolve this completely.

    Thanks



    ------------------------------
    TOMASZ HANUSIAK
    ------------------------------

    Original Message


  • 7.  RE: DB2 WH

    Posted Thu March 12, 2020 05:06 AM
    Hi Tomasz,

    I am IBM distributor and this is only demo version.

    After I restarted watcher, he is in status pending not started.
    I open PMR but next week I am on CPD training and will reinstall all stuff.

    Thx

    ------------------------------
    Andrzej Bugowski
    ------------------------------

    Original Message


  • 8.  RE: DB2 WH

    Posted Thu March 12, 2020 05:35 AM
    Please see my direct message.

    ------------------------------
    TOMASZ HANUSIAK
    ------------------------------

    Original Message


Related Content