Disabling IBM® SQL Extensions toolkit functions

You can disable the SQL Extensions functions by removing them from the database and schema where they are installed.

1. Log in to the Netezza Performance Server system with the root user account.
2. Change to the installation location of the XML functions in the toolkit. An example follows:

   cd install-dir/libnetxml/version 
   

3. Issue the following command, specifying the database name, the schema name if required, the Netezza Performance Server user name, and the password for your system:

      ./install -R -d dbname -schema schemaname -u username -W password
   

   Sample output follows:

   
   Uninstalling libnetxml from schema schemaname of database tester: 
   ............................................... Done
   

   For Netezza Performance Server Release 7.0.3 or later systems that use multiple schemas, you can use the -schema option to specify the schema from which you want to remove the functions. If you do not specify a schema, the command uses the value of the NZ_SCHEMA variable or the default schema for the database.

4. Change to the installation location of the rest of the functions in the toolkit. An example follows:

      cd install-dir/libnetcrypto/version 
   

5. Issue the following command, specifying the database name, the schema name, the Netezza Performance Server user name, and the password for your system:

      ./install -R -d dbname -u username -W password
   

   Sample output follows:

   
   Uninstalling libnetcrypto from schema schemaname of database tester: 
   ............................................... Done
   

6. Repeat steps 2 - 5 for each database or schema in which you want to disable the SQL Extensions query support.