469,892 Members | 2,127 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,892 developers. It's quick & easy.

help with *.nfy contents; DB2 UDB 8.1.11 Linus

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").
^^
Dec 31 '06 #1
1 2053
"Bob Stearns" <rs**********@charter.netwrote in message
news:ny************@newsfe05.lga...
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").
^^
Try turning off automatic maintenance and auto reorg..

db2 update db cfg for <db-nameusing auto_maint off
db2 update db cfg for <db-nameusing auto_reorg off
Dec 31 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

9 posts views Thread by Bob Crane | last post: by
8 posts views Thread by Foxy Kav | last post: by
5 posts views Thread by ritchie | last post: by
reply views Thread by John Bowman | last post: by
4 posts views Thread by dsimmons | last post: by
8 posts views Thread by Dhananjay | last post: by
9 posts views Thread by dajava | last post: by
1 post views Thread by Alexnb | last post: by
1 post views Thread by Waqarahmed | last post: by
reply views Thread by Salome Sato | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.