IBM Maximo: Migrate MAXDB to RH OpenShift: Difference between revisions

From Wiki
No edit summary
 
(11 intermediate revisions by the same user not shown)
Line 1: Line 1:


= Create MAXDB database =


1) Install DB2 Operator
1) Install DB2 Operator
Line 7: Line 9:
Open the DB2 Operator -> DB2 Cluster -> New cluster.
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)]]
 
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


  <nowiki>
  <nowiki>ls -l
apiVersion: db2u.databases.ibm.com/v1
total 7121740
kind: Db2uCluster
-rw-rw-rw-. 1 db2uadm db2iadm1 7095119872 Sep 13  2022 MAXDB76.0.ctginst1.DBPART000.20220913055916.001
metadata:
-rw-rw-rw-. 1 db2uadm db2iadm1  197538909 Apr  7 21:15 MAXDB76.0.ctginst1.DBPART000.20220913055916.001.zip
  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>
</nowiki>



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