Articles & Content


Stored Procedures: If, When and How (F08)

Topic: 2007 NA

Subtopic: DB2 for z/OS

DATE: 2007-5-8 (04:20 PM - 05:20 PM)
SPEAKERS: Konstantin Tadenev (UPS)

Making decisions about applicability and design of DB2 stored procedures can be a daunting task. Business requirements, architecture strategies and technology context influence our choices. This presentation offers a rationalized approach to this challenge, and is based on six years of enterprise experience of implementing over 2,000 stored procedures in various business, information and technology scenarios.

EXP. LEVEL: Intermediate,Advanced


Items to be considered before making a decision to use stored procedures: server topology, security and portability requirements, potential for reuse, SOA opportunities, and overhead tradeoffs

Stored procedures design principles: more SQL and business logic within a proc whenever possible, unit-of-work control techniques, overhead reduction (e.g., GTT vs. PARM, metadata calls), thread reuse, dynamic vs. static SQL considerations, etc.

Implementation principles: types and use of JDBC drivers, connection pooling and heartbeat check, keeping the number of active and inactive threads under control

Real life examples of common errors in decision making about use and design of stored procedures

Examples of requirements and implementation scenarios

This file is being provided by IDUG. We would encourage you to join IDUG to get full access to all of our files and resources. Joining IDUG is FREE and signing up is simple. Click here to join! or login!

Download File
Click to Download

NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.