Expert Answer Center (Craig Mullins)

Bonjour,

Vous trouverez ci-dessous une première série de 15 questions posées à Craig Mullins sur DB2 pour z/OS dans la rubrique Expert Answer Center du site web TechTarget :

- 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


Amicalement,

DB2usa.