You can use the INGEST LIST or INGEST GET STATS commands to monitor the progress of INGEST commands.
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.
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
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
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.