While searching for another problem, I noticed a set of lines like the
following for each table in my database's schemas (including the SYS*
ones). What did I do (?) or what did DB2 see to cause this? It caused a
perceptible slow down in response time while it was going on.
ADM9501W BEGIN online index reorganization on table "IS3 .OWNERS" (ID
"108") and table space "USERSPACE1" (ID "2").
^^
2006-12-30-10.18.08.341116 Instance:db2inst1 Node:000
PID:26931(db2agent (ANIMALS)) TID:3005753856
Appid:*LOCAL.db2inst1.061230151711
relation data serv sqlrreorg_indexes Probe:18 Database:ANIMALS
ADM9503W Online index reorganization proceeds on index ID "1" in table "IS3
.OWNERS" (ID "108") and table space "USERSPACE1" (ID "2").
^^
2006-12-30-10.18.10.975121 Instance:db2inst1 Node:000
PID:26931(db2agent (ANIMALS)) TID:3005753856
Appid:*LOCAL.db2inst1.061230151711
relation data serv sqlrreorg_indexes Probe:31 Database:ANIMALS
ADM9502W END online index reorganization on table "IS3 .OWNERS" (ID
"108")
and table space "USERSPACE1" (ID "2").
^^
Mark A - 31 Dec 2006 22:27 GMT
> While searching for another problem, I noticed a set of lines like the
> following for each table in my database's schemas (including the SYS*
[quoted text clipped - 22 lines]
> and table space "USERSPACE1" (ID "2").
> ^^
Try turning off automatic maintenance and auto reorg..
db2 update db cfg for <db-name> using auto_maint off
db2 update db cfg for <db-name> using auto_reorg off