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).

    For more information about the storage classes supported by Db2 Data Management Console, refer to the following table:

    Storage Notes Storage classes
    OpenShift Data Foundation
    • If you provision a Db2 Data Management Console service instance from the UI, you must specify file storage.
    • If you provision a Db2 Data Management Console by creating a custom resource, you can specify:
      • File storage only

        Use the storageClass parameter.

      • File storage and block storage (recommended)

        Use the fileStorageClass and blockStorageClass parameters.
    • File storage: ocs-storagecluster-cephfs
    • Block storage: ocs-storagecluster-ceph-rbd
    IBM Storage Fusion Data Foundation
    • If you provision a Db2 Data Management Console service instance from the UI, you must specify file storage.
    • If you provision a Db2 Data Management Console by creating a custom resource, you can specify:
      • File storage only

        Use the storageClass parameter.

      • File storage and block storage (recommended)

        Use the fileStorageClass and blockStorageClass parameters.
    • File storage: ocs-storagecluster-cephfs
    • Block storage: ocs-storagecluster-ceph-rbd
    IBM Storage Fusion Global Data Platform
    • If you provision Db2 Data Management Console service instance from the UI, ibm-spectrum-scale-sc is used as file storage.
    • If you provision a Db2 Data Management Console by creating a custom resource, you can specify:
      • File storage only

        Use the storageClass parameter.

      • File storage and block storage (recommended)

        Use the fileStorageClass and blockStorageClass parameters.
    • File storage: ibm-spectrum-scale-sc
    • Block storage: ibm-spectrum-scale-sc
    IBM Storage Scale Container Native
    • If you provision Db2 Data Management Console service instance from the UI, ibm-spectrum-scale-sc is used as file storage.
    • If you provision a Db2 Data Management Console by creating a custom resource, you can specify:
      • File storage only

        Use the storageClass parameter.

      • File storage and block storage (recommended)

        Use the fileStorageClass and blockStorageClass parameters.
    • File storage: ibm-spectrum-scale-sc
    • Block storage: ibm-spectrum-scale-sc
    Portworx
    • If you provision a Db2 Data Management Console service instance from the UI, you must specify file storage.
    • If you provision a Db2 Data Management Console by creating a custom resource, you can specify:
      • File storage only

        Use the storageClass parameter.

      • File storage and block storage (recommended)

        Use the fileStorageClass and blockStorageClass parameters.
    • File storage: portworx-rwx-gp3-sc

      (Equivalent to portworx-shared-gp3 in older installations)

    • Block storage: portworx-db-gp3-sc
    NFS
    • If you provision Db2 Data Management Console service instance from the UI, managed-nfs-storage is used as file storage.
    • If you provision a Db2 Data Management Console by creating a custom resource, you can specify:
      • File storage only

        Use the storageClass parameter.

      • File storage and block storage (recommended)

        Use the fileStorageClass and blockStorageClass parameters.
    • File storage: managed-nfs-storage
    • Block storage: managed-nfs-storage
    Amazon Elastic storage
    • If you provision a Db2 Data Management Console service instance from the UI, you must specify file storage.
    • If you provision a Db2 Data Management Console by creating a custom resource, you can specify:
      • File storage only

        Use the storageClass parameter.

      • File storage and block storage (recommended)

        Use the fileStorageClass and blockStorageClass parameters.

    File storage is provided by Amazon Elastic File System. Block storage is provided by Amazon Elastic Block Store.
    • File storage: efs-nfs-client
    • Block storage: gp2-csi or gp3-csi
    NetApp Trident
    • If you provision Db2 Data Management Console service instance from the UI, ontap-nas is used as file storage.
    • If you provision a Db2 Data Management Console by creating a custom resource, you can specify:
      • File storage only

        Use the storageClass parameter.

      • File storage and block storage (recommended)

        Use the fileStorageClass and blockStorageClass parameters.
    • File storage: ontap-nas
    • Block storage: ontap-nas

    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.