INGEST GET STATS command

The INGEST GET STATS command displays statistics about one or more 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.

Syntax

Command parameters

ALL | job-ID: Specifies which INGEST command to show statistics for.
The job ID is either the full job ID enclosed in single quotation marks or the temporary job ID displayed by the INGEST LIST command.
EVERY number SECONDS: Specifies that a new row is to be appended to the displayed table every number seconds.
This parameter is valid only when an INGEST job-ID is specified (not when ALL is specified). When this parameter is specified, the only way to end the command is by pressing Ctrl+C or end the CLP session. The range for number of seconds is 1 to 86 400.
SHOW TOTALS: Specifies that statistics about each phase of ingest processing (transporter, formatter, and flusher) is to be displayed. When this parameter is omitted, the command displays only summary statistics.

Examples

Example of a basic INGEST GET STATS command output

=> INGEST GET STATS FOR 4

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

Overall          Overall          Current         Current 
ingest rate      write rate       ingest rate     write rate       Total records
(records/second) (writes/second) (records/second) (writes/second)
---------------- --------------- ---------------  ---------------- ----------------      
           54321            5432           76543             87654            98765

Example of an INGEST GET STATS command that provides statistics every 3 seconds

=> INGEST GET STATS FOR 4 EVERY 3 SECONDS

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

Overall          Overall          Current         Current 
ingest rate      write rate       ingest rate     write rate       Total records
(records/second) (writes/second) (records/second) (writes/second)
---------------- --------------- ---------------  ---------------- ----------------      
            3333           65432           76543             87654           108765
            3334           75432           86543             97654           118765
            3335           85432           96543            107654           128765 ...
(new row appended every 3 seconds)

Example of an INGEST GET STATS command that shows the totals for each phase

=> INGEST GET STATS FOR 4 SHOW TOTALS

===================================================================
Ingest job ID = DB21000:20101116.123456.234567:34567:4567
Database      = MYDB
Target table  = MY_SCHEMA.MY_TABLE1
-------------------------------------------------------------------
Totals for all transporters

                                   Since last query          Since command start
                                   ------------------------- ----------------------------
Number of bytes read                                  90,000                      180,000
Number of records read                                  3000                         6000
Bytes per second                                      10,000                       10,000
Records per second                                      1000                         1000

-----------------------------------------------------------------------------------------
Totals for all formatters

                                   Since last query          Since command start
                                   ------------------------- ----------------------------
Number of records formatted                             9000                       18,000
Records per second                                      3000                         3000
Number of records rejected                                 6                           12

-----------------------------------------------------------------------------------------
Totals for all flushers

                                   Since last query          Since command start
                                   ------------------------- ----------------------------
Number of records flushed                             12,000                       24,000
Records per second                                      4000                         4000
Number of records rejected                                 8                           16
Number of reconnects                                       4                            8
Number of retries                                         16                           32

Usage notes

For many statistics, the INGEST GET STATS command displays the statistics since the last INGEST GET STATS command (issued through the current window) and since the INGEST command started. As shown in the previous examples, these appear in different columns in the output.

Note: The format of the INGEST GET STATS command output should not be considered a programming interface. IBM reserves the right to change the format in future fix packs or releases.