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.)

Published by Martin Packer

.

One thought on “DB2 Version 9 – STATIME Default Decreased to 5

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: