Articles & Content


Techniques for the Well-Dressed DB2 Stored Procedure (F12)

Topic: Cross Platform DB2 for z/OS & LUW

Subtopic: 2007

DATE: 2007-5-10 (09:20 AM - 10:20 AM)
SPEAKERS: Dona Bell (Database Administrator)

Do your business and Application users know what DB2 stored procedures are? Learn the benefits of DB2 stored procedures, and when NOT to use them.Learn the importance of techniques to use when calling DB2 stored procedures, bind considerations, and the roles DBAs play in developing and maintaining DB2 stored procedures.Discuss case histories, with both good, bad and downright ugly experiences with stored procedures.

EXP. LEVEL: Beginner,Intermediate


Define a well-dressed DB2 stored procedure

Best methods to improve calls of stored procedures

Performance impacts of technical choices

The roles of DBAs in stored procedure maintenance

The good, bad, and ugly ways to use stored procedures

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.