Hi Raj,
no, HADR is only possible between system on the same level and same platform. It is based on Log Shipping and pureScale instances and single server instances have different requirements.
The official path for a pureScale migration is only the offline backup.
But you might want to try to install a single Db2 instance on your new systems first, do a redirected restore via an online backup plus rollforward as desired. Then do a db2checkSD and try to update the instance to a single node pureScale instance. See
https://www.ibm.com/support/knowledgecenter/SSEPGG_11.5.0/com.ibm.db2.luw.qb.server.doc/doc/c0056330.htmlAfter that try to add some other nodes and create your pureScale cluster as desired. If this test system runs, tear it down again,
create a single node instance and redo your redirected restore of the prod database plus rollforwards.
On the day of your prod migration, you just have to stop your prod database, do the last rollforwards in the new system (aka keep it updated inbetween) and do all the above steps.
In the end, it should bring your migration down from 8+ hours for backup/restore to a faster method, as you have already copied the
data over and have established a procedure to do the migration.
Kind regards
------------------------------
Roland Schock
Distinguished Engineer
ARS Computer und Consulting GmbH
Muenchen
------------------------------
Original Message:
Sent: Wed August 26, 2020 03:55 AM
From: Rizwan Ali
Subject: Migration to Db2 PureScale V11.1.4.5
Hi Prashant,
Wow! not a bad idea :D
can you tell me if i can configure HADR between PureScale and Standalone db2 databases? will i be able to do switchover?
Really Appreciate your feedback!
Best Regards,
Rizwan
------------------------------
Rizwan Ali
Original Message:
Sent: Wed August 26, 2020 01:01 AM
From: PRASHANT SHIVMATH
Subject: Migration to Db2 PureScale V11.1.4.5
Hi Raj,
Create a separate environment and do the db restoration with online backup and rollforward the db till non peak hour and bring the db in connectivity stage and take the offlline backup and restore the db in Purescale db..
Missing point in time data you can do the export and import/Load if you are aware of table where new data is getting populated on table.. If you have 10 table I think it is doable.. you need to plan and work with Apps Team..
Kind Regards
Prashant Shivmath
Mobile : +91-9892691478
Email : prashant.shivmath@in.ibm.com
Rizwan Joo via IBM Community ---26-08-2020 00:22:15---Hi Ian, Thanks for Commenting!
Original Message:
Sent: 8/25/2020 2:52:00 PM
From: Rizwan Joo
Subject: RE: Migration to Db2 PureScale V11.1.4.5
Hi Ian,
Thanks for Commenting!
Yes, i know that an offline backup can be restored on PureScale instance but we don't take offline backups as it takes around 8 hours for full offline backup and its not possible to stop production for this long.
Coming to Q-replication, i have started working on this, Q-replication completely depends on Ibm MQ and i have zero experience on Q-replication and MQ.
Not sure how to set it up step by step!
As i need to replicate whole database from production to new PureScale and once its in sync completely i want to switch application to connect to PureScale on the fly.
Any help in this regards will be appreciated!
Regards,
RAJ
------------------------------
Rizwan Joo
Original Message:
Sent: Tue August 25, 2020 09:45 AM
From: Ian Bjorhovde
Subject: Migration to Db2 PureScale V11.1.4.5
Rizwan,
Have you seen this page, which describes how to restore an ESE database to pureScale? https://www.ibm.com/support/knowledgecenter/SSEPGG_11.1.0/com.ibm.db2.luw.admin.ha.doc/doc/t0061012.html
If you can't afford the downtime required for the offline backup / restore / conversion, have you considered using a solution like replication (Q-Rep)?
------------------------------
Ian Bjorhovde
XTIVIA
Phoenix AZ
Original Message:
Sent: Tue August 25, 2020 01:47 AM
From: Rizwan Joo
Subject: Migration to Db2 PureScale V11.1.4.5
Hi Roland,
Thank you for commenting!
Yes Migration to new system is the only option. I have already gone though all the facts of using DB2 PureScale and Migrating standalone instance to PureScale instance.
I have installed a 2 node PureScale Cluster on AIX 7.1 DB2 11.1.4.5 with GPFS/TSA Tiebreaker and all recommended settings.
The real problem here is that, now i have to restore my production db backup to newly created PureScale instance but DB2 don't allow me to restore standalone instance db backup to PureSclae cluster instance :(
I went to seek other options. I found that i have to do an instance upgrade and that is the only option if you want to convert your existing db2 standalone instance to purescale instance and then add new members to it.
can you share your experience on this scenario? how can i migrate to purescale instance with minumum downtime?
Best Regards,
RAJ
------------------------------
Rizwan Joo
Original Message:
Sent: Tue August 25, 2020 12:55 AM
From: Roland Schock
Subject: Migration to Db2 PureScale V11.1.4.5
Hi RAJ,
first of all, I wouldn't do an inplace upgrade but ONLY a migration into a new system.
Get familiar with db2prereqcheck and all the parameters to test your new system. Also check your database, if it can be converted to pureScale.
Read all pages in the Knowledge Center about installing pureScale thoroughly!
With AIX I assume, you are going to use multiple LPARs in several machines, probably with TCP as cluster connect instead of IB. That's good.
If your shop has to purchase a bunch of more Db2 licenses for that install, try to get someone from tech presales from IBM to assist you.
Good luck!
Roland
------------------------------
Roland Schock
Distinguished Engineer
ARS Computer und Consulting GmbH
Muenchen
Original Message:
Sent: Mon August 24, 2020 11:09 PM
From: Rizwan Joo
Subject: Migration to Db2 PureScale V11.1.4.5
Hi Gurus,
I am running DB2 V11.1.4.5 on AIX 7.1 on Production standalone instance.
Target is to migrate/upgrade Db2 Standalone to PureScale Instance. I have been working on this for last 6 months and i am still looking for best solution or way to upgrade to PureScale with minimum down time.
I would highly appreciate your input in this!
Regards,
RAJ
------------------------------
Rizwan Joo
------------------------------
#Db2