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 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.
© 2020 Vervante Corporation. All rights reserved.