Upgrade Guide › Upgrading Databases › Database Upgrade Procedure › SQL Server: Post-Upgrade Table Change › Monitoring the Progress of Table Changes
Monitoring the Progress of Table Changes
Available for SQL Server CMSs only.
CA DLP provides two levels of logging for the post-upgrade changes to Wgn3EventParticipant:
- First, each step in the overall procedure is recorded in the Wgn3JobState database table for diagnostic purposes. For example, entries are written to this table when a foreign key constraint is dropped (or re-enabled), or when the database is changed from ‘multi user’ to ‘single user’ mode.
- Second, for each bcp copy operation, progress is logged in the bcp_ep_out.log and bcp_ep_in.log files for each 1,000 rows copied into or out of the table. In addition, summary data at the end of the log file shows the total time to copy all the rows and the average rate at which they were copied.