Hi John, Sorry, it was over a year ago, so I can't quite remember, but the client I was working with had poor DDL management, so I unloaded the data from the DB2 catalog in V8 and generated the DDL using Excel functions. The main DDL I generated was the following:
- GRANT DBADM
- GRANT TABLE
- GRANT USER
- GRANT PLAN
- CREATE STOGROUP
- CREATE DATABASE
- CREATE ALIAS (instead of SYNONYMS)
- BIND PLAN
- BIND PACKAGE
The difficult part was to verify that the timestamps of the PACKAGE DBRM objects and the LOAD modules matched.
An SCSK system engineer created a program in ASSEMBLER to extract the TIMESTAMPs from the DBRM and LOAD modules.
I'm not familiar with BMC's Change Manager and CM/Pilot, but I think it would be more reliable to use a product that provides support.
------------------------------
Kingo Saito KING
Senior Constaltant
Twinz Co., Ltd
Matsudo
+81(47)361-7309
------------------------------
Original Message:
Sent: Tue July 08, 2025 12:18 PM
From: John R Lyle
Subject: Upgrade IBM DB2 V8 to IBM Db2 V12 running under z/OS 2.4 on Z14
Hi Kingo, curious as to why the V8 catalog was unloaded as it cannot be loaded into another catalog. I'm assuming it was used as input to the EXCEL process to generate the necessary user object DDL? And for creating the same environment in V12.....I assume that means you did a brand new V12 install? Just making sure I understand your process. Glad it worked for you.
------------------------------
John R Lyle
Original Message:
Sent: Tue July 08, 2025 12:55 AM
From: Kingo Saito
Subject: Upgrade IBM DB2 V8 to IBM Db2 V12 running under z/OS 2.4 on Z14
I am a Japanese Db2 engineer and have migrated from V8 to V12. I hardened the v12 subsystem to a new machine, unloaded the V8 Db2 catalog, and used EXCEL to generate the DDL. After creating the same environment as V8 in the V12 environment, I unloaded/loaded the data from V8 to V12. For more details, please ask a Japanese company called SCSK. I think it will be the same for V13, not V12.
------------------------------
Kingo Saito KING
Senior Constaltant
Twinz Co., Ltd
Matsudo
+81(47)361-7309
Original Message:
Sent: Fri June 13, 2025 04:00 PM
From: Valter Da Cruz
Subject: Upgrade IBM DB2 V8 to IBM Db2 V12 running under z/OS 2.4 on Z14
Estamos tentando fazer uma migração de de um DB2 v8 para um Db2 V12. Alguém conhece o step-by-step?
------------------------------
Valter Da Cruz
------------------------------