Use
the SQL page to specify default options for building on OS/390® or z/OS®.
- Specifying
settings for debugging
- Select to view and change default build
settings for debugging routines.
- Build
utility name
- Specify the name of the stored procedure build
utility to call when a
stored procedure is built on a z/OS server.
Your database administrator
can configure copies of the build routine to use different resources
as necessary.
The current database is queried to retrieve valid build utility names.
If
valid names are found, you can select them here.
- Build utility schema
- Type the schema for the build utility
that is specified in the Build
utility name field.
- Precompile options
- Type the SQL precompile options that you want to use to build
stored procedures.
See the IBM® DB2® for z/OS Application
Programming and SQL Guide for more information about precompile options.
- Compile options
- Type a string that
specifies compiler options that you want to use with
this stored procedure. If you specify the TEST option, debugging information
is generated when you compile.
- Prelink
options
- Type a string that specifies options for the prelinker.
The prelinker
combines the object modules in an application into a single object
module.
- Link options
- Type a string
that specifies options for your linkage editor. The linkage
editor processes the object module that the prelinker creates and
generates
a load module that can be retrieved for execution.
- Bind options
- Type a string that specifies bind
options for packages.
- Runtime options
- Type a string that specifies run time test options to use with
routines.
If you specify the TEST option, debugging information is generated
at run
time. If you specify the NOTEST option, debugging information is not
generated.
- WLM environment
- Type
the name of the MVS™ workload manager (WLM) environment in which
to run
the routine. The name can contain up to 18 alphanumeric characters.
When you
do not specify a WLM environment, the routine runs in the address
space that
was established when DB2 was installed. When you use
different WLM environments
you can isolate one group of programs from another. For example, you
can isolate
programs based on their security requirements. Work with your system
administrator
to determine whether to use this option.
- Collection
ID
- Type the name of the default 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.