16.20 - Checking for Pending Operations - Teradata Vantage NewSQL Engine

Teradata Vantageā„¢ NewSQL Engine Node Software Migration Guide

prodname
Teradata Database
Teradata Vantage NewSQL Engine
vrm_release
16.20
created_date
March 2019
category
Administration
Configuration
Installation
featnum
B035-5942-162K

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.