IBM Support

Sample YAML scripts for deploying Db2 and Db2 Warehouse on AWS

General Page

Run these scripts to deploy a Db2 OLTP, Db2 Warehouse SMP, or Db2 Warehouse MPP instance on an Amazon Web Service cluster.

YAML for a Db2 OLTP instance

The following code deploys an instance of Db2 OLTP using separate storage for meta (EFS), data (EBS), backup (EFS), Transaction logs (EBS), and Temporary Tablespace (EBS).
  
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: ebs-sc
        - name: activelogs
          type: template
          spec:
            accessModes:
              - ReadWriteOnce
            resources:
              requests:
                storage: 30Gi
            storageClassName: ebs-sc          
    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: efs-test-sc
    type: create
  - name: backup
    spec:
      accessModes:
      - ReadWriteMany
      resources:
        requests:
          storage: 10Gi
      storageClassName: efs-test-sc
    type: create
  - name: archivelogs
    spec:
      accessModes:
      - ReadWriteMany
      resources:
        requests:
          storage: 10Gi
      storageClassName: efs-test-sc
    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 AWS. The instance uses separate storage for meta (EFS), data (EBS), backup (EFS), Transaction logs (EBS), and Temporay Tablespace (EBS). 
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: efs-test-sc
    type: create
  - name: data
    spec:
      accessModes:
      - ReadWriteOnce
      resources:
        requests:
          storage: 100Gi
      storageClassName: ebs-sc
    type: template
  - name: backup
    spec:
      accessModes:
      - ReadWriteMany
      resources:
        requests:
          storage: 10Gi
      storageClassName: efs-test-sc
    type: create
  - name: tempts
    spec:
      accessModes:
      - ReadWriteOnce
      resources:
        requests:
          storage: 10Gi
      storageClassName: ebs-sc
    type: template 
  - name: archivelogs
    spec:
      accessModes:
      - ReadWriteMany
      resources:
        requests:
          storage: 10Gi
      storageClassName: efs-test-sc
    type: create     
EOF

YAML for a Db2 Warehouse MPP instance

The following code deploys a multi-partition (MPP) instance of Db2 Warehouse on AWS. The instance uses separate storage for meta (EFS), data (EBS), backup (EFS), Transaction logs (EBS), and Temporay Tablespace (EBS).

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: efs-test-sc
    type: create
  - name: data
    spec:
      accessModes:
      - ReadWriteOnce
      resources:
        requests:
          storage: 100Gi
      storageClassName: ebs-sc
    type: template
  - name: backup
    spec:
      accessModes:
      - ReadWriteMany
      resources:
        requests:
          storage: 100Gi
      storageClassName: efs-test-sc
    type: create
  - name: tempts
    spec:
      accessModes:
      - ReadWriteOnce
      resources:
        requests:
          storage: 100Gi
      storageClassName: ebs-sc
    type: template  
  - name: archivelogs
    spec:
      accessModes:
      - ReadWriteMany
      resources:
        requests:
          storage: 200Gi
      storageClassName: efs-test-sc
    type: create        
EOF

[{"Type":"MASTER","Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSCJDQ","label":"IBM Db2 Warehouse"},"ARM Category":[{"code":"a8m500000008PknAAE","label":"Install\/Migrate\/Upgrade"}],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Versions"}]

Document Information

Modified date:
21 February 2024

UID

ibm16599533

Page Feedback