YL&A

• Yevich, Lawson, and Associates Home Page
• DB2 High Performance Design and Tuning on Amazon.com
• DB2 Answers! on Amazon.com
• DB2 Universal Database for OS/390 V7.1 Application Certification Guide on Amazon.com
• DB2 Universal Database for OS/390 Version 7.1 Certification Guide on Amazon.com
• DB2 for z/OS Version 8 DBA Certification Guide (2nd Edition) on Amazon.com
• DB2 9 for z/OS DBA Certification Guide on Amazon.com
• DB2 for z/OS Version 8 Family Reference Guide at BMC.COM
• YLA BMC Webinar; Reduce CPU Usage with SMART SQL at BMC.COM
• YLA BMC whitepaper; Reduce CPU Usage with SMART SQL at BMC.COM

DB2 User Groups

• International DB2 Users Group
• International DB2 Users Group Conferences
• Regional Users Group Listings

Support

• IBM's DB2 Product Page
• Visual Explain site
• Optimization Service Center site
• Data Studio Developer
• Developer Workbench download site
• DB2 Estimator download
• DB2 for z/OS V7 product manuals
• DB2 for z/OS V8 product manuals
• DB2 9 for z/OS product manuals
• DB2 for LUW V8 product manuals
• DB2 9 for LUW product manuals
• DB2 9 Express-C Free Enterprise Download!
• DB2 9 Client Download
• DB2 V8.2 Personal Develper's Edition
• DB2 V8 for Windows (32 bit) download page
• DB2 9 for Windows (32 bit) download page
• z/OS internet library
• CICS Transaction Server for z/OS V3.1 internet library
• Connecting PHP to DB2

Other

• A Nice Julian Date Conversion Chart
• DB2 List Server
• Get the Granger SQL Query Tool!
• Istek Consulting's Open System Architect in a Mainframe World

