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 in GGSCI. 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.
STATUS EXTRACT group_name [, TASKS | ALLPROCESSES] [UPGRADE | DOWNGRADE]
group_nameThe 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.
TASKSDisplays status only for Extract tasks. By default, tasks are not displayed unless you specify a single Extract group (without wildcards).
ALLPROCESSESDisplays status for all Extract groups, including tasks.
UPGRADE | DOWNGRADEValid 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.
UPGRADEDisplays whether the Extract can be upgraded from classic capture mode to integrated capture mode.
DOWNGRADEDisplays whether the Extract can be downgraded from integrated capture mode to classic capture mode.