1. Reference
  2. Built-In Procedures
  3. ttDistributionProgress

ttDistributionProgress

This built-in procedure provides a progress report of an ongoing redistribution process.

Required Privilege

This procedure requires the ADMIN privilege.

Usage in TimesTen Scaleout and TimesTen Classic

This procedure is not supported in TimesTen Classic.

TimesTen Scaleout applications can call this built-in procedure.

This procedure returns a row for the element from which it was called.

Related Views

This procedure has no related views.

Syntax

ttDistributionProgress()

Parameters

ttDistributionProgress has no parameters.

Result Set

ttDistributionProgress returns the result:

Column Type Description

starttime

TT_TIMESTAMP NOT NULL

Time at which the status information was collected.

elementId

TT_INTEGER NOT NULL

Element ID of the local element.

ptVersion

TT_INTEGER NOT NULL

Version number of the partition table.

threadId

TT_INTEGER NOT NULL

Thread ID.

phase

VARCHAR2 (32) NOT NULL

Current phase of the redistribution process. The redistribution process has the following phases:

  • Data Distribution

  • Data Checkpoint

  • Data Checkpoint Done

  • Reclaim Phase 1

  • Reclaim Checkpoint

  • Reclaim Phase 2

  • Reclaim Done

tblName

VARCHAR2 (64)

Name of the table currently being processed, if available.

processedTblRows

TT_BIGINI

Number of rows already processed of the current table, if available.

insertedTblRows

TT_BIGINT

Number of rows already inserted to the current table in the local element, if available.

deletedTblRows

TT_BIGINT

Number of rows already deleted from the current table in the local element, if available.

totalTblRows

TT_BIGINT

Total number of rows in the table, if available.

processedRows

TT_BIGINT

Number of rows already processed for the element.

insertedRows

TT_BIGINT

Number of rows already inserted to the element.

deletedRows

TT_BIGINT NOT NULL

Number of rows already deleted from the element.

totalRows

TT_BIGINT NOT NULL

Total number of rows in the element for all tables.

processedTbls

TT_INTEGER NOT NULL

Number of tables already processed.

totalTbls

TT_INTEGER NOT NULL

Total number of tables in the database.

Examples

The following example shows an example result set for a call to the ttDistributionProgress built-in procedure. 

CALL ttDistributionProgress();
< 2021-09-13 14:49:41.065122, 1, 2, 1, Data Distribution, <NULL>, <NULL>, <NULL>,
 <NULL>, <NULL>, 1910, 0, 176, 1910, 8, 8 >
1 row found.