Administering Db2 Big SQL

You can perform a number of administrative tasks 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.
Syncing the Db2 Big SQL catalog and the Hive metastore
After the Db2 Big SQL service is installed, synchronization of the Hive metastore and Db2 Big SQL catalog might be required to make Hadoop objects available for use in Db2 Big SQL queries. This action does not move any data, but only makes the service aware of Hive tables that are residing on the target platform.
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.
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.
Enabling the Db2 REST interface in Db2 Big SQL
You can enable the Db2 REST interface for an existing Db2 Big SQL deployment on Cloud Pak for Data.
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.
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 in Db2 Big SQL
Impersonation is the ability to allow a service user to securely access data on behalf of another user.
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.
Manually rotating the SSL certificate used by Db2 Big SQL
When the Cloud Pak for Data self-signed certificate is updated, the SSL certificate that is used by Db2 Big SQL is automatically rotated to maintain connectivity to the service. However, you can rotate the certificate manually.
Deleting a Db2 Big SQL instance
You can delete a provisioned Db2 Big SQL instance.
Security in Db2 Big SQL
Db2 Big SQL can operate under different security models depending on the use case.