Expert Answer Center (Craig Mullins)

Hi DB2 user,

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

- Can you give me the approach to creating a table with partition keys?
- Redundant predicates in the DB2 optimizer
- Eliminating duplicates when loading tables
- Using host variables after ORDER BY
- General recommendations for DB2 compression
- Setting buffer pools
- PIECESIZE with non-partitioning indexes
- Determining the number of rows opened by CURSOR without actually fetching them
- Problem with multiple inserts
- What is the usage of two-way commit?
- Triggers to UPDATE CASCADE
- Is index space reorg necessary with weekly tablespace reorg?
- Combining two queries into one
- What's the significance of the LIMITKEY parameter in the tablespace definition?
- Performance implications of DSSIZE


Regards,

DB2usa.

DB2 for z/OS Versions

Hi DB2 user,

You will find below information about DB2 for z/OS Versions:

Versions 5 and 6
DB2 for OS/390 Version 5 End of Service date was 31 December 2002.
DB2 UDB for OS/390 Version 6 End of Service was 30 june 2005.
Documentation is still available on IBM's website:

http://www.ibm.com/software/data/db2/zos/v5books.html
http://www.ibm.com/software/data/db2/zos/v6books.html


Version 7
IBM officially announced End of Service is planned on 30 june 2008:
http://www.ibm.com/common/ssi/fcgi-bin/ssialias?letternum=ENUS907-023


Version 8
Version 8 documentation has been updated (February 2007) :
http://www.ibm.com/software/data/db2/zos/v8books.html


Version 9
Beta of version 9 (QPP) is available since 9 June 2006:
http://www.ibm.com/common/ssi/fcgi-bin/ssialias?letternum=ENUS206-098

Here is a new presentation about features of Version 9:
DB2 9 - What's In There For SAP and Other Enterprise Applications
by Namik Hrle (IBM SVL)
http://www.ibm.com/support/docview.wss?uid=swg27009172

Here is the official list of versions (IBM Software Support Lifecyle) :
http://www.ibm.com/software/support/lifecycle

Regards,

DB2usa.

IDUG Solution Journal (Winter 2006)

Hi DB2 user,

Winter 2006 issue of IDUG Solutions Journal is available on line:

IDUG Solutions Journal Winter 2006 (format PDF)

All issues from IDUG Solutions Journal

Current issue contains following articles:

- Anixter’s Migration to DB2 for z/OS Version 8
by Damon Anderson and Bernie O’Connor

- DB2 Top Tips: A "Hat Trick" - Three Tips for Busy DBAs
by Damon Anderson

- DB2 UDB for z/OS 8 and V9 Features and Functionality for PeopleSoft part 2
by Brian Holroyd

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

- Programming for the New DB2
by Maria Sarikos

- Using the Real Time Statistics
by Craig Mullins


Regards,

DB2usa.