Articles & Content
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!Click to Download
NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.