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
Back to discussions
Expand all | Collapse all

Connection error - but connection validates fine - the current database user does not have the required authorization

  • 1.  Connection error - but connection validates fine - the current database user does not have the required authorization

    Posted 03/09/21 03:57 PM
    Hello - I have a new 11.5 DB2 connection setup (which is also same db as repository) and the connection validates successfully.

    On the Datapages page it shows an invalid connection error as below, but the connection credentials are part of db2admin group.


    I cannot see what is going wrong here.

    I see this in the logs:

    19:11:43 [WARN] [MonitorSummary] - HWCMON0009W: The database is disconnected (not monitored). Go to Connection profile page to verify the connection profile parameters and test connection to the database. {"status":500,"statusText":"Internal Server Error","url":"/dbapi/v4/metrics/statements_count?end=1615317103050&start=1615317103050","data":{"trace":"1781866f-1d07-33e3-7ad1-e99c89b11200","errors":[{"code":"invalid_db_error","message":"HWCMON0009W: The database is disconnected (not monitored). Go to Connection profile page to verify the connection profile parameters and test connection to the database.","target":{"type":"","name":""},"more_info":""}]},"name":"APIError","info":{"req":{"url":"/dbapi/v4/metrics/statements_count?end=1615317103050&start=1615317103050","requestId":"1781866f-1d07-33e3-7ad1-e99c89b11200","method":"GET","headers":{"X-Request-ID":"1781866f-1d07-33e3-7ad1-e99c89b11200","ucUserID":"********","X-DB-Profile":"POC","Authorization":"********","Accept":"application/json","Content-Type":"application/json"},"data":{"start":1615317103050,"end":1615317103050}},"res":{"url":"/dbapi/v4/metrics/statements_count?end=1615317103050&start=1615317103050","status":500,"statusText":"Internal Server Error","requestId":"1781866f-1d07-33e3-7ad1-e99c89b11200","headers":{},"method":"GET","data":{"trace":"1781866f-1d07-33e3-7ad1-e99c89b11200","errors":[{"code":"invalid_db_error","message":"HWCMON0009W: The database is disconnected (not monitored). Go to Connection profile page to verify the connection profile parameters and test connection to the database.","target":{"type":"","name":""},"more_info":""}]}}},"trace":"1781866f-1d07-33e3-7ad1-e99c89b11200","errors":[{"code":"invalid_db_error","message":"HWCMON0009W: The database is disconnected (not monitored). Go to Connection profile page to verify the connection profile parameters and test connection to the database.","target":{"type":"","name":""},"more_info":""}],"result":{"trace":"1781866f-1d07-33e3-7ad1-e99c89b11200","errors":[{"code":"invalid_db_error","message":"HWCMON0009W: The database is disconnected (not monitored). Go to Connection profile page to verify the connection profile parameters and test connection to the database.","target":{"type":"","name":""},"more_info":""}]},"group":"MONITOR_SUMMARY"}

    But when checking the connection the following is displayed:


    I'm not really sure what to try next?

    Thanks,
    Matt

    ------------------------------
    Matt Barfoot
    ------------------------------

    #Db2


Related Content