DB2 9 for z/OS Stored Procedures: Through the CALL and Beyond

An IBM Redbooks publication

Note: This is publication is now archived. For reference only.

Published 31 March 2008, updated 17 February 2011

cover image

ISBN-10: 0738485934
ISBN-13: 9780738485935
IBM Form #: SG24-7604-00
(972 pages)

More options

Rate and comment

Authors: Paolo Bruni, Sabine Kaschta, Marcel Kutsch, Glenn McGeoch, Marichu Scanlon, Jan Vandensande


This IBM® Redbooks® publication helps you design, install, manage, and tune stored procedures with DB2® 9 for z/OS® . 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.
In these days, three years is a generation in the software business; if you have DB2 9 for z/OS, this book replaces the previous DB2 for z/OS Stored Procedures: Through the CALL and Beyond, SG24-7083; it reflects the changes that have been made to DB2 stored procedures and related tools from V8 to V9.
We show how to develop stored procedures in several languages, including Java™ ; we explore the functions available for the z/OS platform deployment; and provide recommendations on setting up and tuning the appropriate stored procedure environment.
We talk about the external and native SQL procedures, the debugging options, the special registers, the deployment, and diagnostics.
A chapter is devoted to the increasing number of DB2-supplied stored procedures. They can be used for almost all of a DBA’s tasks.
We also devote a part to tools that can be used for accelerating the development process and go into some detail about the stored procedure support provided by the latest IBM product: Data Studio. For recent information on Data Studio, refer to Data Studio and DB2 for z/OS Stored Procedures, REDP-4717.

For the official product information about DB2 for z/OS stored procedures, which is updated and maintained regularly, see "Implementing DB2 stored procedures" in the Information Management Software for z/OS® Solutions Information Center.

Table of contents

Part 1. Introduction
Chapter 1. Importance of stored procedures
Chapter 2. Stored procedures overview
Chapter 3. Our case study
Part 2. Operating environment
Chapter 4. Setting up and managing Workload Manager
Chapter 5. Language Environment setup
Chapter 6. RRSAF
Chapter 7. Security and authorization
Chapter 8. Operational issues
Part 3. Developing stored procedures
Chapter 9. Defining stored procedures
Chapter 10. COBOL programming
Chapter 11. C programming
Chapter 12. REXX programming
Chapter 13. Java stored procedures
Chapter 14. External SQL procedures
Chapter 15. Native SQL procedures
Chapter 16. Debugging
Chapter 17. Remote stored procedure calls
Chapter 18. Code level management
Part 4. Performance
Chapter 19. General performance considerations
Chapter 20. Server address space management
Chapter 21. I/O performance management
Part 5. Extending the functions
Chapter 22. Multi-threaded stored procedures in the C language
Chapter 23. Accessing CICS and IMS
Chapter 24. DB2-supplied stored procedures
Chapter 25. Using LOBs and XML
Chapter 26. Using triggers and UDFs
Part 6. Cool tools for an easier life
Chapter 27. The IBM Data Studio
Chapter 28. Tools for debugging DB2 stored procedures
Chapter 29. Debugging DB2 V8 Java procedures with Data Studio
Appendix A. Samples for using DB2-supplied stored procedures
Appendix B. Additional material

Others who read this publication also read

Follow IBM Redbooks

Follow IBM Redbooks