Expert Answer Center (Craig Mullins) Part 2

Hi DB2 user,

Here is a second set of Questions asked to Craig Mullins about DB2 for z/OS on Expert Answer Center column from TechTarget website:

- Runstats command to update all columns of multi-column index
- How much CPU overhead used to process SQL error codes?
- FETCH FIRST ROW ONLY in an update query?
- Possibilities of deadlock
- Deleting N rows from a DB2 table
- Changing the primary key
- Impact on applications of migration from V7 to V8
- Concurrent jobs abending with -803
- Can a plan exist without a package?
- Resolving the -927 error
- The number of seconds since 1970
- Getting what is in table A, but not in table B
- Removing variable length row indicators
- Using LOCKSIZE TABLE for performance
- Recompile after reorg?


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.

DB2 Catalog Presentations

Hi DB2 user,

Here are several presentations from John Lyle (IBM SVL) about DB2 Catalog, Migration and V9 Clones tables, available on IBM and Colorado DB2 User group websites:

- The DB2 Catalog and Migration: The Past, the Present, the Future

- Migrating to DB2 for z/OS Version 8 The many modes of V8

- Attack of the DB2 for z/OS Clones


More information

- A Report on DB2 UDB for OS/390 Catalog Migration Performance

- The DB2 for z/OS Catalog and Directory: Is There Any Data More Important?
by Wille Favero


Regards,

DB2usa.

IDUG Solutions Journal (Spring 2007)

Hi DB2 user,

Spring 2007 issue of IDUG Solutions Journal is available on line:

IDUG Solutions Journal Spring 2007 (format PDF)

All issues from IDUG Solutions Journal

Current issue contains following articles:

- DB2 Locking - Success or Failure in Managing DB2
by Bill Arledge and Judy Quenet

- Fastest Reorganization Is No Reorganization
by Peter Plevka

- What Can DB2 9 Data Compression Do For You?
by Martin Hubel

- Tuning Methodology for Demystifying the DB2 z/OS Optimizer (updated)
by Gene Fuh and Terry Purcell

- DB2 9 for z/OS Performance Summary
by Akira Shibamiya and Roger Miller

- Database Performance Fundamentals
by Craig Mullins


Regards,

DB2usa.