Monday, February 14, 2011

Redpaper Data Studio and DB2 for z/OS Stored Procedures

Hi DB2 User,

IBM just published a draft version of a new Redpaper, "Data Studio and DB2 for z/OS Stored Procedures, REDP-4717-00":
http://www.redbooks.ibm.com/Redbooks.nsf/RedpieceAbstracts/redp4717.html?Open

Abstract
Stored procedures can provide major benefits in the areas of application performance, code re-use, security, and integrity. DB2® has offered ever-improving support for developing and operating stored procedures.
This IBM® Redpaper™ is devoted to tools that can be used for accelerating the development and debugging process and in particular to the stored procedure support provided by the latest and fastest evolving IBM product: Data Studio.
We discuss topics related to handling stored procedures. We concentrate on how to use tools for deployment of stored procedures on z/OS®, but most considerations apply to the other members of the DB2 family.
This Redpaper should be considered a major update of Part 6. "Cool tools for an easier life" of the IBM Redbook publication DB2 9 for z/OS Stored Procedures: Through the CALL and Beyond, SG24-7604.

Table of Contents
Chapter 1. The IBM Data Studio V2.2.1
Chapter 2. Developing stored procedures with Data Studio
Chapter 3. Additional development features in the Data Studio products
Chapter 4. Debugging Java procedures with Data Studio
Appendix A. Reference material



More information

- Introducing SYSPROC.ADMIN_INFO_SQL
by Michael Schenker and Thomas Conrad



Regards,

DB2usa.