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

Question on Reorging a Very Large Table

X-No-Archive: Yes

I have a questionabout reorging very large tables. Running DB2 8.1
Fixpack 6 on AIX 5.2 supporting Siebel. I've read through the docs I
could find and the postings in this newsgroup on the challenges in
reorging very large tables, using partitioning, MDC, union all views
of smaller tables etc.

However in supporting Siebel we can't partition. The online reorg runs
for a week,

My question is would it be advisable to break down the reorg over,
say, 3 to 4 days,and reorg a portion of the table each night using
views? Are you losing some or most of the effectiveness of the reorg
doing it that way?

If you had to reorg a few very large tables and you couldn't break
down the tables into smaller ones or partition the db, how would you
do it?

Thanks in advance.
G

Feb 12 '07 #1
1 1948
"datapro01" <da*******@yahoo.comwrote in message
news:11*********************@v45g2000cwv.googlegro ups.com...
X-No-Archive: Yes

I have a questionabout reorging very large tables. Running DB2 8.1
Fixpack 6 on AIX 5.2 supporting Siebel. I've read through the docs I
could find and the postings in this newsgroup on the challenges in
reorging very large tables, using partitioning, MDC, union all views
of smaller tables etc.

However in supporting Siebel we can't partition. The online reorg runs
for a week,

My question is would it be advisable to break down the reorg over,
say, 3 to 4 days,and reorg a portion of the table each night using
views? Are you losing some or most of the effectiveness of the reorg
doing it that way?

If you had to reorg a few very large tables and you couldn't break
down the tables into smaller ones or partition the db, how would you
do it?

Thanks in advance.
G
It would help if you could post the following information:

Average row length (the Control Center can calculate that for you).
Number of rows.
Are than any LONG VARCHAR, CLOB, BLOB, etc columns in the table?
Exact tablespace definition for the tablespace where the table is located,
and of all System Temporary Tablespaces (DDL would be preferable)..
Number of useable, used, and free pages in the tablespaces mentioned above
(db2 list tablespaces show detail).
df -k on the mount point where your data is stored, and for your System
Temporary Tablespaces (post last 2 lines of dir if using Windows).
..
Feb 13 '07 #2

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

Similar topics

8
by: Tony Clarke | last post by:
Hi, Just a quick question about performance with MySQL & PHP. If I had a table in a MySQL database with about 100,000 records in it and I need to find the last record is there a quick way to do...
7
by: gino | last post by:
Dear all, My monitor was set to 1600x1200 so the fonts in IE is too small for me even when I set the "View->Text Size->Largest"... I don't have previlage to change the monitor resolution... ...
5
by: Don Vaillancourt | last post by:
Hello all, Over the years as I design more database schemas the more I come up with patterns in database design. The more patterns I recognize the more I want to try to design some kind of...
8
by: Együd Csaba | last post by:
Hi All, how can I improve the query performance in the following situation: I have a big (4.5+ million rows) table. One query takes approx. 9 sec to finish resulting ~10000 rows. But if I run...
7
by: chessplayer | last post by:
Greetings Folks, I am trying to understand how DB2 locks data and can't believe my eyes. Have read the literature about the difference isolation levels and have a general understanding about...
55
by: Steve Jorgensen | last post by:
In a recent thread, RKC (correctly, I believe), took issue with my use of multiple parameters in a Property Let procedure to pass dimensional arguments on the basis that, although it works, it's...
11
by: Chris Naylor | last post by:
I'm sure that to most of you this will be an easy answer but to me it isn't so here goes.. I have a database that I want to export a table from into Excel format so that I can use it on my...
1
by: Dennis Gearon | last post by:
My question is it possible to speed up a query doing preselects? What I'm working on could end up being a very large dataset. I hope to have 100-1000 queries per second (0r more?), and if very large...
10
by: Avi | last post by:
Hi I need to read in a large set of text files (9GB+ each) into a database table based on fixed width lengths. There are several ways to complete this, but I am wondering if anyone has...
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...
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
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

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.