• Choices for Caching Data in the Enterprise, by Susan Lawson and Dan Luksetich, zJournal, February/March 2010
• Snapping the DB2 for z/OS Dynamic Statement Cache, by Susan Lawson and Dan Luksetich, zJournal, February/March 2010
• Canonical Database Architecture and DB2 Performance.....Really?, by Susan Lawson and Dan Luksetich, zJournal, April/May 2009
• Not Sure Who You Are? Ask DB2, by Susan Lawson and Dan Luksetich, zJournal, February/March 2009
• As of Imaging of Data in DB2 , by Susan Lawson and Dan Luksetich, zJournal, August/September 2008
• Quit Calling DB2 So Much! Exploiting DB2 Version 8 and DB2 9 SQL Features for SQL Call Reduction , by Susan Lawson and Dan Luksetich, zJournal, April/May 2008
• Using DB2 Generic Attach for Flexible Database Interfaces, by Susan Lawson and Dan Luksetich, zJournal, April/May 2007
• Top 10 Ways to Waste CPU using DB2, by Susan Lawson and Dan Luksetich, zJournal, October/November 2006
• Legacy Migrations: Experiences of the Industry, by Susan Lawson and Dan Luksetich, zJournal, April/May 2006
• Minimizing Change In Your DB2 For z/OS Database, by Susan Lawson and Dan Luksetich. z/Journal, February/March 2006
• Susan Lawson featured in the My Dream Job column of DB2 Magazine, Quarter 1, 2006
• DB2 V8 for z/OS Statistics and Diagnostics, by Susan Lawson. z/Journal, May 2005
• DB2 UDB for OS/390 and z/OS Application and SQL Performance Trade-Offs, by Dan Luksetich. z/Journal, April 2005
• DB2 for z/OS Application Level Performance Reporting and Tuning, by Dan Luksetich. z/Journal, January 2005
• Use (and Abuse!) of DB2 for z/OS Stored PRocedures, Part 2 by Susan Lawson and Dan Luksetich. DBAZine, January 2005
• Use (and Abuse!) of DB2 for z/OS Stored PRocedures, Part 1 by Susan Lawson and Dan Luksetich. DBAZine, December 2004
• Providing Static Reliability in a Dynamic World, by Susan Lawson and Dan Luksetich. IDUG SJ, December 2004
• DBAZine's DB2 for z/OS Performance Primer, featuring Dan Luksetich. November 2004
• Using FlashCopy Version 2 for DB2 UDB for OS/390 and z/OS Object-Level Migration by Dan Luksetich. z/Journal, August 2004
• Making a Change in a World Without Windows: DB2 for z/OS Version 8 Provides Some New Options (Part 2) by Susan Lawson. IDUG SJ, August 2004 (Page 66)
• DB2 V8 z/OS Stored Procedures and Workload Manager: Realizing the Synergy and Planning for Migration by Susan Lawson and Dan Luksetich. z/Journal, May 2004
• Making a Change in a World Without Windows: DB2 for z/OS Version 8 Provides Some New Options (Part 1) by Susan Lawson. IDUG SJ, May 2004 (Page 70)
• Utilizing Recursive SQL on DB2 UDB for z/OS by Dan Luksetich. IDUG SJ, May 2004 (Page 52)
• Want to Change Your Identity? Consider Sequence Objects in Version 8 by Susan Lawson. IDUG SJ, Nov. 2003 (Page 37)
• Version 8 Dynamic Scrollable Cursors: Better Usability and Performance by Susan Lawson. DB2TIMES, Sept. 2003
• DB2 z/OS Version 8; DSSIZE Does Matter, by Susan Lawson. IDUG SJ Sept. 2003 (Page 43)
• V8 z/OS Materialized Query Tables by Susan Lawson. DB2TIMES, May 2003
• Partitioning, Indexing and Clustering. PICing on DB2 z/OS Version 8, by Susan Lawson. IDUG SJ May 2003 (Page 34)
• A Quick Look at What's Coming in V{next} on z/OS by Susan Lawson. DB2TIMES, Oct. 2002
• Correlated Table Expressions by Dan Luksetich. DB2TIMES, Oct. 2002
• Overcoming SQL Limits in DB2, by Susan Lawson and Terry Purcell. IDUG SJ, Oct. 2002 (Page 51)
• Real Time Statistics are Here! by Susan Lawson. IDUG SJ Aug. 2002 (Page 55)
• DB2 for OS/390 and z/OS SQL Scalar Functions, by Daniel Luksetich. IDUG SJ Aug. 2002 (Page 41)
• SQL Techniques to Solve Design Challenges, by Susan Lawson and Terry Purcell. IDUG SJ Aug. 2002 (Page 35)
• Simply Irresistible: DB2 to Application Vendors, by Richard Yevich. DB2 Magazine, Q4, 2001
• Existence Checking: The Real Story, by Richard Yevich and Susan Lawson. IDUG SJ, Nov. 2001 (Page 44)
• Non-Partitioning Indexes DO WORK! by Richard Yevich and Susan Lawson. IDUG SJ Sept. 2001 (Page 71)
• IDENTITY Revisited: Old Issues, New Issues, and Some Clarifications, by Richard Yevich and Susan Lawson. IDUG SJ, May 2001 (Page 57)
• Powering Up: DB2 Utilities, by Richard Yevich. DB2 Magazine, Spring 2001
• Application Performance: An Oxymoron, by Richard Yevich. DPJ, May 2001
• Getting the Most out of DB2 Paralellism, by Susan Lawson. DPJ, May 2001
• Conservative Use of DB2 Identity Columns, by Dan Luksetich. DPJ Feb. 2001
• DB2 Data Sharing as the High Performance Server for E-Business, by Susan Lawson. DPJ Nov. 2000
• Really Cool DB2 Universal Database SQL, by Dan Luksetich. DPJ Aug. 2000
• Designing and Implementing VLTBs for Performance, by Susan Lawson. DPJ Aug. 2000
• V6 Refresh and V7 Impacts on Performance, by Richard Yevich. DPJ Aug. 2000
• DB2 Universal Database Version 7. The Database Solution for E-Business, by Susan Lawson, Martil Hubel, and Gary Mordini. IDUG SJ Summer 2000 (Page 7)
• Introducing Object-Relational OS/390, by Richard Yevich and Susan Lawson. DB2 Magazine, Spring 2000
• New Features of Version 6, by Richard Yevich. IDUG SJ, Spring 2000 (Page 57)
• DB2 UDB Version 6 Buffer Pools: Making Waves - From Queuing Methods to Data Spaces, More Opportunities for Performance Gains, by Susan Lawson. IDUG SJ, Spring 2000 (Page 27)
• Outer Joins: No More Worries, by Richard Yevich. IDUG SJ, Fall 1999 (Page 66)
• Mixing DB2 and e-Business, by Richard Yevich and Willie Favero. IDUG SJ, Fall 1999 (Page 52)
• SQL Procedures and REXX for DB2, by Richard Yevich. IDUG SJ Aug. 1999 (Page 69)
• DB2 Object Orientation, by Richard Yevich and Craig Mullins. IDUG SJ, Aug. 1999 (Page 32)
• Tuning ERPs for DB2, by Richard Yevich and Susan Lawson. DB2 Magazine, Summer 1999
• DB2 Data Sharing Performance Enhancements: Version 5 Post GA and Version 6, by Susan Lawson. IDUG SJ Aug. 1999 (Page 19)
• The Need For Database Procedural Programmers (DPPs), by Richard Yevich and Craig Mullins. IDUG SJ March 1999
• DB2 UDB for OS/390 Version 6: Arriving Soon, by Richard Yevich and Susan Lawson. IDUG SJ, March 1999
• Technical Talk: DB2 UDB 5.2 - Amazing Enhancements, by Richard Yevich. IDUG SJ, Oct. 1998 (Page 58)
• Technical Talk: DB2 for OS/390 Meets a 1TB Table, by Richard Yevich. IDUG SJ, Aug. 1998 (Page 57)
• Sizing up DB2 for Solaris, by Richard Yevich. DB2 Magazine, Summer 1998
• Geoplex: Exploiting the Concept of Multi-site Recovery, by Susan Lawson and Richard Yevich. IDUG SJ, Aug. 1998 (Page 22)
• Why to Warehouse on the Mainframe, by Richard Yevich. DB2 Magazine, Spring 1998
• Technical Talk: The Case for Warehousing on DB2 for OS/390, by Richard Yevich. IDUG SJ, March 1998 (Page 72)
• Technical Talk: Performance!, by Richard Yevich. IDUG SJ, Nov. 1997
• V5: Dawn of the New DB2 for OS/390, by Richard Yevich. DB2 Magazine, Spring 1997