DB2 9 For Z/OsStored Procedures: Through The Call & Beyond, 968 Pgs

0.0

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. 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

0.0

s Paolo Bruni is a DB2 Information Management Project Leader at the International Technical Support Organization, San Jose Center. He has authored several Redbooks about DB2 for z/OS and related tools, and has conducted workshops and seminars worldwide. During Paolo's many years with IBM, in development, and in the field, his work has been mostly related to database systems. Sabine Kaschta is a DB2 Specialist working for IBM Global Learning Services in Germany as an education consultant. She has 14 years of experience working with DB2. Before joining IBM in 1998, she worked for a third-party vendor providing second-level support for DB2 utilities. She is experienced in DB2 system programming and client/server implementations in the insurance industry in Germany. She is also a co-author of the IBM Redbooks DB2 UDB for OS/390 and Continuous Availability, SG24-54866; Cross-Platform DB2 Distributed Stored Procedures: Building and Debugging, SG24-5485-01; DB2 UDB for z/OS Version 8: Everything You Ever Wanted to Know, ... and More, SG24-6079; and DB2 9 for z/OS Technical Overview, SG24-7330. Marcel Kutsch is a software engineer at the IBM Boeblingen Laboratory in Germany. He is currently working on the design and development of stored procedures and the administrative task scheduler component of DB2for z/OS. Prior to joining IBM, Marcel worked for two internships at the IBM Almaden Research Center, focusing on DB2's query optimization for DB2 on Linux, UNIX, and Windows. Marcel's first assignment at IBM, after graduating from the university in 2005, was on DB2 autonomic features. Glenn McGeoch is a Senior DB2 Consultant for IBM's DB2 for z/OS Lab Services organization in the United States, working out of San Francisco, CA.