IBM PureData System for Analytics, Version 7.1

Netezza SQL Extensions installation and setup

The IBM® Netezza® SQL Extensions toolkit is an optional package that contains additional SQL functions for IBM Netezza data warehouse appliances.

The following topics describe how to install and configure the Netezza SQL Extensions toolkit on a Netezza system, and special information for managing backups and upgrades.

Software availability
Users who have access to IBM Passport Advantage® or IBM Fix Central can obtain the SQL Extensions installation files and documentation. Users must have accounts and the appropriate support permissions to download the software from these locations.
Netezza system prerequisites
Review this information for a summary of the appliances on which the SQL Extensions toolkit is supported.
Installing the Netezza SQL Extensions toolkit
To install the IBM Netezza SQL Extensions toolkit, you must copy the software package to the Netezza system and uncompress the file.
Enabling SQL functions support in a database
After you extract the IBM Netezza SQL Extensions toolkit files, you can enable SQL Extensions query support by registering the SQL Extensions functions and API.
User account permissions and requirements
To run a SQL Extensions query, IBM Netezza user accounts must have the Execute permission for function and aggregate objects, and for the toolkit functions and aggregates that are added to the system.
Display the SQL Extensions toolkit version
You can use the regexp_version() SQL function to display the version of the XML functions available in the IBM Netezza SQL Extensions toolkit.
Upgrade the SQL Extensions toolkit
Update kits for the IBM Netezza SQL Extensions toolkit include fixes or enhancements to the functionality.
Disabling the SQL Extensions toolkit in a database
You can disable the SQL Extensions functions by removing them from the database and schema where they are installed.
Remove the SQL Extensions toolkit
You can remove or uninstall the IBM Netezza SQL Extensions toolkit from a Netezza system.
Different versions of the SQL Extensions toolkit
You can install a new version of the SQL Extensions toolkit to a database for testing and comparison purposes, but make sure to update your production databases with the latest toolkit.
Upgrade Netezza systems with the SQL Extensions toolkit
After you install the IBM Netezza SQL Extensions toolkit, take special precautions before you patch or upgrade the Netezza software on your system.
Backups and restores of the Netezza data
Keep a backup copy of the SQL Extensions toolkit installation files in a safe location outside of the IBM Netezza system.
Known issues