DB2mag Fall 2010

Hi DB2 user,

Fall 2010 issue of DB2mag is available on line:

- DB2mag Fall 2010

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

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


- Is There Anything zEnterprise Can't Do?
IBM zEnterprise runs your business—any system, any application.
by Dave Beulke

- What's New: DB2 10 for z/OS
Dramatic CPU savings and data availability enhancements, check. But have you seen the new temporal data support?
by Terrie Jacopi

- DB2 Indexes and Query Performance: Part 1
Weigh costs and benefits when considering additional indexes.
by Robert Catterall

- Does the Order of SQL Predicates Matter?
Rearranging WHERE clause predicates may be an exercise in futility.
by Bonnie Baker



Regards,

DB2usa.

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.

DB2 10 for z/OS Presentations and Beta Program

Hi DB2 user,

Here are several articles and presentations about DB2 10 for z/OS (formally known as DB2 X) available on several websites:


- DB2 10 for z/OS technical preview (65 pages with notes)
by Roger Miller

- DB2 Trends and Directions (Version X)
by Gareth Jones

- What's Ahead?
DB2 X leads the industry to minimize complexity and maximize productivity
by Terrie Jacopi and Jeff Josten

- DB2 9 for z/OS and Beyond (pages 29-52 with notes)
by Roger Miller

- The next DB2 for z/OS: First glimpse into the future
by David Beulke

- Deprecated Features Planned for DB2 X for z/OS
by Craig Mullins


More information

- IBM DB2 10 for z/OS launches beta program
Beta Program: March 12, 2010
General Availability (GA): not announced

- IBM DB2 V9.1 for z/OS launches beta program
Beta Program (QPP): June 9, 2006
General Availability (GA): March 16, 2007

- IBM DB2 Universal Database for z/OS, V8 — Reengineered for e-business Leadership
Beta Program (ESP): January 31, 2003
General Availability (GA): March 26, 2004

- DB2 z/OS Product Lifecycle
(General availability, End of Marketing, End of Support)

- DB2 Distributed End of Support (EOS) dates
(including DB2 Connect)


Regards,

DB2usa.

DB2mag Winter 2009

Hi DB2 user,

Winter 2009 issue of DB2mag is available on line:

- DB2mag Winter 2009 (digital version: interactive PDF)
- 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.

- Making Humongous Doable
Need to manage a gigantic database? Let DB2 do the heavy lifting.
by Robert Catterall

- The next DB2 for z/OS
First glimpse into the future.
by David Beulke


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.

Presentations from Baltimore/Washington DB2 Users Group

Hi DB2 user,

Here are several presentations from Baltimore/Washington DB2 Users Group, available on BWDB2UG website:

- Improving Performance with DB2 V9 for z/OS
by David Beulke

- What's New in DB2 9 for Applications
by Patrick Bossman

- DB2 Performance Primer
by Michael Murray

- Index Design in a Busy System
by Larry Kintisch and Tapio Lahdenmäki

- ATS DB2 Health Check
by John Iczkovits

- A List of DB2 Top Ten Lists
by Craig Mullins

- Null & Void? Dealing with Nulls in DB2 for z/OS
by Craig Mullins


More information

- New to DB2 LUW but for experienced z/OS DBAs
by Chris Eaton

- Database Trends
by Craig Mullins


Regards,

DB2usa.

DB2 9 for z/OS Performance Features by Dave Beulke

Hi DB2 user,

Dave Beulke published several posts about DB2 9 for z/OS performance features on his Blog: http://davebeulke.com:

- DSNZPARM parameters
- ORDER BY and FETCH FIRST n ROWS in a Sub-Select
- Skip Uncommitted Inserts zParm
- Universal Tablespace
- FETCH WITH CONTINUE SQL
- DB2 Version 9 for z/OS Logging enhancement
- Performance improvement for IBM DB2 utilities
- Data Warehousing and Reporting features
- Minimizing the number of SQL call
- Too Many Performance Features in DB2 Version 9 for z/OS



More information

- Improving Performance with DB2 V9 for z/OS

- Java DB2 Performance with Data Studio and PureQuery

- pureQuery-JLINQ Examples to Improve Your Java Application Performance

- Data Warehouse Design and Performance

- How to do your own Performance Review

