Aggregate Compare

The Aggregate Compare test type can aggregate a display of lower data and compare it to a higher display of data. (i.e. aggregate the statement data and compare it to the program data)

Jenkins Test Status

The table below lists the jenkins tests that are available and what the status of the last run of the test was. Click on the status icon to go straight to jenkins for the particular build project.

Jenkins Build Name Status
PDT_aggregate_compare_all_standard_activity Build Status
PDT_aggregate_oompare_plan_level_single_test Build Status
PDT_aggregate_oompare_program_level_single_test Build Status
PDT_aggregate_oompare_key_level_single_test Build Status
PSA_aggregate_oompare_dbase_level_single_test Build Status

Test Parameters

The table below lists the required and optional parameters that are valid for this test. Follow the link by clicking on the parameter name in the JSON column. If the parameter has a command line override option it will be listed in the Command Line Override column. Additionally there are examples at the bottom of this page.

Required

JSON Command Line Override Special Usage or Note
product_code
test_type
lpar lpar
userid userid
ssid ssid
current_vcat current_vcat
current_datastore current_datastore
current_interval_date current_interval_date
current_interval_time current_interval_time
level The following additional JSON parameters are required, unless otherwise indicated, when level is:

Optional

JSON Command Line Override Special Usage or Note
environment environment
output_location output_location
column column Can be used to indicate that only the data in the specified column should be compared for the test.
current_interval_date_2 current_interval_date_2
current_interval_time_2 current_interval_time_2

JSON Examples


Aggregate program stats to plan level for all plans

{
    "connection":
    {
      "lpar": "ca31",
      "ssid": "d12a",
      "userid": "QARTP01"
    },
    "tests":
    [
      {
        "test_type": "aggregate compare",
        "product_code": "PDT",
        "environment": "SPEAN03.R19.PARMLIB",
        "current_vcat": "PDTDBA.SPEAN03",
        "current_datastore": "python",
        "current_interval_date": "16/07/20",
        "current_interval_time": "10:42:34",
        "level": "PLAN",
        "plan": "ALL"
      }
    ]
}

Aggregate program stats to plan level for a specific plan only.

{
    "connection":
    {
      "lpar": "ca31",
      "ssid": "d12a",
      "userid": "QARTP01"
    },
    "tests":
    [
      {
        "test_type": "aggregate compare",
        "product_code": "PDT",
        "environment": "SPEAN03.R19.PARMLIB",
        "current_vcat": "PDTDBA.SPEAN03",
        "current_datastore": "python",
        "current_interval_date": "16/07/20",
        "current_interval_time": "10:42:34",
        "level": "PLAN",
        "plan": "RTPPLNMN"
      }
    ]
}

Aggregate statement stats to program level for all programs in a plan.

{
    "connection":
    {
      "lpar": "ca31",
      "ssid": "d12a",
      "userid": "QARTP01"
    },
    "tests":
    [
      {
        "test_type": "aggregate compare",
        "product_code": "PDT",
        "environment": "SPEAN03.R19.PARMLIB",
        "current_vcat": "PDTDBA.SPEAN03",
        "current_datastore": "python",
        "current_interval_date": "16/07/20",
        "current_interval_time": "10:42:34",
        "level": "PROGRAM",
        "plan": "RTPPLNMN",
        "program": "ALL"
      }
    ]
}

Aggregate statement stats to program level for a specific program.

{
    "connection":
    {
      "lpar": "ca31",
      "ssid": "d12a",
      "userid": "QARTP01"
    },
    "tests":
    [
      {
        "test_type": "aggregate compare",
        "product_code": "PDT",
        "environment": "SPEAN03.R19.PARMLIB",
        "current_vcat": "PDTDBA.SPEAN03",
        "current_datastore": "python",
        "current_interval_date": "16/07/20",
        "current_interval_time": "10:42:34",
        "level": "PROGRAM",
        "plan": "RTPPLNMN",
        "program": "REG133DR",
        "collid": "RTPCOLMN"
      }
    ]
}

Aggregate plan stats to key level for a ALL keys.

{
    "connection":
    {
      "lpar": "ca31",
      "ssid": "d12a",
      "userid": "QARTP01"
    },
    "tests":
    [
      {
        "test_type": "aggregate compare",
        "product_code": "PDT",
        "environment": "SPEAN03.R19.PARMLIB",
        "current_vcat": "PDTDBA.SPEAN03",
        "current_datastore": "python",
        "current_interval_date": "16/07/20",
        "current_interval_time": "10:42:34",
        "level": "KEYS",
        "key_value": "ALL"
      }
    ]
}

Aggregate plan stats to key level for a specific key.

{
    "connection":
    {
      "lpar": "ca31",
      "ssid": "d12a",
      "userid": "QARTP01"
    },
    "tests":
    [
      {
        "test_type": "aggregate compare",
        "product_code": "PDT",
        "environment": "SPEAN03.R19.PARMLIB",
        "current_vcat": "PDTDBA.SPEAN03",
        "current_datastore": "python",
        "current_interval_date": "16/07/20",
        "current_interval_time": "10:42:34",
        "level": "KEYS",
        "key_option": "U",
        "key_value": "SPEAN03",
        "line_command": "P"
      }
    ]
}

Aggregate program stats to key level for ALL keys.

{
    "connection":
    {
      "lpar": "ca31",
      "ssid": "d12a",
      "userid": "QARTP01"
    },
    "tests":
    [
      {
        "test_type": "aggregate compare",
        "product_code": "PDT",
        "environment": "SPEAN03.R19.PARMLIB",
        "current_vcat": "PDTDBA.SPEAN03",
        "current_datastore": "python",
        "current_interval_date": "16/07/20",
        "current_interval_time": "10:42:34",
        "level": "KEYS",
        "key_option": "U",
        "key_value": "ALL",
        "line_command": "G"
      }
    ]
}

Aggregate program stats to key level for particular key.

{
    "connection":
    {
      "lpar": "ca31",
      "ssid": "d12a",
      "userid": "QARTP01"
    },
    "tests":
    [
      {
        "test_type": "aggregate compare",
        "product_code": "PDT",
        "environment": "SPEAN03.R19.PARMLIB",
        "current_vcat": "PDTDBA.SPEAN03",
        "current_datastore": "python",
        "current_interval_date": "16/07/20",
        "current_interval_time": "10:42:34",
        "level": "KEYS",
        "key_option": "C",
        "key_value": "TSO CAF",
        "line_command": "G"
      }
    ]
}

Aggregate program stats to plan level for all plans for a range of intervals

{
    "connection":
    {
      "lpar": "ca31",
      "ssid": "d12a",
      "userid": "QARTP01"
    },
    "tests":
    [
      {
        "test_type": "aggregate compare",
        "product_code": "PDT",
        "environment": "SPEAN03.R19.PARMLIB",
        "current_vcat": "PDTDBA.SPEAN03",
        "current_datastore": "python",
        "current_interval_date": "16/07/20",
        "current_interval_date_2": "16/07/20",
        "current_interval_time": "10:42:34",
        "current_interval_time_2": "12:42:34",
        "level": "PLAN",
        "plan": "ALL"
      }
    ]
}