IBM Support

Sample YAML scripts for deploying Db2 and Db2 Warehouse on ARO

General Page

Run these scripts to deploy a Db2 OLTP, Db2 Warehouse SMP, or Db2 Warehouse MPP instance on an Azure Redhat OpenShift (ARO) cluster. 

YAML for a Db2 OLTP instance 

The following code deploys an instance of Db2 OLTP on ARO:

cat << EOF | oc create -f - 
apiVersion: db2u.databases.ibm.com/v1 
kind: Db2uCluster 
metadata: 
  name: db2oltp-test 
  namespace: db2u 
spec: 
  size: 1 
  environment: 
    database: 
      name: BLUDB 
    dbType: db2oltp 
    ldap: 
      enabled: false 
  license: 
    accept: true 
  podConfig: 
    db2u: 
      resource: 
        db2u: 
          limits: 
            cpu: 6 
            memory: 22Gi 
  storage: 
  - name: meta 
    spec: 
      accessModes: 
      - ReadWriteMany 
      resources: 
        requests: 
          storage: 10Gi 
      storageClassName: ocs-storagecluster-cephfs
    type: create 
  - name: data 
    spec: 
      accessModes: 
      - ReadWriteOnce 
      resources: 
        requests: 
          storage: 10Gi 
      storageClassName: ocs-storagecluster-ceph-rbd
    type: template 
  - name: backup 
    spec: 
      accessModes: 
      - ReadWriteMany 
      resources: 
        requests: 
          storage: 1Gi 
      storageClassName: ocs-storagecluster-cephfs
    type: create 
  - name: activelogs 
    spec: 
      accessModes: 
      - ReadWriteOnce 
      resources: 
        requests: 
          storage: 10Gi 
      storageClassName: ocs-storagecluster-ceph-rbd
    type: template 
  - name: tempts 
    spec: 
      accessModes: 
      - ReadWriteOnce 
      resources: 
        requests: 
          storage: 10Gi 
      storageClassName: ocs-storagecluster-ceph-rbd
    type: template 
  version: s11.5.8.0 
EOF

YAML for a Db2 Warehouse SMP instance 

The following code deploys a single partition (SMP) instance of Db2 Warehouse on ARO:

cat << EOF | oc create -f - 
apiVersion: db2u.databases.ibm.com/v1 
kind: Db2uCluster 
metadata: 
  name: db2whsmp-test 
  namespace: db2u 
spec: 
  size: 1 
  environment: 
    mln: 
      total: 1 
    dbType: db2wh 
    ldap: 
      enabled: false 
  license: 
    accept: true 
  podConfig: 
    db2u: 
      resource: 
        db2u: 
          limits: 
            cpu: 7 
            memory: 116Gi 
  storage: 
  - name: meta 
    spec: 
      accessModes: 
      - ReadWriteMany 
      resources: 
        requests: 
          storage: 10Gi 
      storageClassName: ocs-storagecluster-cephfs 
    type: create 
  - name: data 
    spec: 
      accessModes: 
      - ReadWriteOnce 
      resources: 
        requests: 
          storage: 20Gi 
      storageClassName: ocs-storagecluster-ceph-rbd
    type: template 
  - name: backup 
    spec: 
      accessModes: 
      - ReadWriteMany 
      resources: 
        requests: 
          storage: 1Gi 
      storageClassName: ocs-storagecluster-cephfs
    type: create 
  - name: activelogs
    spec: 
      accessModes: 
      - ReadWriteOnce 
      resources: 
        requests: 
          storage: 10Gi 
      storageClassName: ocs-storagecluster-ceph-rbd
    type: template 
  - name: tempts 
    spec: 
      accessModes: 
      - ReadWriteOnce 
      resources: 
        requests: 
          storage: 10Gi 
      storageClassName: ocs-storagecluster-ceph-rbd
    type: template 
  version: s11.5.8.0
EOF

YAML for a Db2 Warehouse MPP instance 

The following code deploys a multi-partition (MPP) instance of Db2 Warehouse on ARO:

cat << EOF | oc create -f - 
apiVersion: db2u.databases.ibm.com/v1 
kind: Db2uCluster 
metadata: 
  name: db2whmpp-test 
  namespace: db2u 
spec: 
  size: 6 
  environment: 
    mln: 
      total: 36 
    dbType: db2wh 
    ldap: 
      enabled: false 
  license: 
    accept: true 
  podConfig: 
    db2u: 
      resource: 
        db2u: 
          limits: 
            cpu: 28 
            memory: 476Gi 
  storage: 
  - name: meta 
    spec: 
      accessModes: 
      - ReadWriteMany 
      resources: 
        requests: 
          storage: 10Gi 
      storageClassName: ocs-storagecluster-cephfs
    type: create 
  - name: data 
    spec: 
      accessModes: 
      - ReadWriteOnce 
      resources: 
        requests: 
          storage: 20Gi 
      storageClassName: ocs-storagecluster-ceph-rbd 
    type: template 
  - name: backup 
    spec: 
      accessModes: 
      - ReadWriteMany 
      resources: 
        requests: 
          storage: 1Gi 
      storageClassName: ocs-storagecluster-cephfs
    type: create 
  - name: activelogs 
    spec: 
      accessModes: 
      - ReadWriteOnce 
      resources: 
        requests: 
          storage: 10Gi 
      storageClassName: ocs-storagecluster-ceph-rbd
    type: template 
  - name: tempts 
    spec: 
      accessModes: 
      - ReadWriteOnce 
      resources: 
        requests: 
          storage: 10Gi 
      storageClassName: ocs-storagecluster-ceph-rbd
    type: template 
  version: s11.5.8.0
EOF

[{"Type":"MASTER","Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"ARM Category":[{"code":"a8m500000008Pm6AAE","label":"Install\/Migrate\/Upgrade-\u003EDatabase Upgrade"},{"code":"a8m3p000000LPvoAAG","label":"Openshift"}],"ARM Case Number":"","Platform":[{"code":"PF016","label":"Linux"}],"Version":"11.5.7;and future releases"}]

Document Information

Modified date:
21 April 2023

UID

ibm16851447

Page Feedback