In some cases, you may want to remove snapshot rowsets once they have been processed into delta rowsets. In other cases, you may want to remove an improperly built snapshot rowset before building the delta rowsets.
To clear out old data or remove incorrect SNPASHOT rowsets, you can use the SNAPDEL function.
SNAPDEL provides various selection parameters to limit which rowsets are deleted. Before running SNAPDEL, you should run a SNAPRPT using the same selection criteria to verify that only the unneeded rowsets are deleted. As a precaution, you can also decide to back up the Snapshot database (1019) before running the delete.
Use the AUTOCOLL OPTION=SNAPDEL function to delete a set of Snapshot rowsets. The snapshot rowset delete function removes all rows in each table that match the selection criteria. It provides a report of the rows that were deleted from each table.
The expected return code is 0 when executing the SNAPDEL function. For details about the AUTOCOLL OPTION=SNAPDEL syntax, parameters, and sample output report see the CA Datacom/DB DBUTLTY Reference Guide.
|
Copyright © 2014 CA.
All rights reserved.
|
|