By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,611 Members | 2,296 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,611 IT Pros & Developers. It's quick & easy.

Question on Reorging a Very Large Table

P: n/a
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
Share this Question
Share on Google+
1 Reply


P: n/a
"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 discussion thread is closed

Replies have been disabled for this discussion.