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