Category: Maintenance

8

How to Tell When an Index Reorg is Needed

My earlier post on table reorgs covered Reorg’s place in a database maintenance cycle and running reorgchk. If you haven’t already read it, check it out: How to Tell When a Table Reorg is Needed INDEXES After the section on tables, REORGCHK output has a section with details on each index for each table that REORGCHK looked at. The index...

15

How to Tell When a Table Reorg is Needed

Reorgs are one critical piece of both performance maintenance and maintaining how much disk space is used. In my first blog entry in this series, DB2 Basics: What is a Reorg, I talked about some purposes of reorgs. In this entry, I’m going to talk about how to determine what kind of reorg is needed on what tables. I will...

5

Backup Compression Consideration – DB2 COMPRESS vs. GZIP

We interrupt your regular programming for a quick announcement. If you have been reading DB2commerce.com for a while you know I am an occasional guest writer on this technical blog. I’ve worked this year on expanding my comfort zone with regular articles here, a developerWorks article to be posted next week, and I have entered as a competitor on the...

0

Care and Feeding of Statistical Views

The whole point of statistical views is to improve the performance of SQL that joins tables. Or to help you collect statistics on expressions – though if you’ve got 10.5, consider expression-based indexes for that instead. Giving the DB2 Optimizer more data is generally a good thing for query performance. If you don’t keep runstats current on your statistical views,...

4

Binding Packages

I approach binding from a physical/system DBA point of view. I’m not an application developer, and don’t understand all the possible intricacies of binding. But there is some information and tips I can share on binding packages in DB2. There are definitely some application developer topics included here. Static vs. Dynamic SQL This is a basic division in how SQL...