Preferences window - SQL page

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.

Comentarios