Administering Db2 Big SQL
You can perform administrative tasks for Db2 Big SQL, such as enabling database auditing, scaling the service, or setting up connections. Ensure that you have the required permissions to complete tasks.
For administrative tasks that are related to using the Db2 Big SQL service and that do not require cluster or instance administrator permissions, see Administering Db2 Big SQL in the Cloud Pak for Data documentation.
Service configuration
| Task | Required permissions | Details |
|---|---|---|
| Managing access to Db2 Big SQL instances | Instance administrator | Add and remove Db2 Big SQL users and administrators. |
| Configuring a Db2 Big SQL instance | Cloud Pak for Data administrator | Perform configuration tasks such as scaling an instance and updating credentials. |
| Updating and refreshing the Hadoop configuration files | Cloud Pak for Data administrator | Configure various Db2 Big SQL components and refresh Hadoop configuration files. |
| Synchronizing the Db2 Big SQL catalog and the Hive metastore | Cloud Pak for Data administrator | Make Hadoop objects available for use in Db2 Big SQL queries. |
| Setting up a connection to Db2 Big SQL | Cluster administrator | Connect a client application to Db2 Big SQL. |
| Enabling or disabling impersonation in Db2 Big SQL | Cloud Pak for Data administrator | Allow a Db2 Big SQL user to securely access data on behalf of another user. |
Security
| Task | Required permissions | Details |
|---|---|---|
| Exporting IBM® Software Hub audit records to a security information and event management solution | Instance administrator | Record user activities for Db2 Big SQL. |
| Audit events for Db2 Big SQL | Instance administrator | Describes Db2 Big SQL auditable events that are generated and forwarded by the Audit Logging Service. |
| Enabling database auditing for Db2 Big SQL | Instance administrator | Enable Db2-level auditing for Db2 Big SQL on IBM Software Hub. |
Monitoring
| Task | Required permissions | Details |
|---|---|---|
| Running the Db2 Big SQL health check command | Cloud Pak for Data administrator | Validate or repair inconsistencies in a multi-worker configuration. Note: This command can
repair problems that are detected by IBM Software
Hub service
monitors.
|
Resource management
| Task | Required permissions | Details |
|---|---|---|
| Manually scaling resources for services | Instance administrator | Adjust Db2 Big SQL by scaling resources to support high availability or to increase processing capacity. Resources can be scaled based on predefined resource configurations. |
| Automatically scaling resources for services | Not supported | |
| Shutting down and restarting services | Instance administrator | Manually shut down Db2 Big SQL to prevent it from using resources. You can restart the service when you need to use it again. |
Backup and restore
| Task | Required permissions | Details |
|---|---|---|
| Backing up and restoring IBM Software Hub | Cluster administrator | Choose the correct method to back up and restore IBM Software Hub. |