Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
Database Servers
DB2InformixIngresMS SQLOraclePervasive.SQLPostgreSQLProgressSybase
Desktop Databases
FileMakerFoxProMS AccessParadox
General
General DB TopicsDatabase Theory
Related Topics
Java Development.NET DevelopmentVB DevelopmentMore Topics ...

Database Forum / DB2 Topics / December 2006

Tip: Looking for answers? Try searching our database.

help with *.nfy contents; DB2 UDB 8.1.11 Linus

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Bob Stearns - 31 Dec 2006 22:09 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*
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
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.