DB2 Version 9 – STATIME Default Decreased to 5

(Originally posted 2007-10-10.)

I’m in a session where we’re going through DB2 Version 9 migration considerations – and right now there’s a table on display with changes to DSNZPARM defaults.

One of real value is that STATIME has changed to 5 minutes from 30. Unless you’ve overridden it you should now get much better information at the DB2 subsystem level. This does, of course, mean 12 sets of Statistics Trace records an hour, rather than 2. But it does mean that for the “counter” fields subtracting the first from the last gives you a MUCH better view of hourly rate at which the counter increments.

I think it’s a long overdue change. Of course, if you’ve hardcoded the default 30 value then you won’t see the improvement. And if you’ve already dropped STATIME to 5 or (still better) to 1 then Well Done! (In my DB2 Performance engagements I always ask for STATIME to be dropped to 5 or 1 – and no customer of mine has complained about what results.)