/db2whrest/v1/summary_tables -X GET

Gets information on all the summary tables that are available in the system.

The following table shows which roles can access this REST API endpoint:
Table 1. Access by role
Data admin CollectionAdmin Data user Admin Service user
✓ X X Χ Χ

Synopsis of the request URL

curl -u <user>:<pass> https://<master_node>/db2whrest/v1/summary_tables -X GET

Supported request types and response formats

Supported request types:
  • GET
Supported response formats:
  • JSON

Examples

  1. The following example shows how to get information on all the summary tables that are available in the system.
    1. Submit the request:
      curl -u <user>:<pass> https://<master_node>/db2whrest/v1/summary_tables -X GET
    2. The following response is returned. The response data is in JSON format. The data has been manually reflowed to make it more readable.
      {
  "duplicates": {
    "enabled": false,
    "last_duration": null,
    "last_updated_time": "2019-07-10T18:39:58.348Z",
    "schedule": {
      "hour": 0,
      "minute": "14"
    },
    "update_running": false,
    "update_start_time": null
  },
  "mrcapacity": {
    "enabled": true,
    "last_duration": "0:01:10",
    "last_updated_time": "2019-07-10T21:45:02.462Z",
    "schedule": {
      "minute": "*/5"
    },
    "update_running": true,
    “update_start_time": "2019-07-10_21:50:01”
  }
}