Technotes (FAQ), Withdrawal Announcement and Upcoming Redbook residencies

Hi DB2 user,

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

- Troubleshooting access-path-related performance problems
- BIND ERROR SQLCODE109 TOKENS=INTO in Version 9 compatibilty mode
- What data should I collect first for DB2 performance analysis?
- CAST to DOUBLE is an approximation
- DSNL030I: How do I trace the TCP/IP address to catch an unauthorized user?


Withdrawal Announcement 908-280 December 2, 2008

- DB2 for z/OS Version 8 to be withdrawn from marketing September 8, 2009
- IBM Software Support Lifecycle


Upcoming DB2 z/OS Redbook residencies

- DB2 9 for /OS: Distributed Architecture Functions and Scenarios, SD-9Z01-R01
- DB2 9 for z/OS: The Utilities Suite, SD-9Z02-R01
- DB2 9 for z/OS: Resource Serialization and Concurrency Control, SD-9Z03-R01


Information about residencies
http://publib-b.boulder.ibm.com/Redbooks.nsf/pages/how?Open



Regards,

DB2usa.

z/Journal (October - November 2008 issue)

Hi DB2 user,

Articles from October - November 2008 issue of z/Journal are available online: http://www.zjournal.com


- The Magic of DB2’s Prefetch
by Willie Favero

- DB2 Database Maintenance and Recovery: Getting Past the Common Misconceptions
by Brenda Honeycutt and Craig Mullins

- Reoptimizing SQL
by Craig Mullins


Regards,

DB2usa.

UK GSE Conference 2008 presentations

Hi DB2 user,

Here are several presentations from UK GSE Conference 2008, available on UK DB2 User Group website:


- To REORG or not to REORG, That is the Question
by Kevin Baker

- Reordered Row Format in DB2 9 for z/OS
by Paul Fletcher

- Memory Matters in 2009
by Martin Packer

- Lies, Damned Lies & Statistics
by Andy Ward

- DB2 for z/OS: What's all the fuss about Version 8 and Version 9?
by Gareth Jones

- DB2 9 for z/OS - Table Changes
by Phil Granger

- A Row's Life
by Raymond Bell

- Are you sure this is DB2?
by Aurora Dell'Anno

- Introduction to DB2 on the Mainframe
by Gareth Jones


Regards,

DB2usa.