Check the status of Datapump

-R

Returns all datapump column values that are important to the configuration of the data transfer including the status columns returned using the -r option.

-i

Returns the Datapump entries that failed or are in transit.

-I

Prints the failed Datapump entries.

-K

Returns the number of rows queued in each configured KeyTable. This information can indicate whether the transfer is backing up or working.

-e

Returns the Datapump events that occurred in the past 24 hours.

-S <source>

Identifies the source connection. The default is MS:(local). The source is specified as:

[system:[RDBMS:]][userid/passwd@]service

For example, -S MS:localhost\OASYSHDB.

The system must be specified when you only want to see information for a particular destination system.

RDBMS can be SYB, FILE, BINFILE, ORA, ODBC, or MS.

Use DPutil -h to obtain the list of RDBMS types available on your system.

-D <destination>

Identifies the destination connection.

The destination is specified in the same format as the source where the destination database is located in the same domain; for example, <system>\oasyshdb.

If the destination is located in a different domain, the Data Access Layer (DAL) driver, alias, and Remote Client Service (RCS) must be specified.

For example: main:MSDAL:Dir=sub\\remote_RCS_XFER;Alias=Historical_XFER

Where main is the DPSystem and sub is the destination system in the untrusted domain.

-d <database>

Identifies the database that contains the table to be compared between systems.

-t <table>

Identifies the table to be compared between systems.