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.

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