z/Journal (April - May 2011 issue)

Hi DB2 user,

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

Note: z/Journal moved to mainframezone.com .

- Save MIPS With Effective DB2 for z/OS Indexes
by Rick Weaver

- DB2 for z/OS and REBIND
by Jim Kurtz

- Empowering Technicians for the Changing World
by Troy Coleman

- Best Practices in DB2 Storage Management
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.

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.

Presentations from Northeast Ohio Database Users Group

Hi DB2 user,

Here are several presentations, available on Northeast Ohio Database Users Group website:

- Tablespace Partitioning for DB2 V8: Maintenance,Performance and more
by Troy Coleman

- The Perfect Combination: System z, z/OS, and DB2
by Willie Favero

- The Best Defense is a Good Offense (DB2 for z/OS Version 8 Migration Planning)
by Willie Favero

- DB2 Connections to DB2 for z/OS (Distributed Functions of DB2 for z/OS)
by Paul Wirth

- Managing Distributed, Dynamic Workloads on DB2
by Progressive

- Progressive’s DB2 Tools and Utilities
by Progressive


Regards,

DB2usa.

Troy Coleman's Blog

Hi DB2 user,

Troy Coleman published several posts about DB2 for z/OS on his blog DB2utor:

- DB2 9 Index with Expressions
- DB2 9 Mysteries of DB2 Storage Groups
- Smart Reoptimization for Dynamic SQL
- Evolution of Online Schema Change to Database Definition on Demand
- Reserved Words in DB2 9 for z/OS
- Explaining How DB2 Will Get Data for a Given SQL Statement
- What Makes Compressed Indexes Tick?
- PureXML: Why Is This Feature So Important to Your Business?
- DB2 V9 Logged vs. Not Logged
- DB2 V9 Reordered Row Format-What Does It Mean to Me?
- MERGE Statement Simplifies Batch Processing and Improves Performance
- Moving to DB2 V9 Soon?
- Using Universal Table Space


Regards,

DB2usa.

DB2 articles from IBM Systems Magazine

Hi DB2 user,

DB2 articles from IBM Systems Magazine are available online: http://www.ibmsystemsmag.com


- DB2 Table Space - Is It Time to Redesign?
by Troy Coleman

- An Intuitive Approach to DB2 for z/OS SQL Query Tuning
by Lee Siegmund

- DB2 for z/OS SQL Query Tuning, Continued
by Lee Siegmund

- The Evolution of DB2 for z/OS Optimization
by Jay Bruce

- Easing the Cost of Compliance
by James Pickel

- DB2 for z/OS Features Contribute to High Availability
by Lee Siegmund

- DB2 for z/OS High Availabilty and Unplanned Outage Recovery
by Lee Siegmund

- Online Even More of the Time
by Kate Langdon

- Good Migrations
by Jeanne Kays and Roger Miller


Regards,

DB2usa.