Routine and JAR file deployment

You can use a wizard to deploy routines to a database server, or you can deploy routines by selecting the Deploy check box on the New Stored Procedure wizard or the New User-Defined Function wizard. You can also use a wizard to deploy JAR files to a database server.
You can deploy stored procedures for DB2® for Linux®, UNIX®, and Windows® or DB2 for z/OS® in one of two ways:
On the Deploy Options page of the Deploy Routines wizard, you specify which of these two deploy options that you want to use. Binary deployment is supported for the following servers and routine types:
Data server Routine type
DB2 for Linux, UNIX, and Windows, Version 8.2 or higher SQL, JDBC and SQLJ stored procedures
DB2 for z/OS, Version 8 (new-function mode) and Version 9 External SQL, JDBC and SQLJ stored procedures
DB2 for z/OS Version 9 Native SQL stored procedures
Restriction:

The following restrictions apply to binary deployment:

In some cases, you can create a routine using one server definition, and then deploy it to the same type of server or to a server with a different server definition. On the Deploy Options page of the Deploy Routines wizard, you can specify a different database. The following server combinations are supported:
Source routine Target server
SQL stored procedure for DB2 for Linux, UNIX, and Windows
  • DB2 for Linux, UNIX, and Windows
  • DB2 for iSeries®
  • DB2 for z/OS
Java stored procedure for DB2 for Linux, UNIX, and Windows
  • DB2 for Linux, UNIX, and Windows
  • DB2 for iSeries
  • DB2 for z/OS
  • IBM Cloudscape®

Feedback