Hi,
Below are some of the Q&A asked during the session:
- Is there a helm chart or operator script for deployment to Kubernetes similar to the deployment of a DB2 database? ( https://www.ibm.com/docs/en/db2/11.5?topic=id-installing-db2-operator )
Currently, we only have a docker image for DMC to install in a containerized environment. - https://www.ibm.com/docs/en/db2-data-mgr-console/3.1.x?topic=console-db2-data-management-docker-container
We support DMC operator install only on IBM Cloud pak for data (CPD) through the CPD service catalog and do not provide helm charts separately right now.
2. Does alerts support Web hooks?
Currently alerts do not support webhooks. You can always open a new requirement for it.
3. Bulk Password Updates: I've noticed that we can perform bulk updates for the "Data Collection Password" and "Shared Password" options for all database connections. However, there's no option for updating the "Personal Password" in bulk. Enabling this feature would be extremely helpful, as we have hundreds of connections and would like to avoid updating them one by one.
A. The current API (POST /dbprofiles/credentials) only supports bulk update for data collection and shared credentials. It doesn't support modifying the personal credential because it's designed for the system administrator or the profile owners to manage the connection profile. The personal credential belongs to the normal users, which we don't think needs the batch operation.Here is a general process for updating the personal credential of the session user on a specific connection profile.
- get the token of the DMC session user.
By calling the API to request the access token of the DMC session usersample of curl command
curl --location --request POST '<dmc-url>/dbapi/v4/auth/tokens' \
--data-raw '{
"userid": "<userid>",
"password": "<password>"
}'
2. with the token, call this API
curl --location --request PUT '<dmc-url>/dbapi/v4/dbprofiles/credentials/<DBNAME>' \
--header 'Authorization: Bearer {your_token}' \
--data-raw '{
"securityMechanism": "3",
"user": "<userid>",
"password": "<password>",
"saveOperationCred": "true"
}'
note,
- this API is only available for personal credentials. it is easier to construct than the updating connection profile API
- replace {your_token} with the token generated at the first step.
- with different values of the securityMechanism, the other fields may need to change. please refer to https://www.ibm.com/docs/en/db2/11.5?topic=java-security-under-data-server-driver-jdbc-sqlj
4. Report Access with Setup Admin Credentials: When using the "setup admin" option for authentication to log into the DMC console, all generated reports are encoded with these credentials. This requires validation each time we access them. We would like to share these reports with application teams without disclosing the "setup admin" credentials. Are there any available options within the DMC console to facilitate this?
A. If you are using the setup administrator then if you share reports via URL then you would need to log in dmc to view the report as there are no other roles setup. You can follow authentication setup from here where you can delegate roles to the users. - https://www.ibm.com/docs/en/db2-data-mgr-console/3.1.x?topic=securing-authentication-configuration
If you want to share the report without having them to log in is by downloading the report ( which can be done when you click on View report) and then you can share the attachment.
5. Do we have the ability to kill the running of that statement from DMC itself?
A. Yes, you can cancel the activity for the statement running from under Statements tab -> In-flight execution by clicking on the vertical eclipses on the right side menu there should be an option to Cancel activity.
------------------------------
Medha Parekh
------------------------------
Original Message:
Sent: Mon September 09, 2024 12:54 PM
From: Kat Jarvis
Subject: Unleash the Power of Monitoring and Tuning in Db2 Data Management Console Webinar
If you missed the webinar, you can find the recording here.
Join us for an insightful discussion on 17 September, 2024 at 11:00 AM ET to get an overview of the monitoring and query tuning features of Db2 Data Management Console. You will learn how you can use Db2 Data Management console to identify Db2 performance bottlenecks, such as I/O, CPU, lock contention, and query processing delays, using both real-time and historical data. Sheshnarayan Agrawal and Nidhi Marwaha will also cover tuning poorly performing queries using RUNSTATS and Index recommendations. Additionally, we will explore the Index What-if analysis tool which allows you to create your own index hypothesis or virtually drop an existing index for performance evaluation.
Click here to register and add the event to your calendar.
Where is the link to join? Check your email the day before the event!
How to get the most out of this webinar:
-
Explore the Db2 Community.
-
Ask questions for the presenter by replying to this discussion post before, during and after the webinar. Sheshnarayan Agrawal and Nidhi Marwaha will be happy to answer your questions and share insights.
-
Check out upcoming Db2 events here.
We look forward to seeing you there!
------------------------------
Kat Jarvis
------------------------------