Db2

Db2

Connect with Db2, Informix, Netezza, open source, and other data experts to gain value from your data, share insights, and solve problems.

 View Only
  • 1.  Initialize profile for imported configuration

    Posted Tue June 02, 2020 05:33 PM
    I have imported a set of database into the Data Management Console, but for the new ones I got this:

    The current profile is not initialized, please double check all the required fields, save it and try again.

    I have to click in the properties for each one, in order to activate it for monitoring. Is there a way to do that in bulk?

    Also, is there any way to import the profiles? I can only see export.

    ------------------------------
    Andres Gomez Casanova
    IBM Champion 2015-2020
    DBA senior
    Bogota, Colombia
    ------------------------------

    #Db2


  • 2.  RE: Initialize profile for imported configuration

    Posted Tue June 02, 2020 07:06 PM
    Hi Andreas,

    Export and Import of connection profiles is supported.  You should see the export and import button in DMC 3.1.1.  

    Another way to create connection profile in bulk is to use the RESTful API available in DMC now.  This requires a little bit of scripting.  You can find the swagger doc by clicking at the ? on top right corner of the DMC page.  

    In this post here is an handy example on how to create and grant a connection profile using RESTful API.  You can also find the example source code: here

    ------------------------------
    Jason Sizto
    ------------------------------