DB2 for z/OS Year in Review 2009

Hi DB2 user,

Here is the list of 2009 DB2usa Blog posts:

- UK GSE Conference 2008 presentations
- z/Journal (October - November 2008 issue)
- Technotes (FAQ), Withdrawal Announcement and Upcoming Redbook residencies
- Redbook DB2 9 for z/OS: Packages Revisited
- IDUG Solutions Journal (Winter 2008)
- DB2 articles from z/OS Hot Topics newsletter
- Presentations from New England DB2 Users Group
- Redbook 50 TB Data Warehouse Benchmark on IBM System z
- Presentations from Colorado DB2 Users Group
- DB2 for z/OS Year in Review 2008

- Presentations from IBM DB2 9 for z/OS Migration Seminar (France)
- DB2mag Winter 2008
- XML functionality in DB2 for z/OS
- Presentations from IBM DB2 for z/OS Performance Seminar (Japan)
- Presentations from Midwest Database Users Group
- More presentations from UK DB2 User Group
- z/Journal (February - March and April - May 2009 issues)
- DB2 for z/OS Version Polls (2009)
- Presentations from SQL Adria
- Redbook DB2 9 for z/OS Distributed Architecture

- IBM DB2 Utililies presentations
- Articles from IBM Techdocs Library
- z/Journal (June - July 2009 issue)
- Akira Shibamiya's presentations
- CDUG 2009 Tech Forum's presentations (Shanghai, China)
- Robert Catterall's presentations
- DB2 9 for z/OS Performance Features by Dave Beulke
- IDUG Solutions Journal (Summer 2009)
- Redpaper DB2 9 for z/OS: Buffer Pool Monitoring and Tuning
- z/Journal (August - September 2009 issue)

- Susan Lawson and Dan Luksetich's presentations
- Roger Miller's presentations about DB2 9 for z/OS
- IBM 2009 Technotes (FAQ) about DB2 for z/OS
- Presentations from Baltimore/Washington DB2 Users Group
- Presentations from Guide Share France
- DB2mag Fall 2009
- Redpaper DB2 9 for z/OS: Configuring SSL for Secure Client-Server Communications


Regards,

DB2usa.

Redpaper DB2 9 for z/OS: Configuring SSL for Secure Client-Server Communications

Hi DB2 User,

IBM just published a new Redpaper, "DB2 9 for z/OS: Configuring SSL for Secure Client-Server Communications, REDP-4630-00":
http://www.redbooks.ibm.com/Redbooks.nsf/RedbookAbstracts/redp4630.html

Abstract
This IBM Redpaper provides information about how to setup and configure DB2 9 for z/OS with Secure Sockets Layer (SSL) using the z/OS V1R10 Communications Server: IP Application Transparent -Transport Layer Security (AT-TLS) services. This paper also covers the basic configuration steps for configuring SSL support for non-Java DB2 clients and IBM Data Server Driver for JDBC and SQLJ type 4 connectivity clients to access a DB2 9 for z/OS server.
The intended audience for this paper includes network and security administrators and database administrators who want to setup and configure SSL support for DB2 9 for z/OS.

Table of Contents
- Overview of SSL and IP AT-TLS
- Configuring DB2 9 for z/OS server with SSL support
- Configuring DB2 9 for z/OS requester with SSL support
- Configuring Java applications using IBM Data Server Driver for JDBC and SQLJ to use SSL
- Configuring non-Java DB2 clients for Linux, UNIX, and Windows to use SSL
- Configuring remote client applications to use SSL via a DB2 Connect server for Linux, UNIX, and Windows


Regards,

DB2usa.

DB2mag Fall 2009

Hi DB2 user,

Fall 2009 issue of DB2mag is available on line:

- DB2mag Fall 2009 (digital version: interactive PDF)
- DB2mag Summer 2009 (digital version: interactive PDF)

- DB2mag Archives (Winter 1996-Spring 2009)

Note: DB2mag became IBMDatabasemag and then IBM Data Management magazine.

- System z Rocks (Again)
Indexing, compression make your applications work faster.
by Robert Catterall

- Top Performance Features in DB2 9 for z/OS
The mainframe isn't dead-in fact, it's turning heads as a data warehouse platform.
by David Beulke

- Reducing Conversations with DB2 for z/OS: Part 1
As Prem Mehra said, "There is no better-performing SQL than the SQL that is not executed.
by Bonnie Baker

- Customizing XML storage in DB2Tailor XML storage to the needs of your application
With DB2 pureXML, DBAs can apply existing skills to manage XML growth and pursue opportunities to learn new XML skills if they choose.
by Matthias Nicola


More information

- DB2 Data Warehouse Performance, Part 2
Find problem SQL queries and tune them for quicker response.
by Robert Catterall

- DB2 Data Warehouse Performance, Part 1
Translate OLTP-tuning skills into effective performance management for DB2-based business intelligence systems.
by Robert Catterall


Regards,

DB2usa.