Routine Editor - Stored Procedure - Deploy page

Use the Deploy page to specify deploy options for the stored procedure. Depending on whether you are using DB2® for LUW, DB2 for iSeries™, DB2 for z/Series, or Derby, some of these fields may not apply to you.
Precompile options
Type the SQL precompile options that you want to use for building this SQL stored procedure.
Compile options
Type a string that specifies the compiler options to use with this stored procedure.
Bind options
Shows a string that specifies the bind options for packages. The default options are ACTION(REPLACE) and ISOLATION(CS). ACTION(REPLACE) specifies that the package replaces an existing package with the same name. ISOLATION(CS) ensures that your application does not read a row that another process changes until the process releases that row
Collection ID
Type the name of the collection ID. The collection ID identifies the package collection that is used when the stored procedure is run. The name can contain up to 18 alphanumeric characters. If you are creating a Java™ stored procedure for z/OS®, the collection ID that you specify in this field must match the one that was used when binding the JDBC driver on DB2 for z/OS.
Root package
DB2 for Linux®, UNIX®, and Windows® only: Type the root name of the packages that the SQLJ binder will create. If an option is not specified, a root name will be derived from the name of the profile. The names will have a maximum length of seven characters. The digits 1, 2, 3, and 4 will be appended to the root package name to create the four final package names (one for each isolation level). Packages are bound with the following isolation levels: PACKAGENAME1 bound with isolation level UR; PACKAGENAME2 bound with isolation level CS; PACKAGENAME3 bound with isolation level RS; PACKAGENAME4 bound with isolation level RR.
WLM environment
Shows the name of the MVS™ workload manager (WLM) environment in which the stored procedure runs. To change the WLM environment for a SQL stored procedure, modify the WLM ENVIRONMENT in the source page.
Build utility
Type the name of the stored procedure build utility to call when building a SQL stored procedure on a z/OS server. Your DBA can configure copies of build routine to use different resources as necessary. These custom routines are called build utilities and are identified with unique names.
Build owner
Type the DB2 for z/OS authorization ID that will hold responsibility for building, rebuilding, and dropping the routine. By specifying a secondary authorization ID or group name as the build owner, more than one user could share responsibility for maintaining this routine. If you do not specify a build owner, the build utility designates one of your process authorization IDs, such as the CURRENT SQLID, as the build owner.
Prelink options
Type a string that specifies the prelink options for the pre-linker. The pre-linker combines object modules that comprise an application into a single object module. See the documentation for your pre-linker.
Link options
Type a string that specifies the link options for your linkage editor. The linkage editor processes the object module created by the pre-linker and generates a load module that can be retrieved for execution. See the documentation for your linkage editor.
Java compile options
Type the Java compile options that you want to use when building the stored procedure. Consult your Java compiler documentation for the valid Java compile options.
Verbose build
Select the check box to view the detailed status of the progress of the build, The build messages are displayed in the Output view when you deploy the procedure.
Build stored procedure on the server
For Java stored procedures only: Select this option to build stored procedures by using DSNTJSPP on the DB2 for z/OS server. If you do not select this option, the Java source is compiled on the client. This option limits stored procedure source code to 32 KB. Otherwise, source code can be up to 10 MB.
DB2 Package
DB2 for iSeries only: Specify the DB2 package name that you want to use when building SQLJ stored procedures. For example, QUSRSYS/SER3283432 where QUSRSYS is a library name which is followed by a 10 character serialized profile name. For information about valid values, see the DB2 documentation on building SQLJ stored procedures.
Enable debugging
DB2 for Linux, UNIX, and Windows only: Select to build the stored procedure for debugging.

Feedback