Creating a Db2 Data Management Console instance

You can create a Db2® Data Management Console service instance by creating a custom resource. This task is an alternative for provisioning the Db2 Data Management Console service.

Before you begin

You can create only one instance of Db2 Data Management Console service for IBM Cloud Pak for Data. Therefore, before you create a service instance, check if any instance of Db2 Data Management Console service exists in the cluster.

About this task

You can create a Db2 Data Management Console instance in UI by provisioning the service. Alternatively, you can create a Db2 Data Management Console service instance by creating a custom resource using the command line.

Procedure

  1. Log in to Red Hat® OpenShift® Container Platform as a user with sufficient permissions to complete the task:
    oc login OpenShift_URL:port
  2. Get the status of Db2 Data Management Console (dmc-addon):
    oc get $(oc get Dmcaddon -o name -n ${PROJECT_CPD_INSTANCE}) -o jsonpath='{.status.dmcAddonStatus} {"\n"}'  -n project-name 

    Db2 Data Management Console is ready when the command returns Completed

  3. Create a Dmc custom resource. Follow the appropriate guidance for your environment.

    Using the recommended storage class names

    Create a custom resource with the following format.

    cat <<EOF |oc apply -f -
    apiVersion: dmc.databases.ibm.com/v1
    kind: Dmc
    metadata:
      name: data-management-console     
       annotations:
        ansible.operator-sdk/reconcile-period: "30s"
        ansible.sdk.operatorframework.io/verbosity: "4"   
    spec:
      version: 4.6.4
      description: "Data Management Console"         
      scaleConfig: small|medium|large         # Specify the scale. Medium scale is recommended.
      storageVendor: nfs | ocs | portworx     # Specify the type of storage to use, such as ocs
      storageSize: storage-size     # Specify the storage size. For example, 10Gi 
      license:
        accept: true
        license: Enterprise | Standard     # Specify the license you purchased
    
    EOF

    Using the custom storage class names

    Create a custom resource with the following format.

    cat <<EOF |oc apply -f -
    apiVersion: dmc.databases.ibm.com/v1
    kind: Dmc
    metadata:
      name: data-management-console     
       annotations:
        ansible.operator-sdk/reconcile-period: "30s"
        ansible.sdk.operatorframework.io/verbosity: "4"   
    spec:
      version: 4.6.4
      description: "Data Management Console"         
      scaleConfig: small|medium|large         # Specify the scale. Medium scale is recommended.
      storageClass: storage-class-name     # Specify the storage class name. 
      storageSize: storage-size     # Specify the storage size. For example, 10Gi 
      license:
        accept: true
        license: Enterprise | Standard     # Specify the license you purchased
    
    EOF

    Using the block storage class and file storage class names

    Create a custom resource with the following format.

    cat <<EOF |oc apply -f -
    apiVersion: dmc.databases.ibm.com/v1
    kind: Dmc
    metadata:
      name: data-management-console     
       annotations:
        ansible.operator-sdk/reconcile-period: "30s"
        ansible.sdk.operatorframework.io/verbosity: "4"   
    spec:
      version: 4.6.4
      description: "Data Management Console"         
      scaleConfig: small|medium|large         # Specify the scale. Medium scale is recommended.
      blockStorageClass: block-storage-class-name     # Specify the block storage class name. 
      fileStorageClass: file-storage-class-name     # Specify the file storage class name. 
      storageSize: storage-size     # Specify the storage size. For example, 10Gi 
      license:
        accept: true
        license: Enterprise | Standard     # Specify the license you purchased
    
    EOF

    Note: Db2 Data Management Console uses the following storage classes:
    • OpenShift Container Storage: ocs-storagecluster-cephfs
    • NFS: managed-nfs-storage
    • Portworx: portworx-shared-gp3
    For more information about storage classes for Db2 Data Management Console service, see Storage requirements.

    When you create the custom resource, the Db2 Data Management Console service instance is created.