Administering Db2 Big SQL

There are a number of administrative tasks that you can perform for IBM® Db2® Big SQL.

Running the Db2 Big SQL health check command
After provisioning or scaling a Db2 Big SQL instance with multiple workers, you can use the Db2 Big SQL health check command to validate or repair any inconsistencies in your multi-worker configuration.
Configuring, monitoring, and managing access to Db2 Big SQL instances
When you are logged in as an administrator, you can complete various administrative tasks from the Cloud Pak for Data web client.
Setting up a connection to Db2 Big SQL
You must set up a connection to Db2 Big SQL before users can connect to Db2 Big SQL from a client application. You can set up the connection by using either the NodePort or the Passthrough Secure Route method.
Updating the Db2 Big SQL and Hadoop configuration
You can update the Hadoop configuration and configuration parameters for different Db2 Big SQL components.
Enabling or disabling impersonation
Impersonation is the ability to allow a service user to securely access data on behalf of another user.
Enabling the automatic syncing of the Db2 Big SQL catalog and the Hive metastore
You can keep the Db2 Big SQL catalog up to date with the Hive metastore server of the cluster to which it is connected. In that way, tables that are created by Hive or other services within it are automatically imported into Db2 Big SQL and can be queried from there.
Enabling database auditing for Db2 Big SQL
You can enable Db2-level auditing for Db2 Big SQL on Cloud Pak for Data.
Monitoring Db2 Big SQL
The Db2 Big SQL service provides a dashboard for monitoring and managing the service instance. This dashboard is powered by IBM Db2 Data Management Console.
Refreshing the SSL certificate used by Db2 Big SQL after the Cloud Pak for Data self-signed certificate is updated
When the Cloud Pak for Data self-signed certificate is updated, the SSL certificate that is used by Db2 Big SQL must be refreshed.
Deleting a Db2 Big SQL instance
You can delete a provisioned Db2 Big SQL instance.