Articles & Content


WAS/DB2 UDB: Pooling and Caching (J11)

Topic: DB2 for z/OS

Subtopic: 2005

DATE: 2005-5-25 (10:00 AM - 11:10 AM)
SPEAKERS: Maryela Weihrauch (IBM Silicon Valley Laboratory)

Setting up web applications for optimal resource usage and maximum performance can be a challange for WebSphere and DB2 UDB administrators. The concept of connection pool and statement cache help to achieve this goal and are well known in both products. Do they mean the same? Maryela explains the concept of statement cache and connection pool in DB2 UDB as well as WebSphere. Mainly, she discusses how to get the most out of them.

EXP. LEVEL: Intermediate,Advanced


DB2 UDB statement caching, connection pooling

WebSphere connection pooling

WebSphere prepared statement caching

Discussion of usage scenarios

Considerations to keepdymanic yes, cursor hold ..

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.