Redbook DB2 9 for z/OS Stored Procedures: Through the CALL and Beyond
Hi DB2 User,
IBM just published a draft version of a new Redbook, "DB2 9 for z/OS Stored Procedures: Through the CALL and Beyond, SG24-7604-00 " :
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 an 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-00, and it reflects the changes that have happened 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 which can be used for accelerating the development process and go in some detail about the stored procedure support provided by the latest IBM product: Data Studio.
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 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