Robert's Db2 blog

This is the blog of Robert Catterall, an IBM Db2 for z/OS specialist. The opinions expressed herein are the author's, and should not be construed as reflecting official positions of the IBM Corporation.

Tuesday, June 28, 2016

DB2 for z/OS: Indexes and Foreign Keys

›

The functionality of DB2 for z/OS is enhanced, in ways small and big, on a regular basis. There's plenty to keep up with, and it is unde...

9 comments:

Wednesday, May 25, 2016

DB2 for z/OS: When Did You Last Check Your Checkpoint Frequency?

›

I have written in this blog a few entries about various DB2 for z/OS ZPARM parameters, including a post on DSMAX and another on EDM_SKELETO...

Friday, April 29, 2016

DB2 for z/OS: Should You Do Some Buffer Pool Consolidation?

›

19, 19, 23, 26. Know what these numbers have in common? They indicate the number of 4K buffer pools allocated for four different productio...

9 comments:

Thursday, March 31, 2016

Observations on DB2 for z/OS Address Space CPU Utilization

›

Have you ever looked at a DB2 Statistics Long report generated by your DB2 monitor? If so, you might have seen a section containing informat...

4 comments:

Sunday, February 28, 2016

DB2 for z/OS: When Did You Last Check Your Subsystem's DSMAX Value?

›

As a DB2 for z/OS system grows and evolves, the value of certain ZPARM parameters should be reviewed to ensure that they are still appropria...

Sunday, February 21, 2016

Statement-Level Control of DB2 for z/OS Query Parallelization

›

I'm writing about this now because of the increased interest I've seen, at various DB2 for z/OS sites, in using DB2 query paralleliz...

2 comments:

‹

›

Home

View web version