Redbooks 2004-2006

Hi DB2 user,

Here is a list of Redbooks about DB2 for z/OS published or updated between 2004 and 2006, available on IBM website:

Version 8
- Version 8: Everything You Ever Wanted to Know , ... and More, SG24-6079-00
- DB2 UDB for z/OS Version 8 Performance Topics, SG24-6465-00

- LOBs with DB2 for z/OS: Stronger and Faster, SG24-7270-00
- Design Guidelines for High Performance and Availability, SG24-7134-00
- Multilevel Security and DB2 Row-Level Security Revealed, SG24-6480-00

- DB2 V8: Through the Looking Glass and What SAP Found There, SG24-7088-00
- DB2 UDB V8 and WebSphere V5 Performance Tuning and Operations, SG24-7068-00
- Best Practices for SAP Business Information Warehouse on DB2 V8, SG24-6489-00

- The Business Value of DB2 UDB for z/OS, SG24-6763-00


Other subjects
- DB2 for z/OS: Data Sharing in a Nutshell, SG24-7322-00
- Data Integrity with DB2 for z/OS, SG24-7111-00
- Disaster Recovery with DB2 UDB for z/OS, SG24-6370-00

- Powering SOA with IBM Data Servers, SG24-7259-00
- DB2 for z/OS Stored Procedures: Through the CALL and Beyond, SG24-7083-00
- DB2 for z/OS and OS/390: Ready for Java, SG24-6435-00
- DB2 for z/OS and WebSphere: The Perfect Couple, SG24-6319-00

- DB2 for z/OS and OS/390 Version 7 Using the Utilities Suite, SG24-6289-00


Redpapers
- How does the MIDAW facility improve the performance ... using DB2?, REDP-4201-00
- Disk storage access with DB2 for z/OS, REDP-4187-00

- Coupling Facility Performance: A Real World Perspective, REDP-4014-00


Tips
- SAP BW and DB2 for z/OS V8, TIPS0577
- Copying the DB2 UDB for z/OS Catalog Using the COPY Utility, TIPS0587



Regards,

DB2usa.

Redbook LOBs with DB2 for z/OS: Stronger and Faster

Bonjour,

IBM just published a new Redbook, "LOBs with DB2 for z/OS: Stronger and Faster, SG24-7270-00" :
http://www.redbooks.ibm.com/abstracts/sg247270.html?Open


Abstract
The requirements for a database management system (DBMS) have included support for very large and complex data objects.DB2 UDB for OS/390 Version 6 introduced the support for large objects (LOBs): they can contain text documents, images, or movies, and can be stored directly in the DBMS with sizes up to 2 gigabytes per object and 65,536 TB for a single LOB column in a 4,096 partition table. The introduction of these new data types has implied some changes in the administration processes and programming techniques. The IBM Redbook Large Objects with DB2 for z/OS and OS/390, SG24-6571, introduced and described the usage of LOBs with DB2 for z/OS at Version 7 level.Major enhancements for LOB manipulation have been introduced with DB2 UDB for z/OS Version 8 and DB2 Version 9.1 for z/OS (DB2 9 in this IBM Redbook). These enhancements include performance functions such as the avoidance of LOB locks and DRDA LOB flow optimization, usability functions such as file reference variables, FETCH CONTINUE, and the automatic creation of objects. DB2 utilities provide integrated support with LOAD and UNLOAD, Cross Loader, REORG, CHECK DATA, and CHECK LOB.In this IBM Redbook, we provide a totally revised description of the DB2 functions for LOB support as well as useful information about how to design and implement LOBs. We also offer examples of their use, programming considerations, and the enhanced processes used for their administration and maintenance. We also detail how SAP solutions use LOBs.

This IBM Redbook replaces the previous IBM Redbook, Large Objects with DB2 for z/OS and OS/390, SG24-6571, for DB2 Version 8 and Version 9.1.

Table of Contents
Introduction
Large objects with DB2
Creating LOBs
Using LOBs
SAP and LOBs
Utilities with LOBs
Data administration with LOBs
Performance with LOBs
Additional material



More information

Here is a presentation of Maryela Weihrauch (IBM SVL) about LOBs with DB2 for z/OS, available on IBM website:

- Exciting News about LOBs in DB2 9 for z/OS


Regards,

DB2usa.

IBM Technical Sales Support Presentations

Hi DB2 user,

You will find below several presentations about DB2 for z/OS from IBM Technical Sales Support:

- z9 zIIP Measurements: SAP OLTP, BI Batch, SAP BW Query, and DB2 Utility Workloads
by Michal Sheets

- Can the IBM System z9 Integrated Information Processors (zIIP) be used with SAP?
by Luanne Carlton



- DB2 for z/OS Universal JDBC Driver Samples
by Judy Ruby-Brown

- Tuning DB2 Group Buffer Pools the Couch Potato Way using Auto Alter
by Judy Ruby-Brown



- Tuning SAP / DB2 Universal Database / zSeries
by Mark Gordon

- DBM1 Virtual Storage Tuning when migrating SAP DB2 z/OS system to DB2 V8
by Mary Siart



- Performance Benefits of DB2 for z/OS Version 8 with PeopleSoft
by Michael Curtis

- PeopleSoft and z/OS DB2 Performance Management Using the Workload Manager
by Terry Elliot



Regards,

DB2usa.