Monitoring Refresh |
Scroll |
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
<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.