Functions and Stored Procedures

Design Tuning IBM DB2 MySQL Oracle SQL Server

Workload Manager Environment
Functions and stored procedures can be defined with either `NO WLM ENVIRONMENT` or with a specific workload manager environment. In the latter case, the application environment must be configured in the active Workload Manager policy (see DB2 for z/OS and OS/390: Ready for Java) and RRS (Resource Recovery Services) must be running (see the System Programmer's Guide to Resource Recovery Services (RRS)). Routines in different DB2 regions or with different performance characteristics (transactions vs. reports, for example) should be configured with different application environment names so they will run in different address spaces with appropriate priorities. back to top

Functions and stored procedures can be defined with either NO WLM ENVIRONMENT or with a specific workload manager environment. In the latter case, the application environment must be configured in the active Workload Manager policy (see DB2 for z/OS and OS/390: Ready for Java) and RRS (Resource Recovery Services) must be running (see the System Programmer's Guide to Resource Recovery Services (RRS)). Routines in different DB2 regions or with different performance characteristics (transactions vs. reports, for example) should be configured with different application environment names so they will run in different address spaces with appropriate priorities.

Last updated Monday October 9, 2006

Printer-friendly PDF* format:

Functions and Stored Procedures

How To Guides for IBM DB2 UDB Databases

This Section

You are currently viewing this page in XHTML 1 Style Sheet* format (* see Clicklets for more infomation). This document is also available in XHTML 1*XML*HTML 4*HTML 5 Style Sheet*HTML 5 XML*HTML 5 non-XML* XHTML 2* XHTML Mobile* WML Mobile* and printer-friendly PDF* formats. This is accomplished with Single Source Publishing, a content management system that uses templates in XSLT style sheets provided by XML Styles .com to transform the source content for various content delivery channels. There is also RDF* metadata that describes the content of this document.