Extract progress report


The Extract Progress Report shown in the following figure displays which objects are being accessed during the extract and includes the number of rows (records) extracted for each object.

Extract Progress Report

File-Aid/RDX  23.01.00                                      Extract Progress Report                                 PAGE  1
                                                                                                                    DATE  2014-09-02
Extract File. . : TSOID01.R42.EXTRACT(Member)                                                                       TIME  09.01.06
Extract Request : TSOID01.RDX.EXTCRIT.D050815.T090104                                                               SSID  DSN
Driving Object. : D-LOCATION_1____+_.CREATOR__1____+____2____+____3____+____4____+____5____+____6____+____7____+____8____+____9_____
                    +___10____+___11____+___12____+___.TABLE____1____+____2____+____3____+____4____+____5____+____6____+____7____+__
                    __8____+____9____+___10____+___11____+___12____+___   

Time            Rows  Extracted Object                                  
--------  ----------  --------------------------------------------------------------------------------------------------------------
09:01:07          25  D-LOCATION_1____+_.CREATOR__1____+____2____+____3____+____4____+____5____+____6____+____7____+____8____+____9_
                        ____+___10____+___11____+___12____+___.TABLE____1____+____2____+____3____+____4____+____5____+____6____+____
                        7____+____8____+____9____+___10____+___11____+___12____+___   
09:01:08          18  D-LOCATION_1____+_.CREATOR__1____+____2____+____3____+____4____+____5____+____6____+____7____+____8____+____9_
                        ____+___10____+___11____+___12____+___.TABLE____1____+____2____+____3____+____4____+____5____+____6____+____
                        7____+____8____+____9____+___10____+___11____+___12____+___   
09:01:08           3  M-TSOID01.FASAMP.EMPMAST                          
09:01:09           8  D-DSNLOCAT.TSOID01.DEPT                                    
09:01:09           1  D-DSNLOCAT.TSOID01.DEPT 


The Extract Progress Report displays the extract progress for each object. It includes the following information:

Time

Shows the time when the progress report for this object was written.

Rows

The number of rows (records) extracted from the current object so far. The update interval can be set with the User Parm "Table Progress Row Count" (see also Option 0—Profile). In this example the progress row count parameter was set at 25.

Extracted Object

The name of the object from which data has been extracted so far.

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*