- Performance for SOA DB2 Java Applications



Regards,

DB2usa.

DB2mag Winter 2008

Hi DB2 user,

Winter 2008 issue of DB2mag is available online: http://ibmdatabasemag.com/db_area/archives/2009/1

Note: DB2mag became IBMDatabasemag.

- DB2 Data Warehouse Performance, Part 1 by Robert Catterall
Translate OLTP-tuning skills into effective performance management for DB2-based business intelligence systems.
http://www.ibmdatabasemag.com/story/showArticle.jhtml?articleID=216300344

- Three Tips for DB2 Java Apps by David Beulke
Keep DB2 performance high by avoiding these common Java oversights.
http://www.ibmdatabasemag.com/story/showArticle.jhtml?articleID=216300333

- DB2 Answers by Bonnie Baker
Compression questions and a sticky DB2 for z/OS SORT mystery are put to rest.
http://www.ibmdatabasemag.com/story/showArticle.jhtml?articleID=216300355

- Now with .NET applications accessing DB2 for z/OS
by Rajesh Sambandhan, Simon Harris and Todd Munk
Compression questions and a sticky DB2 for z/OS SORT mystery are put to rest.
http://www.ibmdatabasemag.com/story/showArticle.jhtml?articleID=216401198


- XML and the Database: A Perspective for the DBA
by Bryan Patterson and Dexiong Terry Zhang
With DB2 pureXML, DBAs can apply existing skills to manage XML growth and pursue opportunities to learn new XML skills if they choose.
http://www.ibmdatabasemag.com/story/showArticle.jhtml?articleID=216402743

- XML Storage Options in DB2 by Conor O'Mahony
How to decide which XML storage option best suits a particular application.
http://www.ibmdatabasemag.com/story/showArticle.jhtml?articleID=216403288


Regards,

DB2usa.

DB2mag Fall 2008

Hi DB2 user,

Fall 2008 issue of DB2mag is available online: http://ibmdatabasemag.com/db_area/archives/2008/4

Note: DB2mag became IBMDatabasemag.

- DB2 Programmers Do Exist by Robert Catterall
And the things they do with DB2 SQL might surprise you.
http://www.ibmdatabasemag.com/story/showArticle.jhtml?articleID=211300260

- DB2 XML and LOB Design by David Beulke
Guidelines for DB2 for z/OS applications.
http://www.ibmdatabasemag.com/story/showArticle.jhtml?articleID=211300322

- The Mystery of DB2 Sorts by Bonnie Baker
Can adding SORT syntax really improve DB2 for z/OS performance?
http://www.ibmdatabasemag.com/story/showArticle.jhtml?articleID=211300275


Regards,

DB2usa.

DB2mag Sumer 2008

Hi DB2 user,

Summer 2008 issue of DB2mag is available online: http://ibmdatabasemag.com/db_area/archives/2008/3

Note: DB2mag became IBMDatabasemag.

- IBM Data Studio pureQuery Runtime for z/OS Performance by Rajesh Sambandhan and Simon Harris
http://www.ibmdatabasemag.com/story/showArticle.jhtml?articleID=208802229

- Get On the Enterprise Service Bus by Robert Catterall
It's no magic bullet, but enterprise service bus technology hits the mark for certain transactions.
http://www.ibmdatabasemag.com/story/showArticle.jhtml?articleID=209900050

- DB2 Leads with Innovation by David Beulke
DB2 for z/OS financial incentive programs open new horizons for data warehousing and other applications.
http://www.ibmdatabasemag.com/story/showArticle.jhtml?articleID=209900069

- The Mystery of DB2 for z/OS Index-only Updates and Deletes by Bonnie Baker
Can a DB2 for z/OS index-only UPDATE or DELETE really be index only?
http://www.ibmdatabasemag.com/story/showArticle.jhtml?articleID=209900061


Regards,

DB2usa.

DB2mag Spring 2008

Hi DB2 user,

Spring 2008 issue of DB2mag is available online: http://ibmdatabasemag.com/db_area/archives/2008/2

Note: DB2mag became IBMDatabasemag.

- Exploring pureXML in DB2 9 for z/OS by Kirsten Larsen and Michael Schwartzbach
http://ibmdatabasemag.com/story/showArticle.jhtml?articleID=207801115

