Hi Largu,
the switch from Db2 (on prem) to Db2 Warehouse (on prem) is more a licensing issue and re-configuration issue, than migrating data as there is a Db2 underneath. It would be just backup/restore.
But -- well -- for a performant DWH, you have to adapt the different architecture and partitioning, dockerization and so on. For Db2 11.1 there is still a description in the docs
https://www.ibm.com/docs/en/db2/11.1?topic=analytics-migrating-data-warehousing-in-db2-version-111x which was not copied over to Db2 11.5 docs as the packaging of Db2, Db2 Warehouse and IBM strategy about CloudPak for Data changed.
https://www.ibm.com/docs/en/cloud-paks/cp-data/4.0For moving to containers you could look at the new feature Click-to-containerize, found here
https://www.ibm.com/docs/en/db2/11.5?topic=deployments-db2-click-containerizeCheers
------------------------------
Roland Schock
Distinguished Engineer
ARS Computer und Consulting GmbH
Muenchen
------------------------------
Original Message:
Sent: Wed January 12, 2022 01:19 PM
From: Largou walid
Subject: DB2 Strategy for Analytics : BLU or WareHouse
Hi Everyone,
We are currently running DB2 11.1 for LUW and we want to modernise our analytics platform. The trade-up to Cloud Pak for Data seems the right choice, but there are some considerations that I think are not well explained. Should customer use BLU with their current db2 setup or should they consider to use Db2 Warehouse ? (this is for analytics)
Is there any documentation on how to migrate from DB2 LUW to Db2 Warehouse (on-premises) ?
Is there also any documentation from migrating from DB2 LUW to Cloud Pak for Data ?
Thank you
------------------------------
Largou walid
------------------------------
#Db2