z/Journal (June - July 2011 issue)

Hi DB2 user,

Articles from June - July 2011 issue of z/Journal are available online: http://www.mainframezone.com/z-journal

Note: z/Journal moved to mainframezone.com .

- DB2 for z/OS Search and Scroll Techniques
by Dan Luksetich

- A First Look: DB2 10 DSNZPARM Changes
by Willie Favero

- Partitioning Pros and Cons
by Craig Mullins


Regards,

DB2usa.

z/Journal (June - July 2010 issue)

Hi DB2 user,

Articles from June - July 2010 issues of z/Journal are available online: http://www.mainframezone.com/z-journal

Note: z/Journal moved to mainframezone.com .

- DB2 for z/OS SQL Performance Choices
by Dan Luksetich

- Reorganize DB2 on z/OS Objects to Save Time and Money
by Peter Plevka

- Top-10 Features of DB2 10 for z/OS: A Preview
by Willie Favero

- The 10 Database Commandments
by Craig Mullins


Regards,

DB2usa.

z/Journal (April - May 2010 issue)

Hi DB2 user,

Articles from April - May 2010 issues of z/Journal are available online: http://www.mainframezone.com/z-journal

Note: z/Journal moved to mainframezone.com .

- DB2 for z/OS Buffer Pools: Diving Into the Deep End
by Bill Arledge and Lynn Gros

- Radical Changes Can Modernize and Streamline DBA Resources
by Troy Coleman and Stefan Kochishan

- The Magic of Keeping DB2 in Order
by Willie Favero

- Choices for Caching Data in the Enterprise
by Susan Lawson and Dan Luksetich


More information

- Using In-Memory Tables to Optimize Your Mainframe Environment
by William Olders

- Storage Performance Management: Strategies for Solid State Drives
by Gilbert Houtekamer and Wim Oudshoorn


Regards,

DB2usa.

z/Journal (October 2009 - March 2010 issues)

Hi DB2 user,

Articles from October 2009 - March 2010 issues of z/Journal are available online: http://www.mainframezone.com/z-journal

Note: z/Journal moved to mainframezone.com .

- Collecting Histogram Statistics With RUNSTATS
by Craig Mullins

- 11 Rules of the Road for DBAs
by Craig Mullins

- Using SMF for Cost-Effective DB2 Security, Auditing & Compliance Monitoring
by Jerry Harding, Stephen Rubin and William Buriak

- SQL Performance Tuning for Application Developers
by Peter Plevka

- Snapping the DB2 for z/OS Dynamic Statement Cache
by Susan Lawson and Dan Luksetich

- Simplify and Improve Database Administration by Leveraging Your Storage System
by Ron Haupert



Regards,

DB2usa.

Susan Lawson and Dan Luksetich's presentations

Hi DB2 user,

Here are several DB2 z/OS presentations of Susan Lawson and Dan Luksetich, available on IDUG website:


- Quit Calling DB2 So Much!
by Susan Lawson and Dan Luksetich

- DB2 9 for z/OS: A New Spin on a Classic Database
by Susan Lawson

- Desperate Table Designs
by Susan Lawson and Dan Luksetich

- Top 10 Ways to Waste CPU
by Susan Lawson and Dan Luksetich

- V8/V9 SQL Challenges and Solutions
by Susan Lawson and Dan Luksetich

- Effective Uses of DB2 Triggers
by Dan Luksetich

- Utilizing DB2 V8 Table Expressions
by Dan Luksetich

- DB2 Legacy Migrations: Experiences of The Industry
by Susan Lawson and Dan Luksetich

- DB2 Application Design for Performance
by Susan Lawson and Dan Luksetich

- DB2 for z/OS Design and Tuning Tips for Your Complex VLDB
by Dan Luksetich


Regards,

DB2usa.

z/Journal (February - March and April - May 2009 issues)

Hi DB2 user,

Articles from February - March and April - May 2009 issues of z/Journal are available online: http://www.zjournal.com


- Canonical Database Architecture and DB2 Performance … Really?
by Susan Lawson and Dan Luksetich

- Not Sure Who You Are? Ask DB2
by Susan Lawson and Dan Luksetich

- How DB2 9 for z/OS Can Improve a Data Warehouse’s Performance
by Willie Favero

- Being a DBA in Hard Economic Times: Nine Notions for '09
by Lockwood Lyon

- DB2 System Configuration and Performance
by Craig Mullins


More information

- DBA Proverbs
by Craig Mullins

- Recovery Is a Compliance Issue
by Craig Mullins


Regards,

DB2usa.

z/Journal (August - September 2008 issue)

Hi DB2 user,

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


- Want to Know What DB2 Is Doing? Take a Closer Look at DB2’s TRACE
by Willie Favero

- Aligning IT & Business: Automation Is the Key to DB2 Success
by Rick Weaver

- Going Back in Time: How to Leverage Data Imaging for DB2 Tables
by Susan Lawson and Daniel Luksetich

- DB2 9 Data Format "Stuff"
by Craig Mullins


Regards,

DB2usa.

z/Journal (April - May 2008 issue)

Hi DB2 user,

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


- Exploiting DB2 Version 8 and DB2 9 SQL Features for SQL Call Reduction
by Susan Lawson and Daniel Luksetich

- Database Administration Best Pratices
by Lockwood Lyon

- Use Real Time Statistics to automate your Database Maintenance
by Craig Mullins

- JDBC, JDBC Drivers and DB2 9.1
by Allen Jaques


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.

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.

z/Journal (October - November 2006 issue)

Hi DB2 user,

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


- Top-10 Ways to Waste CPU Using DB2
by Susan Lawson and Daniel Luksetich
http://www.zjournal.com/index.cfm?section=article&aid=711


- To Rebind or Not to Rebind, Is That a Question?
by Craig Mullins
http://www.zjournal.com/index.cfm?section=article&aid=718


- The Laws of Database Administration
by Lockwood Lyon
http://www.zjournal.com/index.cfm?section=article&aid=719


- Managing DB2 Performance in a Multi-Platform Environment
by Jim Wankowski
http://www.zjournal.com/index.cfm?section=article&aid=709


Regards,

DB2usa.