IBM Db2 Big SQL 7.1.0

Managing the Db2 Big SQL server

After you install Db2® Big SQL, you can modify some of the parameters or connect by using JDBC or ODBC drivers.

Db2 Big SQL directories
After you install the Db2 Big SQL service, $BIGSQL_HOME is the primary container for Db2 Big SQL configuration files.
Configuring the Db2 Big SQL server
You can change how Db2 Big SQL runs in your environment by changing Db2 Big SQL database resources and MapReduce resources. You can also manage and update the Db2 Big SQL password.
Adding and dropping worker nodes
After a successful installation of Db2 Big SQL, you can update your cluster by adding or dropping worker nodes.
Checking cluster health
The check cluster health feature checks whether the Db2 Big SQL database and all Db2 Big SQL nodes are running. It verifies database connections, adds missing database partitions, and registers the new database partitions.
Configuring logical Db2 Big SQL workers
You can create logical Db2 Big SQL workers on top of existing Db2 Big SQL workers. Logical Db2 Big SQL workers help to improve performance and scalability for INSERT and SELECT statements.
Db2 Big SQL scheduler
The scheduler is a service that helps in the execution of queries. It communicates with all of the components in Db2 Big SQL, including the Hive metastore, the HDFS NameNode, the Db2 Big SQL readers and writers, and the Db2 Big SQL engine.
Enabling Db2 Big SQL rack awareness
When Db2 Big SQL is installed on a small subset of nodes in a cluster, rack location can improve performance.
Db2 Big SQL readers and writers
The Db2 Big SQL readers and writers comprise the Db2 Big SQL layer that serves as the interface between the relational engine and the external storage layer. To support all data formats that are commonly used in Hadoop, Db2 Big SQL has an external table interface that uses Java™ readers and writers.

Parent topic: Cluster management