“复制分析器”在 Windows 32 位系统和 AIX 上运行。要在 AIX 上运行“分析器”,应确保在 PATH 环境变量中,sqllib/bin 目录在 /usr/local/bin 之前出现,以避免与 /usr/local/bin/analyze 发生冲突。
“复制分析器”还有两个附加的可选关键字 CT 和 AT。
示例:
analyze mydb1 mydb2 f=mydirectory ct=4 at=2 deepcheck q=applyqual1
对于“复制分析器”,更新了以下关键字信息:
“分析器”工具是在 PTF 中提供的,供在 AS/400 平台上进行复制之用。这些工具收集有关复制环境的信息,并生成一个 HTML 文件,该文件可发送至“IBM 服务代表”以帮助确定问题所在。要获取 AS/400 工具,下载适当的 PTF(例如,对于产品 5769DP2,必须下载 PTF SF61798 或其最新的替代产品)。
将以下问题和解决方案添加至“Troubleshooting”一节:
Problem: The Apply program loops without replicating changes; the Apply trail table shows STATUS=2.
The subscription set includes multiple source tables. To improve the handling of hotspots for one source table in the set, an internal CCD table is defined for that source table, but in a different subscription set. Updates are made to the source table but the Apply process that populates the internal CCD table runs asynchronously (for example, the Apply program might not be started or an event not triggered, and so on). The Apply program that replicates updates from the source table to the target table loops because it is waiting for the internal CCD table to be updated.
To stop the looping, start the Apply program (or trigger the event that causes replication) for the internal CCD table. The Apply program will populate the internal CCD table and allow the looping Apply program to process changes from all source tables.
A similar situation could occur for a subscription set that contains source tables with internal CCD tables that are populated by multiple Apply programs.