- Can SOA Perform? by Robert Catterall
The answer is yes, but only if you leave old-school application ideas behind.
http://www.ibmdatabasemag.com/story/showArticle.jhtml?articleID=207801123

- Common DB2 Performance Pitfalls by David Beulke
Build your applications right from the start by avoiding these typical missteps.
http://www.ibmdatabasemag.com/story/showArticle.jhtml?articleID=207801294

- The Mystery of the DB2 SIX Lock by Bonnie Baker
The truth behind this enigmatic lock and other DB2 for z/OS stumpers.
http://www.ibmdatabasemag.com/story/showArticle.jhtml?articleID=207801138


Regards,

DB2usa.

DB2mag Winter 2007

Hi DB2 user,

Winter 2007 issue of DB2mag is available online: http://ibmdatabasemag.com/db_area/archives/2008/1

DB2mag became IBMDatabasemag as explained in the following article:

- DB2 Magazine is now IBM Database Magazine by Kim Moutsos
http://ibmdatabasemag.com/story/showArticle.jhtml?articleID=206800435


- pureQuery and DB2 9 Shine by David Beulke
pureQuery and DB2 for z/OS provide better performance and developer coding flexibility.
http://www.ibmdatabasemag.com/story/showArticle.jhtml?articleID=206800608


- Elevating the DBA Role by Robert Catterall
Is it time to retire the DBA title for one that represents the real work DB2 DBAs do?
http://www.db2mag.com/story/showArticle.jhtml?articleID=202400154


More information

- Asked and Answered: DB2 for z/OS Buffer Pools and CPU Time
by Robert Catterall


Regards,

DB2usa.

DB2mag: Fall 2007 issue

Hi DB2 user,

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

- DB2 Makes Being Green Easy by David Beulke
Reusing DB2 resources makes good business--and performance--sense.
http://www.db2mag.com/story/showArticle.jhtml?articleID=202400498

- DB2 DBA: Ultra Availability by Robert Catterall
If you think "never down, don't lose anything" is an impossible goal for DB2, you should think again.
http://www.db2mag.com/story/showArticle.jhtml?articleID=202400154

- DB2 for z/OS Buffer Pools and CPU Time by Robert Catterall
What affect will tuning DB2 for z/OS buffer pools have on CPU time?
http://www.db2mag.com/story/showArticle.jhtml?articleID=202400447

- Optimistic Locking, Part 2 by Bonnie Baker
When it comes to DB2 for z/OS locks, a pessimistic approach rarely pays.
http://www.db2mag.com/story/showArticle.jhtml?articleID=202400443


Regards,

DB2usa.

DB2mag: Summer 2007 issue

Hi DB2 user,

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

- Locking Up DB2 Performance by David Beulke
A new locking feature in DB2 9 for z/OS improves the performance outlook.
http://www.db2mag.com/story/showArticle.jhtml?articleID=201200471

- News from the Client Side by Robert Catterall
Application developers love Python, Perl, PHP, and Ruby. DB2 is ready to support them -- are you?
http://www.db2mag.com/story/showArticle.jhtml?articleID=201200804

- Optimistic Locking, Part 1 by Bonnie Baker
An improvement to this age-old DB2 for z/OS concept helps programmers who look on the bright side.
http://www.db2mag.com/story/showArticle.jhtml?articleID=201201095


More information
- What's New in DB2 UDB for z/OS Locking and Concurrency by Jim Teng

- Redbook Locking in DB2 for MVS/ESA Environment

Regards,

DB2usa.

z/Journal (April - May 2007 issue)

Hi DB2 user,

Articles from April - May 2007 issues of z/Journal are available online: http://www.zjournal.com


- Myth-Busting DB2 Version 8 CPU Regression
by Willie Favero

- DB2 and CICS Are Moving On: Avoiding Potholes on the Yellow Brick Road to an LE Migration
by Carl Gehr Jr. and Nate Murphy

- Performance: Why I Want DB2 9 for z/OS
by David Beulke

- Using DB2 Generic Attach for Flexible Database Interfaces
by Susan Lawson and Daniel Luksetich

- If You Ain’t 8, You’re Late
by Craig Mullins

- The Beginning z/OS DB2 DBA
by Lockwood Lyon


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.