在线REORG [英] ONLINE REORG
问题描述
我们在redhat linux上运行DB2 V8.2（8.1.0.80），我正在尝试将
设置为重组在线。我使用盒子上的控制中心 - db2cc
然后配置自动维护向导 - 并且可以获得runstats
在线，但reorg仅在活动设置中提供离线。
我试图理解为什么 - 我认为在线总是提供
？我认为我的所有索引都是类型2 - 我在表上运行了一些reorg
索引，如果它们不是，则转换它们。对于每个
表，我可以设置一个任务来在线进行重组，但不是通过
维护向导。
我错过了什么？
ta任何线索
andy
< an *********** @ ecngroup.co.nz>在消息中写道
news：11 ********************** @ f14g2000cwb.googlegr oups.com ...
我们在redhat linux上运行DB2 V8.2（8.1.0.80），我试图将reorg设置为在线。我使用盒子上的控制中心 - db2cc
然后配置自动维护向导 - 并且可以让runstats
联机，但reorg只能在活动设置中离线提供。
我试过理解为什么 - 我认为在线总是提供？我认为我的所有索引都是类型2 - 我在表上运行了一些reorg
索引来转换它们，如果不是的话。对于每个
表，我可以设置一个任务来在线进行重组，但不是通过
维护向导。
我缺少什么？
任何提示线索
andy
您需要启用LOGRETAIN = ON而不是默认的循环日志记录。
Make确定你明白它的含义是什么，并且你
有办法处理日志文件。
另外，如果你使用LOGRETAIN = ON，这可能会影响您的备份/恢复策略，
，因为您在进行在线备份时必须有可用的日志。
可能是确保日志可以在线获取
备份是将它们包含在备份映像中。
感谢您的回复
不确定这会如何影响重组 - 为什么doed logretain会改变我的方式
可以对表进行重组？
感谢您的回复
没有确定这会如何影响重组 - 为什么logretain会改变我的方式？
可以对表进行重组？
andy
Hi,
we are running DB2 V8.2 (8.1.0.80) on redhat linux and I am trying to
set the reorg to be online. I use the control center on the box - db2cc
and then configure automatic maintenance wizard - and can get runstats
to be online but reorg only offers offline at the activities settings.
I have tried to understand why - I thought that online was always
offered ? I think that all my indexes are type 2 - I ran some reorg
indexes all on the tables to convert them if they were not. For each
table I can set up a task to do a reorg online, but not through the
maintenance wizard.
What am I missing ?
ta for any clues
andy
<an***********@ecngroup.co.nz> wrote in message
news:11**********************@f14g2000cwb.googlegr oups.com...Hi,
we are running DB2 V8.2 (8.1.0.80) on redhat linux and I am trying to
set the reorg to be online. I use the control center on the box - db2cc
and then configure automatic maintenance wizard - and can get runstats
to be online but reorg only offers offline at the activities settings.
I have tried to understand why - I thought that online was always
offered ? I think that all my indexes are type 2 - I ran some reorg
indexes all on the tables to convert them if they were not. For each
table I can set up a task to do a reorg online, but not through the
maintenance wizard.
What am I missing ?
ta for any clues
andy
You need to enable LOGRETAIN=ON instead of the default of circular logging.
Make sure you understand what the implications of that are, and that you
have some way of dealing with the log files.
Also, if you use LOGRETAIN=ON, this may affect you backup/recovery strategy,
since you MUST have the logs available when doing an on-line backup.
Probably the best way to ensure that the logs are available with an on-line
backup is to include them in the backup image.
thanks for the reply
not sure how this affects a reorg - why doed logretain change the way I
can do a reorg of a table?
thanks for the reply
not sure how this affects a reorg - why does logretain change the way I
can do a reorg of a table?
andy
这篇关于在线REORG的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
