Administering IBM Db2 Warehouse
Some administrative tasks are unique to Db2 Warehouse . Such tasks typically involve activity on the
servers that host your Db2 Warehouse deployment, and
require root authority on these servers. Unless otherwise noted, other administrative tasks in other
sections of the documentation also apply to Db2 Warehouse .
Backup, restore, and disaster recovery
It is recommended that you regularly back up the data in your databases. Only a database administrator can perform backup and restore operations.
Configuring IBM Db2 Warehouse
After deployment of the Db2 Warehouse image, you can change the values of some configuration options.
Security for IBM Db2 Warehouse
Db2 Warehouse takes advantage of security features that are available to other Db2 products, such as row and column access control. Features that are specific to Db2 Warehouse include the ability to set up an external LDAP server or Microsoft Active Directory server.
Stopping all Spark activity on IBM Db2 Warehouse
A Db2 Warehouse administrator can reset the Spark cluster manager, which kills all Spark jobs and stops all Spark applications and clusters.
Administration commands for IBM Db2 Warehouse
Issue IBM® Db2 Warehouse administration commands on the command line of the host. In an MPP deployment, some of the commands must be run on the head node host. You can identify the head node host by issuing the docker exec -it Db2wh status command and looking for the host in the IBM Db2 Warehouse Cluster Status section of the output.