Previous Topic: Executing the AUTOCOLL SNAPSHOT FunctionNext Topic: Deleting Snapshot Rowsets


Reporting Snapshot Rowsets

You can produce reports on specific Snapshot rowsets with the AUTOCOLL OPTION=SNAPRPT function. The report provides information about each of the rowsets and the number of rows in each SNAPSHOT table that is part of that rowset.

The rowset report is used to determine what snapshots are available to be processed into deltas. The report does not list the various rows and their contents.

To see snapshot row contents you need to use one of the various query tools provided in CA Datacom (CA Dataquery, DBSQLPR, DB Reporter option, and so on). While user programs can also be written using the standard RAAT, SAAT and SQL APIs, we recommend that they are not used to manipulate the snapshot rows data content as this can create problems for the rest of the AutoCollect functions.

The expected return code is 0 when executing the SNAPRPT function. For details about the AUTOCOLL OPTION=SNAPRPT syntax, parameters, and sample output report see the CA Datacom/DB DBUTLTY Reference Guide.