Backups and restores of Netezza Performance Server data

Keep a backup copy of the IBM® SQL Extensions toolkit installation files in a safe location outside the Netezza Performance Server system.

Make sure that you have recent backups of your Netezza Performance Server systems to recover from an accidental change to your data or to restore Netezza Performance Server services as part of a disaster recovery situation.

No special requirements or procedures are needed to back up the SQL Extensions functions. After you register the toolkit functions on a Netezza Performance Server system, they and their associated object source files are backed up during the normal Netezza Performance Server nzbackup operations. If you alter functions, perhaps as a result of new object files with fixes, the next incremental backup captures only the new object files.

If you perform a "no-data" restore by using the nzrestore argument, specify both the -noData argument and the -allIncs argument. The -allIncs argument restores the object files from all available backup increments so that any referenced functions will be created and executable following the restore. If you attempt a no-data restore on an increment that does not have function object files (because they were not altered during the time period that was captured by the incremental backup), the restore process creates zero-length placeholder object files for those functions and logs the signatures of the incomplete functions in the restoresvr log file. The resulting functions are defined in the database, but you cannot execute them because you did not restore their object files. You must use CREATE OR REPLACE commands to update the functions with their necessary object files.