Latest revision as of 21:17, 7 April 2026

Create MAXDB database

1) Install DB2 Operator

2) Create a New instance of DB2.

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

Get yaml file on this Article IBM Maximo: Migrate MAXDB to RH OpenShift (db2ucmas76-01.yaml)

Paste inside yaml form and click on create

Restore MAXDB76 backup file into 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

Login on container

oc rsh c-db2ucmas76-02-db2u-0

Extract file

cd /mnt/backup
unzip MAXDB76.0.___.001.zip
chmod a+rw MAX*

List

ls -l
total 7121740
-rw-rw-rw-. 1 db2uadm db2iadm1 7095119872 Sep 13  2022 MAXDB76.0.ctginst1.DBPART000.20220913055916.001
-rw-rw-rw-. 1 db2uadm db2iadm1  197538909 Apr  7 21:15 MAXDB76.0.ctginst1.DBPART000.20220913055916.001.zip

Ver também

@@ Line 9: / Line 9: @@
 Open the DB2 Operator -> DB2 Cluster -> New cluster.
-Paste the yaml below, change storageClassName: "lvms-vg1", to your storage class.
+Get yaml file on this Article [[IBM Maximo: Migrate MAXDB to RH OpenShift (db2ucmas76-01.yaml)]]
- <nowiki>
+Paste inside yaml form and click on create
-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
-</nowiki>
-= Restore MAXDB76.backup.. to Container =
+= Restore MAXDB76 backup file into Container =
 Define db2 project on openshift
@@ Line 103: / Line 25: @@
 Copy backup file
-  oc cp MAXDB76.0.ctginst1.DBPART000.20220913055916.001.zip \
+  oc cp MAXDB76.0.___.001.zip c-db2ucmas76-02-db2u-0:/mnt/backup/MAXDB76.0.___.001.zip
-  c-db2ucmas76-02-db2u 0:/mnt/backup/MAXDB76.0.ctginst1.DBPART000.20220913055916.001.zip
+Login on container
+  oc rsh c-db2ucmas76-02-db2u-0
+Extract file
+ cd /mnt/backup
+ unzip MAXDB76.0.___.001.zip
+ chmod a+rw MAX*
+List
+ <nowiki>ls -l
+total 7121740
+-rw-rw-rw-. 1 db2uadm db2iadm1 7095119872 Sep 13  2022 MAXDB76.0.ctginst1.DBPART000.20220913055916.001
+-rw-rw-rw-. 1 db2uadm db2iadm1  197538909 Apr  7 21:15 MAXDB76.0.ctginst1.DBPART000.20220913055916.001.zip
+</nowiki>
 = Ver também =