STATUS EXTRACT

Use STATUS EXTRACT to determine whether or not Extract is running. A status of RUNNING can mean one of the following:

Active: Running and processing (or able to process) data. This is the normal state of a process after it is started.
Suspended: The process is running, but suspended due to an EVENTACTIONS SUSPEND action. In a suspended state, the process is not active, and no data can be processed, but the state of the current run is preserved and can be continued by issuing the RESUME command. The RBA in the INFO command reflects the last checkpointed position before the suspend action. To determine whether the state is active or suspended, issue the SEND EXTRACT command with the STATUS option.

Admin Client Syntax

STATUS EXTRACT group_name [, TASKS | ALLPROCESSES]

GGSCI Syntax

STATUS EXTRACT group_name [, TASKS | ALLPROCESSES] [UPGRADE | DOWNGRADE]

group_name

The name of an Extract group or a wildcard (*) to specify multiple groups. For example, T* returns status for all Extract groups whose names begin with T.

TASKS

Displays status only for Extract tasks. By default, tasks are not displayed unless you specify a single Extract group (without wildcards).

ALLPROCESSES

Displays status for all Extract groups, including tasks.

UPGRADE | DOWNGRADE

Valid for an Oracle database only. If Extract cannot be upgraded or downgraded, the reason why is displayed. A wildcarded Extract name is not allowed with this option. Before using this command, issue the DBLOGIN command.

UPGRADE: Displays whether the Extract can be upgraded from classic capture mode to integrated capture mode.
DOWNGRADE: Displays whether the Extract can be downgraded from integrated capture mode to classic capture mode.

Examples

STATUS EXTRACT finance

STATUS EXTRACT fin*