Once a Refresh request has been completed, the Apply engine will display messages indicating the start and completion time of the refresh as well as a count of the rows refreshed for the table.
While the Refresh is being processed, progress can be displayed by a query of the SQDATA.REFRESH_REQUEST_LOG table or through a request to the capture/publisher:
Syntax
//*-----------------------------------------------
//*- Display Table Refresh progress
//*-----------------------------------------------
//DISPLAY EXEC PGM=SQDCONF
//SYSOUT DD SYSOUT=*
//SQDPARMS DD *
display <cab_file_name>
--refresh
Keyword and Parameter Descriptions
| Keyword | Description |
|---|---|
| <cab_file_name> | Must be specified and must match the name specified in the previous create command. |
| --refresh |
Displays the number of rows and slices published. |