You create a database deployment on your cluster from the IBM® Cloud Pak for
Data web client.
Before you begin
- Ensure that you completed the steps in
Installing Db2®.
- If you plan to deploy on a dedicated node, label the node. You will enter the label as part of
the deployment process. For more details, see Setting up dedicated nodes for your Db2 deployment.
- You must have the Create service instances permission to complete this
task.
Procedure
-
From the navigation, select .
-
Click Create a database.
-
Select the database type and version. Click Next.
-
In the Configure area, specify the number of nodes, memory per node, and
CPU per node.
The console checks your OpenShift® cluster
for adequate memory and CPU resources to meet your specifications. An error message displays if
inadequate resources are found. If this occurs, you must either reduce the amounts that you
specified or add more resources to the cluster.
-
If you are using a dedicated node, click Deploy database on dedicated
nodes and enter the node label in the Value for node label
box.
-
On the Advanced configuration page:
- Use the Oracle compatibility option to specify whether Db2 is deployed in Oracle compatibility mode
(the DB2_COMPATIBILITY_VECTOR registry variable is set to
ORA).
- For Page size, specify 16K or 32K.
- If you use Portworx storage, you must specify
4K block size.
-
You can choose to keep your system data, user data, backup data, transaction logs, and
temporary table space data together in a single storage location, or put them in separate locations.
System data contains the information that is used by Db2 to manage and configure the database. User
data is the main database data. Backup data is the storage for saving Db2 backup images. Transaction logs storage is
the location to save main database transaction logs. Temporary table space storage is the location
where main database temporary table spaces are created. If you choose Separate locations
for all data, you must specify a storage volume type, a name, and a size for all storage
locations.
-
Specify the storage to use for the database.
-
Click Next.
- Optional:
Specify a new display name for the database.
-
Ensure that the summary is correct and click Create.
The database is ready when it shows up as Available on the
Databases tab.
-
When the database is ready, select Submit connection for approval from
the action menu.
Important: The connection to the database is not available in the catalog until the
request is approved by a user with Manage Catalog permissions (for example, a
Data Steward).
- Optional:
After deploying, if you want to upgrade the Db2 license from Db2 Community Edition to Db2 Advanced Edition, follow the steps in Upgrading the license of a deployed Db2 service.
What to do next
Ensure that a user with Manage Catalog permissions approves
the request. The request shows on the Publish to Catalog Requests tab on
their home page.
After the request is approved, the database is available on the Data
connections page. You can use the connection when you run automated
discovery to import, analyze, and classify data from the database.
As the database administrator, you can: