Skip to main content

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 on 31 March 2008, updated 17 February 2011

  1. .PDF (10.0 MB)

Share this page:   

ISBN-10: 0738485934
ISBN-13: 9780738485935
IBM Form #: SG24-7604-00

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

    menu icon


    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 also read