Create MAXDB database

1) Install DB2 Operator

2) Create a New instance of DB2.

Open the DB2 Operator -> DB2 Cluster -> New cluster.

Paste the yaml below, change storageClassName: "lvms-vg1", to your storage class.

apiVersion: db2u.databases.ibm.com/v1
kind: Db2uCluster
metadata:
  name: db2ucmas76-01
  namespace: db2u
spec:
  license:
    accept: true
  account:
    privileged: true
  environment:
    database:
      settings:
        codeset: UTF-8
        territory: US
      name: MAXDB
    ldap:
      enabled: false
    dbType: db2wh
  version: s11.5.9.0-cn2
  podConfig:
    db2u:
      resource:
        db2u:
          limits:
            cpu: '6'
            memory: 16Gi
          requests:
            cpu: 500m
            memory: 3Gi
  storage:
    - name: meta
      type: create
      spec:
        accessModes:
          - ReadWriteOnce
        resources:
          requests:
            storage: 10Gi
        storageClassName: lvms-vg1
    - name: data
      type: template
      spec:
        accessModes:
          - ReadWriteOnce
        resources:
          requests:
            storage: 20Gi
        storageClassName: lvms-vg1
    - name: backup
      type: create
      spec:
        accessModes:
          - ReadWriteOnce
        resources:
          requests:
            storage: 10Gi
        storageClassName: lvms-vg1
    - name: tempts
      type: template
      spec:
        accessModes:
          - ReadWriteOnce
        resources:
          requests:
            storage: 10Gi
        storageClassName: lvms-vg1
    - name: archivelogs
      type: create
      spec:
        accessModes:
          - ReadWriteOnce
        resources:
          requests:
            storage: 10Gi
        storageClassName: lvms-vg1
  size: 1

Restore MAXDB76.backup.. to Container

Define db2 project on openshift

oc project db2u

Check pods

oc get pods

Copy backup file

oc cp MAXDB76.0.___.001.zip c-db2ucmas76-02-db2u 0:/mnt/backup/MAXDB76.0.___.001.zip

Ver também