Use the Deploy Routines window to specify information for the
native SQL procedure or the version of the native SQL procedure
that you want to deploy to a DB2® for z/OS® database. The source and target
databases for the deployment must both be on a DB2
for z/OS Version 9.1 or later server.
To open the Deploy Routines window:
In the Server Explorer under your DB2 for z/OS data connection, right-click
the procedure or the procedure version that you want to deploy,
and then select Deploy on the shortcut menu.
Location
The target database to which you want to deploy the procedure
or procedure version.
In the list, select an existing data connection, or select
New to define a new connection in the
Add Connection window.
Collection ID
The name of the package collection to use when running
the deployed procedure or procedure version.
Schema
Optional: The name of the schema in the target database to
which to deploy the procedure or procedure version.