DB2mag Spring and Summer 2010

Hi DB2 user,

Spring and Summer 2010 issues of DB2mag are available on line:

- DB2mag Summer 2010
- DB2mag Spring 2010

- DB2mag Archives (since Spring 2009)
- DB2mag Archives (Winter 1996-Spring 2009)

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


- DB2 10 for z/OS
More details emerge about new features that can slash CPU costs.
by Dave Beulke

- When Data Wears Out Its Welcome
Are cold data records gumming up the performance of your servers?
by Robert Catterall

- Reducing Conversations with DB2 for z/OS: Part 2
More tried-and-true basics and a few new bells and whistles.
by Bonnie Baker



- Maintenance Makes Money
Five ways to cut database costs - just by paying attention.
by Sheryl Larsen

- Real-Life DB2 Superheroes
IBM puts DB2 powers on display at the IDUG conference.
by David Beulke

- You Want to Govern What?
A database guy discovers data governance.
by Robert Catterall

- Reducing Conversations with DB2 for z/OS: Part 3
Different ways of thinking about ordinary things.
by Bonnie Baker



Regards,

DB2usa.

Presentations from Midwest Database Users Group

Hi DB2 user,

Here are several presentations from Midwest Database Users Group, available on MWDUG website:


- Recursive SQL – Unleash the Power!
by Suresh Sane

- More Batch, Less Time
by Troy Coleman

- Performance Topics for DB2 Application Tuners
by Sheryl Larsen

- DB2 for z/OS Stored Procedure Performance – Language / API Comparison
by Gopal Krishnan and Todd Munk

- Leveraging zIIP, zAAP Specialty Engines with DB2 for z/OS
by Gopal Krishnan


Regards,

DB2usa.

Craig Mullins and Sheryl Larsen presentations

Hi DB2 user,

Here are two Craig Mullins presentations available on Houston Area DB2 User Group website:

- Null and Void? Dealing with Nulls in DB2
by Craig Mullins

- Managing Data for Long Term Retention
by Craig Mullins


Here is Sheryl Larsen's Access Paths Tutorial available on Sheryl's website:

- Access Paths Tutorial
by Sheryl Larsen


Regards,

DB2usa.

More SQL presentations with DB2 for z/OS Version 8

Hi DB2 user,

Here are several presentations about SQL with DB2 for z/OS Version 8, available on Heart of America DB2 User Group Website:

- DB2 V8 on z/OS Experiences in SQL and Programs
by Sheryl Larsen

- An Intense Look at My Favorite V8 SQL Features
by Suresh Sane

- Faster FETCH & INSERT V8 Multiple Row Processing
by John Iczkovits (updated from Chris Crone's presentation)

- DB2 for z/OS V8 Overview: SQL and Network Computing
by Willie Favero

Regards,

DB2usa.

DB2mag: Spring 2007 issue

Hi DB2 user,

Spring 2007 issue of DB2mag is available online: http://www.db2mag.com/db_area/archives/2007/1

- Boosting DB2 9 for z/OS Performance by David Beulke
New features produce dramatic application results.
http://www.db2mag.com/story/showArticle.jhtml?articleID=199201845

- What DB2 Means to Business Value by Robert Catterall
Talk DB2 in business terms the suits can understand.
http://www.db2mag.com/story/showArticle.jhtml?articleID=199201819

- Extreme SQL Performance Techniques for DB2 by Sheryl Larsen
Use the right tuning technique for your workload to avoid hardware upgrades and optimize DB2 performance.
http://www.db2mag.com/story/showArticle.jhtml?articleID=199903243


Regards,

DB2usa.

IDUG's Audio and Video Materials

Hi DB2 user,

IDUG started to publish Audio and Video materials from famous DB2 Speakers on the redesigned IDUG website:

- 10 Minute Tip: Bonnie Baker on Synchronous versus Asynchronous I/O
with Bonnie Baker

- Tuning Your DB2 Data Warehouse
with Dave Beulke

- 10 Minute Tip: Sheryl Larsen's V8 SQL Hints and Tips
with Sheryl Larsen


More information

- The DB2 Cocktail Hour
with Susan Lawson and Dan Luksetich

- Behind the Bar with The DB2 Cocktail Hour
with Susan Lawson and Dan Luksetich

- DB2 UDB for z/OS Version 8 Migration Experiences (PDF and Audio)
with John Campbell

- Pat Bossman on DB2 Stats
with Willie Favero



Regards,

DB2usa.