473,320 Members | 2,088 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,320 software developers and data experts.

reorgs taking a long time

Hi all,

Ive got a script Ive built which runs reorgs on all tables needing it
based on output of reorgchk. The reorgs are ran inline. This past
weekend, the reorgs were running against 450 tables on a database that
is about 250 GB in size. The reorgs took all weekend and bled into
the week. Ultimately they did not finish. Where should I start
looking to speed this up? Thanks

rdudejr

Aug 8 '06 #1
3 5713
"rdudejr" <rd*****@gmail.comwrote in message
news:11**********************@h48g2000cwc.googlegr oups.com...
Hi all,

Ive got a script Ive built which runs reorgs on all tables needing it
based on output of reorgchk. The reorgs are ran inline. This past
weekend, the reorgs were running against 450 tables on a database that
is about 250 GB in size. The reorgs took all weekend and bled into
the week. Ultimately they did not finish. Where should I start
looking to speed this up? Thanks

rdudejr
What is an "inline" reorg? There are regular and on-line reorgs. A script
that runs a regular reorg does so sequentially, one table at a time. A
script that does an on-line reorg does it asynchronously, starting the next
reorg before the last reorg has finished. That has implications regarding
the amount work space needed for the reorgs if they are done simultaneously.

A reorg needs lots work space to run efficiently, either free space in the
tablespace where the table and indexes are located, or in a system temporary
tablespace if you specify that it be used for the reorg (see the REORG
command).
Aug 9 '06 #2
It was actually "inplace" that I meant to say....and do you think it
would help if I specified a temporary tablespace to be used? And can
one do so on the fly or does the tablespace have to already exist?
Mark A wrote:
"rdudejr" <rd*****@gmail.comwrote in message
news:11**********************@h48g2000cwc.googlegr oups.com...
Hi all,

Ive got a script Ive built which runs reorgs on all tables needing it
based on output of reorgchk. The reorgs are ran inline. This past
weekend, the reorgs were running against 450 tables on a database that
is about 250 GB in size. The reorgs took all weekend and bled into
the week. Ultimately they did not finish. Where should I start
looking to speed this up? Thanks

rdudejr

What is an "inline" reorg? There are regular and on-line reorgs. A script
that runs a regular reorg does so sequentially, one table at a time. A
script that does an on-line reorg does it asynchronously, starting the next
reorg before the last reorg has finished. That has implications regarding
the amount work space needed for the reorgs if they are done simultaneously.

A reorg needs lots work space to run efficiently, either free space in the
tablespace where the table and indexes are located, or in a system temporary
tablespace if you specify that it be used for the reorg (see the REORG
command).
Aug 9 '06 #3
One more thing that should help...this is an SMS tablespace, so would
that mean that it does not use any "extra" space in the tablespace to
do the reorg? Or will it make space temporarily?

rdudejr wrote:
It was actually "inplace" that I meant to say....and do you think it
would help if I specified a temporary tablespace to be used? And can
one do so on the fly or does the tablespace have to already exist?
Mark A wrote:
"rdudejr" <rd*****@gmail.comwrote in message
news:11**********************@h48g2000cwc.googlegr oups.com...
Hi all,
>
Ive got a script Ive built which runs reorgs on all tables needing it
based on output of reorgchk. The reorgs are ran inline. This past
weekend, the reorgs were running against 450 tables on a database that
is about 250 GB in size. The reorgs took all weekend and bled into
the week. Ultimately they did not finish. Where should I start
looking to speed this up? Thanks
>
rdudejr
>
What is an "inline" reorg? There are regular and on-line reorgs. A script
that runs a regular reorg does so sequentially, one table at a time. A
script that does an on-line reorg does it asynchronously, starting the next
reorg before the last reorg has finished. That has implications regarding
the amount work space needed for the reorgs if they are done simultaneously.

A reorg needs lots work space to run efficiently, either free space in the
tablespace where the table and indexes are located, or in a system temporary
tablespace if you specify that it be used for the reorg (see the REORG
command).
Aug 9 '06 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
by: datapro01 | last post by:
I have a question concerning reorgs. We have a relatively new DB2 system (8.1) on Aix 5.1 and we are trying to institute regular reorgs via scripts. Does it matter if the index for a table or...
2
by: Brian Kitt | last post by:
I have a process where I do some minimal reformating on a TAB delimited document to prepare for DTS load. This process has been running fine, but I recently made a change. I have a Full Text...
2
by: datapro01 | last post by:
Running DB2 8.2 on AIX 5.2 I have a question on reorgs and reorgchk results. My reorg script is using the db2reorgchk (which I understand has certain limitations) to determine if a table or an...
1
by: David Beardsley | last post by:
I'm working with several stored procedures processing a large volume of data. After monitoring their execution using Quest's Spotlight functionality I noticed a fair number of overflow accesses...
4
by: Michel Esber | last post by:
Hello, DB2 V8 LUW FP 11. My applications eventually takes a very long time to process simple insert statements. Here´s the output of a event monitor: Text : INSERT INTO MyTable...
1
by: daiesy.ember | last post by:
I'm working on implementing online reorgs(V8 FP11 on AIX), and am seeing a lot of transaction logging during the reorgs. My problem is that the archive logs are filling up the active log path...
3
by: jmark | last post by:
I have PHP 5.2.1 running on Windows XP home. The problem I have is that programs run in the command line are taking more than 10 minutes to exit. Does anyone know a solution to this?
0
by: mmcsbell | last post by:
What considerations do I need to take for conducting offiline reorgs in and HADR environment? Do I need to stop HADR or will the reorganization take care of both nodes?
4
by: eliane | last post by:
For some reason, DB2 is taking a long time to start archiving the logs. Pls, do you know what could be causing it? I see the following msgs on db2diag.log 2008-09-04-00.36.24.414103+000...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
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...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you

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.