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

From Wiki
 
(4 intermediate revisions by the same user not shown)
Line 9: 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)]]


<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
Define db2 project on openshift
Line 113: Line 35:
  cd /mnt/backup
  cd /mnt/backup
  unzip MAXDB76.0.___.001.zip
  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 =
= Ver também =

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

Retrieved from "https://ebasso.net/wiki/index.php?title=IBM_Maximo:_Migrate_MAXDB_to_RH_OpenShift&oldid=9933"