From c126ef98ee0d89ddd4c5ef279709856b68d183e1 Mon Sep 17 00:00:00 2001
From: =?utf8?q?V=C3=A1s=C3=A1ry=20D=C3=A1niel?= <vasary@elgekko.net>
Date: Sun, 25 Feb 2024 23:21:41 +0100
Subject: [PATCH] Restore DB2 db

---
 lis-db/migrations/README | 10 ++++++++++
 1 file changed, 10 insertions(+)

diff --git a/lis-db/migrations/README b/lis-db/migrations/README
index 67a7cf4..7077fa7 100644
--- a/lis-db/migrations/README
+++ b/lis-db/migrations/README
@@ -68,6 +68,16 @@ List windows services
     sc queryex type=service state=all | find /i "SERVICE_NAME:"
 
 
+RESTORE
+-------
+docker exec -it ibmdb2 mkdir /tmpexport
+docker cp TESTMC.0.db2admin.DBPART000.20230330221657.001 ibmdb2:/tmpexport
+db2 restore database TESTMC from /tmpexport into MC replace existing redirect generate script chg.sql
+edit restore_db.sql
+    -DBPATH ON '/database/data'
+    -SET STOGROUP PATHS FOR IBMSTOGROUP ON '/database/data'
+db2 -tvf restore_db.sql
+
 MIGRATE
 -------
 migrate new create profile --idpattern=000
-- 
2.54.0