Db2 Big SQL console

You can use the Db2® Big SQL console for database monitoring, administration, and configuration, and to run SQL queries. The console also provides historical monitoring data and key health indicators such as availability, responsiveness, and throughput.

Highlights

Explore: Use the Explore screen to view database objects and their properties and to perform basic administration tasks. You can list and view tables in the system. You can drill down from a schema to tables, search the schema or tables by typing a keyword, or browse table definitions and data. You can also create a table by entering column names and data types.
Monitor: Use the Monitor screens to keep track of everything that is happening with your system, and select the In-flight executions menu to monitor the SQL statements that are running on the database. From the Home page, you can view the health of the databases in your enterprise. You can start with the Home page to look for problems across your databases and then drill down to investigate.
Run SQL: Use the Run SQL screen to enter and edit SQL statements with help from real-time syntax validation and key-word assistance. Run one or more statements with a single click. Import SQL scripts from a local client, or run long-running queries and have the results download into an Excel spreadsheet. You can also add queries to a favorites list for quick access.
Automatic client connection failover: If Db2 Big SQL high availability (HA) is enabled, the Db2 Big SQL console attempts to connect to the secondary head node whenever the primary head node fails.
Note: Enabling HA triggers a restart of the Db2 Big SQL console so that configuration changes that are induced by enabling HA can be applied.

Screen capture of the Db2 Big SQL console user interface

Install and configure the Db2 Big SQL console

For information on how to install and configure the Db2 Big SQL console, see Optional: Installing the Db2 Big SQL console.

Open the Db2 Big SQL console

You can launch the Db2 Big SQL console by typing the following address in your web browser:

https://<console_host>:<console_port>/console/

Manage Db2 Big SQL console users

Any valid Db2 Big SQL user can access the console after authentication. Console admin and user privileges can be granted or revoked by using Db2 Big SQL GRANT or REVOKE statements.

Monitor

You can start with the Home page to look for problems across your databases and then drill down to investigate. Each database health summary appears as one tile on the Home page. You can group the tiles and specify the metrics to display on those tiles. Values that are above or below normal are flagged with a color change on the gauge. You can click a gauge to drill down and see more. Each database tile has an alert indicator that might be green, yellow, or red. Click the alert indicator to read the open alerts for a database. To access historical monitoring data in a view that you can customize, click the clock icon.

Edit and run SQL

Use the SQL editor to create and run SQL statements. Editor features such as syntax highlighting, content assist, query parsing, and validation as-you-type are available to help you complete your statements. Start from scratch, use one of several templates, a local file, or a saved script to build your scripts. Save your scripts to a server or locally for repeated use.

Screen capture of the Run SQL screen in the Db2 Big SQL console

Results from your running SQL scripts are posted in an expandable pane. Easy to read icons identify the status of your query; you can make changes quickly and see the results of your changes all in one view.

For more information about console features, click the question mark button to access the online help.