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:

Countdown to Netezza End-of-Life | Smart Associates

As you probably know the date is rapidly approaching when IBM stops supporting Netezza. On 30th June 2019, TwinFin (N1000) generation Netezza customers were the first to be affected. Like any technology, of course, Netezza has aged and it's time for Netezza users to reevaluate their needs and adopt something new. It's an exciting time - there are many candidates to replace it.

< Previous Page Page 2 / 2
Categories

Tags
Year / Month

Index