An Easy Data Migration - Is There Such a Thing?

Geese migrating in shape of question mark

“Migrate with One Command”, “Be production-ready in a day”, “Seamless Data Migration” – these are real statements from major data warehousing vendors. They imply that you can experience an effortless data migration to their platform. These claims are compelling, but is there really such a thing as an easy data migration? Based on our experience, data migrations are not easy and definitely not effortless. Sure, the mechanics of moving data from one environment to another have been streamlined by increasingly sophisticated tools, but the physical movement of data is really only a tiny part of a data migration project. It’s like moving house. The truck carrying your stuff may be new, with the latest gadgets for efficient loading and a state of the arts driver's cabin for a smooth ride, but as we all know there is a lot more to a move than that.

Is The Coronavirus Affecting Your Netezza Appliance?

Deadline Extended
We are currently witnessing a global crisis that may lead to many businesses delaying the rolling out of new technologies, including replacing their ageing data warehouse platforms, such as IBM’s Netezza.

Where you may have been retraining your technical staff and preparing your data centers, anticipating the new arrival, many organizations are finding they must now stand down their staff and put everything on hold until the covid-19 crisis has blown over.

Resolving a Failed nzrestore | Smart Associates

Man screaming
It’s every Netezza user’s nightmare, somebody had unintentionally dropped a business-critical production table on their Netezza system and so it needed to be restored immediately otherwise the proverbial would hit the fan. Luckily we were on hand and immediately started the process of restoring from our client’s EMC storage manager.

What happened next is every DBA’s nightmare - the nzrestore failed for a reason that to this day we will never know. We suspected it may have been corrupt backupset metadata, as we were able to recover the individual table file. So with the clock ticking and our client breathing down our neck, we had to manually reconstruct a new backupset and replace the empty table data file with the one we recovered from the storage manager. This is how it was done:
Page 1 / 2 Next Page >
Categories

Tags
Year / Month

Index