Revision as of 00:05, 8 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

Copy 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

Change user

su - db2inst1

Check backup

db2ckbkp -H /mnt/backup/MAXDB76.0.ctginst1.DBPART000.20220913055916.001

This command is generate the following file: IBM Maximo: Migrate MAXDB to RH OpenShift (db2ckbkp.out)

Restore MAXDB76 backup file into Container

db2 restore database MAXDB76 redirect generate script restoresql.sql

Ver também

@@ Line 13: / Line 13: @@
 Paste inside yaml form and click on create
-= Restore MAXDB76 backup file into Container =
+= Copy MAXDB76 backup file into Container =
 Define db2 project on openshift
@@ Line 55: / Line 55: @@
 This command is generate the following file: [[IBM Maximo: Migrate MAXDB to RH OpenShift (db2ckbkp.out)]]
+= Restore MAXDB76 backup file into Container =
+db2 restore database MAXDB76 redirect generate script restoresql.sql
 = Ver também =