Check for Pending Operations | Teradata Vantage - 17.00 - 17.05 - Checking for Pending Operations - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - Advanced SQL Engine Node Software Migration Guide

Advanced SQL Engine
Teradata Database
Release Number
Release Date
June 2020
Content Type
Publication ID
English (United States)

A Pending Operation indicates that a table is currently in the middle of a data load operation. During this time, the table is unusable until the load operation completes. A load operation cannot begin on one release and complete after the migration on a different release. You must allow any active load operations to finish before starting the migration.

Most tables that are in a pending state are the result of previously aborted load operations. These operations will never complete, so these tables should be deleted because they are unusable.

Coordinate with the site database administrator to make sure all pending operations are finished, and no new transfer or load operations will be started until after the migration.

  1. Run CheckTable using the following command:

    check all tables at level pendingop skiplocks priority=h;

  2. Drop any tables that have pending operations.