Check Datapump status

DPutil -S source -D destination -d database -t table [-r] [-R] [-i] [-I] [-K] [-e]

Prints a summary that contains the same information as in the XOS Datapump summary.

-R

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

-i

Prints the Datapump entries that failed or are in transit.

-I

Prints the Datapump entries that failed or are in transit.

-K

Prints the number of rows queued up in each configured key table. It gives you an idea of whether the transfer is working or if it is backing up.

-e

Print the datapump events for past 24 hours.

-S source

Identifies the source connection (the default is MS:(local)). The source is specified as: [system:[RDBMS:]][userid/ password@]service. System is specified when you want to only 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. For example: -S MS:localhost\OASYSHDB

-D destination

Identifies the destination connection (the default is XISB). The destination is specified in the same manner as the source.

-d database

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

-t table

Identifies the table to be compared between systems.