IBM Support

Sample YAML scripts for deploying Db2 and Db2 Warehouse on Azure 

General Page

Run these scripts to deploy a Db2 OLTP, Db2 Warehouse SMP, or Db2 Warehouse MPP instance on an Azure Kubernetes Service (AKS) cluster. 

YAML for a Db2 OLTP instance 

The following code deploys an instance of Db2 OLTP on Azure. The instance uses separate storage for meta (Azure Files), data (Azure Disks), backup (Azure Files), Transaction logs (Azure Disks), and Temporary Tablespace (Azure Disks). 

cat << EOF | kubectl create -f -
apiVersion: db2u.databases.ibm.com/v1
kind: Db2uInstance
metadata:
  name: db2oltp-test
  namespace: db2u
spec:
  environment:
    authentication:
      ldap:
        enabled: false
    databases:
    - name: BLUDB
      storage:
        - name: data
          type: template
          spec:
            accessModes:
              - ReadWriteOnce
            resources:
              requests:
                storage: 100Gi
            storageClassName: azuredisk-premium
        - name: activelogs
          type: template
          spec:
            accessModes:
              - ReadWriteOnce
            resources:
              requests:
                storage: 30Gi
            storageClassName: azuredisk-premium          
    dbType: db2oltp 
  license:
    accept: true
  nodes: 1
  podTemplate:
    db2u:
      resource:
        db2u:
          limits:
            cpu: "2"
            memory: "8Gi"
  storage:
  - name: meta
    spec:
      accessModes:
      - ReadWriteMany
      resources:
        requests:
          storage: 10Gi
      storageClassName: azurefile-nfs
    type: create
  - name: backup
    spec:
      accessModes:
      - ReadWriteMany
      resources:
        requests:
          storage: 10Gi
      storageClassName: azurefile-nfs
    type: create
  - name: archivelogs
    spec:
      accessModes:
      - ReadWriteMany
      resources:
        requests:
          storage: 10Gi
      storageClassName: azurefile-nfs
    type: create
  version: s11.5.9.0-cn1
EOF

YAML for a Db2 Warehouse SMP instance 

The following code deploys a single partition (SMP) instance of Db2 Warehouse on Azure. The instance uses separate storage for meta (Azure Files), data (Azure Disks), backup (Azure Files), Transaction logs (Azure Disks), and Temporary Tablespace (Azure Disks). 

cat << EOF | kubectl apply -f -
apiVersion: db2u.databases.ibm.com/v1
kind: Db2uInstance
metadata:
  name: db2whsmp-test
  namespace: db2u
spec:
  version: s11.5.9.0-cn1
  nodes: 1
  environment:
    dbType: db2wh
    databases:
      - name: BLUDB
    partitionConfig:
      total: 1
    authentication:
      ldap:
        enabled: false        
  license:
    accept: true
  storage:
  - name: meta
    spec:
      accessModes:
      - ReadWriteMany
      resources:
        requests:
          storage: 20Gi
      storageClassName: azurefile-nfs
    type: create
  - name: data
    spec:
      accessModes:
      - ReadWriteOnce
      resources:
        requests:
          storage: 100Gi
      storageClassName: azuredisk-premium
    type: template
  - name: backup
    spec:
      accessModes:
      - ReadWriteMany
      resources:
        requests:
          storage: 10Gi
      storageClassName: azurefile-nfs
    type: create
  - name: tempts
    spec:
      accessModes:
      - ReadWriteOnce
      resources:
        requests:
          storage: 10Gi
      storageClassName: azuredisk-premium
    type: template 
  - name: archivelogs
    spec:
      accessModes:
      - ReadWriteMany
      resources:
        requests:
          storage: 10Gi
      storageClassName: azurefile-nfs
    type: create     
EOF

YAML for a Db2 Warehouse MPP instance 

The following code deploys a multi-partition (MPP) instance of Db2 Warehouse on Azure. The instance uses separate storage for meta (Azure NetApp Files), data (Azure Disks), backup (Azure Files), Transaction logs (Azure Disks), and Temporary Tablespace (Azure Disks).

cat << EOF | kubectl apply -f -
apiVersion: db2u.databases.ibm.com/v1
kind: Db2uInstance
metadata:
  name: db2whmpp-test
  namespace: db2u
spec:
  version: s11.5.9.0-cn1
  nodes: 6
  podTemplate:
    db2u:
      resource:
        db2u:
          limits:
            cpu: "60"
            memory: "480Gi"    
  environment:
    dbType: db2wh
    databases:
      - name: BLUDB
    partitionConfig:
      total: 84 
      volumePerPartition: true 
    authentication:
      ldap:
        enabled: false        
  license:
    accept: true
  storage:
  - name: meta
    spec:
      accessModes:
      - ReadWriteMany
      resources:
        requests:
          storage: 100Gi
      storageClassName: azurefile-nfs
    type: create
  - name: data
    spec:
      accessModes:
      - ReadWriteOnce
      resources:
        requests:
          storage: 100Gi
      storageClassName: azuredisk-premium
    type: template
  - name: backup
    spec:
      accessModes:
      - ReadWriteMany
      resources:
        requests:
          storage: 100Gi
      storageClassName: azurefile-nfs
    type: create
  - name: tempts
    spec:
      accessModes:
      - ReadWriteOnce
      resources:
        requests:
          storage: 100Gi
      storageClassName: azuredisk-premium
    type: template  
  - name: archivelogs
    spec:
      accessModes:
      - ReadWriteMany
      resources:
        requests:
          storage: 200Gi
      storageClassName: azurefile-nfs
    type: create        
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 February 2024

UID

ibm16830643

Page Feedback