You might need to redistribute a previously registered archive file (specifically, a JAR or ZIP file) to all nodes of a database system during copy, migrate, or system restore operations.
To redistribute a previously registered archive file to all nodes of a database system, use the SQLJ.REDISTRIBUTE_JAR external stored procedure. The archive file to be redistributed must have been registered using the SQLJ.INSTALL_JAR external stored procedure.
Before You Begin
Take the following steps before you redistribute a previously registered archive file for an external routine:
- Verify you have the EXECUTE privilege on the SQLJ.REDISTRIBUTE_JAR external stored procedure.
- If the default database is not the same as the default database with which the archive file was registered, use the DATABASE statement to change the default database.
- Verify you have the DROP PROCEDURE or DROP FUNCTION privilege on any of the following objects:
- The default database
- The object that you are redistributing, identified by the SQL identifier that was passed to SQLJ.INSTALL_JAR