Partitioning with DB2 for z/OS

Hi DB2 user,

Here are two presentations about partitioning with DB2 for z/OS Version 8, available on Guide Share France website:

- Partitioning Scary Stories
by Phil Grainger

- Table Controlled Partitioning - The rules of the game
by Kurt Struyf


More information

- Partitioning in DB2 8 for z/OS - The Good, The Bad and The Ugly
by Steen Rasmussen

- Not Your Father's Partitioned Table!
by Craig Friske

- DB2 Managing Large Partitioned Tables in V8
by Craig Friske

- Major Index Changes in DB2 Version 8
by Jim Teng


Regards,

DB2usa.

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 " :
http://www.redbooks.ibm.com/redpieces/abstracts/sg247604.html

Abstract
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


Regards,

DB2usa.

More IBM Technotes (FAQ) about DB2 for z/OS

Hi DB2 user,

Here are more Technotes (FAQ), available on IBM DB2 for z/OS website:

- Is it necessary to increase the size of DB2 group buffer pools?
- Attempting to load more data than fits into the data set
- Unicode data is converted to hex strings

- Nested Stored Procedures
- Enabling trusted connections requires support for distributed identity mapping
- How to access an alias in a distributed environment?

- How do I determine the number of rows in the result table of a cursor?
- Grant insert authority on view fails with SQLCODE -551
- MAX and MIN built-in functions

- Resetting REORP and RECP after REORG fails and SYSUT1 is no longer available
- What is DB2 Accounting Class 2 Not Accounted Time?
- What are the dispositions for data sets that are dynamically allocated by utilities?

- Does DB2 normally recover a unit of recovery without calling for an archive log?
- Reducing accounting records
- How do I reallocate DSNDB07 work files that are used for sort processing?



Regards,

DB2usa.

z/Journal (December 2007 - January 2008 issue)

Hi DB2 user,

Articles from December 2007 - January 2008 issue of z/Journal are available online: http://www.zjournal.com


- The Mathematics of Bad Luck: Risk Management in a DB2 Environment
by Karl Henn

- The Evolution of Database Security
by Craig Mullins


Here is a new blog about DB2 z/OS from Peggy Zagelow (IBM SVL) available on IBM website:

- Hot Topics around DB2 for z/OS


Regards,

DB2usa.