dba_resusageSummary

Analyze Teradata system resource usage by weekday, hour, workload type, and query complexity. Aggregate metrics using dimensions like user name, date, dayOfWeek, and hourOfDay for detailed insights.

Instructions

Get the Teradata system usage summary metrics by weekday and hour for each workload type and query complexity bucket.

Arguments: dimensions - list of dimensions to aggregate the resource usage summary. All dimensions are: ["LogDate", "hourOfDay", "dayOfWeek", "workloadType", "workloadComplexity", "UserName", "AppId", "StatementType"] user_name - user name date - Date to analyze, formatted as YYYY-MM-DD dayOfWeek - day of the week to analyze hourOfDay - hour of day to analyze

Input Schema

Name	Required	Description	Default
`date`	No
`dayOfWeek`	No
`dimensions`	No
`hourOfDay`	No
`user_name`	No

Input Schema (JSON Schema)

{
  "properties": {
    "date": {
      "anyOf": [
        {
          "type": "string"
        },
        {
          "type": "null"
        }
      ],
      "default": null,
      "title": "Date"
    },
    "dayOfWeek": {
      "anyOf": [
        {
          "type": "string"
        },
        {
          "type": "null"
        }
      ],
      "default": null,
      "title": "Dayofweek"
    },
    "dimensions": {
      "anyOf": [
        {
          "items": {
            "type": "string"
          },
          "type": "array"
        },
        {
          "type": "null"
        }
      ],
      "default": null,
      "title": "Dimensions"
    },
    "hourOfDay": {
      "anyOf": [
        {
          "type": "string"
        },
        {
          "type": "null"
        }
      ],
      "default": null,
      "title": "Hourofday"
    },
    "user_name": {
      "anyOf": [
        {
          "type": "string"
        },
        {
          "type": "null"
        }
      ],
      "default": null,
      "title": "User Name"
    }
  },
  "title": "handle_dba_resusageSummaryArguments",
  "type": "object"
}

Teradata MCP Server