如何确定我的SDP进程是否仍在运行“初始”负载？ [英] How can I tell if my SDP process is still running the 'initial' load?

问题描述

您不能在DashDB上运行任何sql语句，这些语句会导致在初始加载期间与架构发现过程（SDP）冲突的锁。详情请参见此处：

You cannot run any sql statements on a DashDB that result in locks that will conflict with the schema discovery process (SDP) during the initial load. See here for more information:

SQLCODE = -911： warehouser_error_message：文件<<文件名>> .csv.zip由于dashDB中的异常而无法加载

问题：如何验证SDP是否正在运行初始加载？

Question: How can I verify if SDP is running the initial load?

推荐答案

登录到Cloudant仪表板，然后选择 _warehouser 数据库。在该数据库中，选择代表您要验证其状态的SDP的文档。在该文档中，查找标记 sub_status ：

Log in to the Cloudant dashboard and select the _warehouser database. Inside that database, select the document that represents the SDP that you are trying to verify the status of. Inside that document, look for the tag sub_status:

  "replication_status": {
    "yourdatabase": {
      ...
      "sub_status": "initial",
      ...
    }
  },

初始加载时将其设置为 initial 和 continuous （初始加载完成后）。

This will be set to initial for the initial load and continuous when the initial load has finished.

这篇关于如何确定我的SDP进程是否仍在运行“初始”负载？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！