Provisioning the service (Db2 Data Management Console)

Before you can use Db2 Data Management Console service, you must provision an instance service. You can provision only one instance of Db2 Data Management Console service for IBM Cloud Pak for Data

Before you begin

Before you provision the Db2 Data Management Console service, you must:

About this task

The Db2 Data Management Console service is provisioned to any compute node in the Cloud Pak for Data cluster that has the specified resources (cores and memory) available.

Important: To complete this task, you must have the Provision Databases permission. The default Cloud Pak for Data administrator role, Admin, has this permission.

Procedure

To provision the Cloud Pak for Data service:

  1. On the navigation menu, click Services > Services catalog.
  2. In the Services catalog page, click Category > Data sources.
  3. From the list of services, locate the IBM® Db2 Data Management Console service. Click the action menu and select Provision instance.
  4. In the Compute section, specify the Plan for the instance. You can select Small, Medium, or Large for the plan. Medium is recommended.
    Plan Memory (GB) CPU (Cores) No of concurrent users No of databases
    Small 19 5 5 1
    Medium 31 10 20 10
    Large 51 19 100 50
  5. Click Next.
    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 amount that you specified or add more resources to the cluster.
  6. In the Storage section, specify the resources (storage class and amount of storage) to allocate for persistent storage using Persistence Volume Claim (PVC).

    Db2 Data Management Console supports NFS, OpenShift Container Storage, IBM Cloud® File Storage, IBM Spectrum®, and Portworx for persistent storage. For more information, see Service persistent storage requirements.

    For persistent volume, the minimum size is 10 (Gi).

  7. Click Next.
  8. Ensure that the summary is correct and click Create.
  9. Optional: It can take approximately 10 minutes for the service to be provisioned. Check the status to determine the state of a provisioning or provisioned service. If you want to use Cloud Pak for Data while you wait for the provisioning process to complete, click Home.
    Note:
    • If you open the provision instance for Db2 Warehouse, Db2 Advanced Edition, and Big SQL, the Db2 Data Management Console service opens directly if the console is installed else you will be redirected to the installation page.
    • For Db2 Data Management Console service on AWS cluster with Portworx storage, use portworx-dv-shared-gp3 storage.