INGEST LIST command

The INGEST LIST command lists basic information about INGEST commands that are being run by the authorization ID that is connected to the database. The ingest utility maintains statistics for a maximum of 128 ingest jobs running at a time.

Scope

A separate CLP session is required to successfully invoke this command. It must be run on the same machine that the INGEST command is running on.

Authorization

None

Required connection

Database

Command syntax

Read syntax diagramSkip visual syntax diagramINGEST LIST

Command parameters

Examples

=> INGEST LIST

Ingest job ID       = DB21000:20101116.123456.234567:34567:45678
Ingest temp job ID  = 1
Database Name       = MYDB
Input type          = FILE 
Target table        = MY_SCHEMA.MY_TABLE
Start Time          = 04/10/2010 11:54:45.773215
Running Time        = 01:02:03
Number of records processed = 30,000

Usage notes

  • The ingest temporary job ID is an integer you can use on the INGEST GET STATS command. It is provided to save you from typing the full job ID, but it is valid only while the INGEST command is running
  • The dates and times are displayed in the format of the current locale
  • The SET UTIL_IMPACT_PRIORITY command does not affect the INGEST command.
  • The util_impact_lim database manager configuration parameter does not affect the INGEST command.