Articles & Content

Archives

Stored Procedures: If, When and How (F08)

Topic: DB2 for z/OS

Subtopic: 2007



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

OBJECTIVES:

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



Click Here to Download

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