When Raw is selected, the following format is used for progress messages:
Raw progress messages have six fields separated by semicolons that are defined as follows:
The percentage of statement executed.
The number of completed pages, rows, or bytes.
The number of pages, rows, or bytes to be processed.
What is being processed: pages, rows, or bytes.
The current elapsed time displayed in milliseconds.
The estimated time in milliseconds remaining to complete the execution of the statement.
When Formatted is selected, the following format is used for progress messages:
43% (9728 of 22230 pages) complete after 00:00:05; estimated 00:00:06
Formatted progress messages are localized, and the time format is HH:MM:SS. Units less than 100 KB are displayed in bytes,
units less than 100 MB are displayed in KB, and units greater than 100 MB are displayed in MB.
Progress messages are sent at intervals that are 5% of the total estimated duration of the statement. Typically, the estimate
is completed and the first progress message is sent within 10 seconds. Additional progress messages are sent in intervals
of 30 seconds to 5 minutes. If the percentage complete is identical to the value sent in a previous message, an updated progress
message is not sent until more than 5 minutes have elapsed since the last message was sent. Progress messages are not sent
for statements that take less than 30 seconds to execute.
Estimates are recalculated continually; the accuracy of the remaining time estimate increases as the operation progresses.
During events such as backups, the total number of pages may be adjusted during statement execution, so the percent complete
and remaining time estimates change. With statements such as BACKUP...WITH CHECKPOINT COPY or UNLOAD SELECT the total number
of affected pages or rows is unknown and it is possible for the percentage complete value to be greater than 100%. As a result,
the estimated remaining time cannot be calculated and it is not included in the progress message.
The following statements and procedures support progress messages:
BACKUP DATABASE (both image and archive)
LOAD TABLE (USING FILE and USING CLIENT FILE only)
You can also set the progress_messages option in Interactive SQL by clicking Tools » Options » SQL Anywhere » Commands, and then clicking Show Progress Messages. When Show Progress Messages is enabled, the progress_messages option is set to Formatted.