manage-queues

Manage delayed Teradata request queues by releasing or aborting blocked requests.

7|Updated Dec 3, 2025
One-click install
npx skills add https://github.com/teradata-labs/claude-cookbooks --skill manage-queues
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: manage-queues
Source: https://github.com/teradata-labs/claude-cookbooks/tree/main/skills/operations/workloadmanagement/control/manage-queues
Command: npx skills add https://github.com/teradata-labs/claude-cookbooks --skill manage-queues

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This Skill addresses situations where queries or requests are stuck in system queues, leading to delays and potential SLA breaches, by providing tools to monitor, release, or abort them.

Core Features & Use Cases

  • Queue Monitoring: Inspect workload, system, and utility queues to identify bottlenecks and wait times.
  • Request Management: Release legitimate but delayed requests or abort unnecessary/problematic ones.
  • Root Cause Analysis: Helps in identifying underlying issues like throttles, locks, or maintenance conflicts causing queue buildup.
  • Use Case: During peak hours, if critical reports are stuck in the workload queue, this skill can be used to selectively release them while aborting less important ad-hoc queries.

Quick Start

Use the manage-queues skill to show all delayed requests in the queue.

Frequently Asked Questions about manage-queues

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I release delayed requests stuck in Teradata workload queues?

To release delayed requests in Teradata, use the `release_delayed_request` MCP tool to selectively free legitimate queries blocked by system throttling or lock conflicts, restoring normal workload flow.

Why are queries stuck in my Teradata delayed system queue?

Queries get stuck in the delayed system queue due to throttling limits, lock conflicts, or concurrent maintenance operations blocking request execution, which you can identify by inspecting the queue.

Can I abort specific delayed utility requests to resolve queue bottlenecks?

Yes, you can abort unnecessary or problematic delayed utility requests using the `abort_delayed_request` MCP tool, which removes them from the queue to resolve bottlenecks and maintain system flow.

What is the best way to monitor delayed request queues in a Teradata database?

The best way to monitor delayed request queues is using the `show_delayed_queue` MCP tool to inspect workload, system, and utility queues for bottlenecks and wait times.

How do I identify root causes of queue buildup in Teradata database operations?

Identify root causes of queue buildup by monitoring delayed queues to detect underlying issues like throttles, lock conflicts, or concurrent maintenance operations causing requests to block.

When should I abort instead of releasing a delayed request in Teradata?

Abort delayed requests when they are unnecessary or problematic ad-hoc queries causing bottlenecks, and release them only if they are legitimate but delayed critical reports stuck during peak hours.