Monitoring ingest operations

You can use the INGEST LIST or INGEST GET STATS commands to monitor the progress of INGEST commands.

Before you begin

To issue the INGEST LIST and INGEST GET STATS commands, you need a separate CLP session but they must be run on the same machine that the INGEST command is running on.

Procedure

There are a number of ways to monitor an ingest operation:
  • To get basic information about all currently running INGEST commands, use the INGEST LIST command.
  • To get more detailed information about a specific INGEST command or all currently running INGEST commands, use the INGEST GET STATS command.
  • You can also query the following monitor elements by using an interface such as the MON_GET_CONNECTION table function:
    • client_acctng
    • client_applname
    • appl_name
    • client_userid
    • client_wrkstnname

Example

The following shows an example of what output to expect from an INGEST LIST command:
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
The following shows an example of what output to expect from an INGEST GET STATS command:
INGEST GET STATS FOR 4

Ingest job ID = DB21000:20101116.123456.234567:34567:4567
Database      = MYDB
Target table  = MY_SCHEMA.MY_TABLE1

Records/sec      Flushes/sec       Records/sec     Flushes/sec
since start      since start       since last      since last       Total records
---------------- ----------------- --------------- ---------------- -------------
54321            65432             76543           87654            98765
The following shows an example of using the MON_GET_CONNECTION table function to get the number of rows modified and the number of commits:
SELECT client_acctng AS "Job ID",
      SUM(rows_modified) AS "Total rows modified", 
      SUM(total_app_commits) AS "Total commits" 
   FROM TABLE(MON_GET_CONNECTION(NULL, NULL))
   WHERE application_name = 'DB2_INGEST' 
   GROUP BY client_acctng 
   ORDER BY 1

Job ID                                         Total rows modified Total commits
---------------------------------------------- ------------------- -------------
DB21000:20101116.123456.234567:34567:45678                    92            52
DB21000:20101116.987654.234567:34567:45678                   172           132

  2 record(s) selected.