473,385 Members | 1,855 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,385 software developers and data experts.

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 2118
"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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

9
by: Bob Crane | last post by:
In the wired article ( wired.com ) which Linus picture is hotter? A) The Arnold looking Linus on Page 1. B) The collegiate looking Linux wearing the Tux on Page 3. What's your opinion?
8
by: Foxy Kav | last post by:
Hi everyone, Im currently doing first year UNI, taking a programming course in C++, for one project i have to create a simple array manipulator... that i have done, but i cant figure out how to...
5
by: ritchie | last post by:
Hi, I am writing to ask if anyone can see why my array is not being sorted correctly? It's an array of 4 elements(ints 1,2,3,4) but after calling the selection sort it comes back sorted as...
0
by: John Bowman | last post by:
Hi, I'm not certain if this is the proper place to post this, but here it goes... I must be missing something really obvious and am adminttedly a newbie w/ Help systems, I cannot get help to...
4
by: dsimmons | last post by:
On my website http://seasidequilters.blogspot.com/ I'm having a problem that someone thinks might be associated with Firefox browsers. I'm hoping to find someone in this forum that might be...
8
by: Dhananjay | last post by:
hello everyone Do you have any information how to generate a tool using .net which is used to translate the web page contents to html format. Plz reply me asap Thanks in advance Dhananjay
9
by: dajava | last post by:
Hi, Sorry for this beginner's question. I do not know PHP and write for my friend. He has never been a professional programmer. He studied C and PHP with some books and made a bulletin...
16
by: Okonita via DBMonster.com | last post by:
Hi all, I am comming along with all this Linus/DB2/scripting business...I am no longer scared of it!! (LOL). But, I need to create a .ksh script that does a REORGCHK and output only tables...
1
by: Alexnb | last post by:
The trick to this one is that the html looks something like this: <td width="100%" colspan="2"> american, a href="/browse/blue" linkindex="12" set="yes">blue brick churn cottage cream " My...
1
by: johnjohnbytes | last post by:
Hi, can someone help me on following issues:- i have a WebReference1 in my C# NET projects, and after i refererence, i can simply DOT OUT a function and pass in parameter. However I facing...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
by: ryjfgjl | last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.