This page provides you with the definition of the checksum value of an object, and how to get this value from the central base for a given snapshot
Release | Yes/No |
---|---|
8.3.x | |
8.2.x | |
8.1.x | |
8.0.x |
RDBMS | Yes/No |
---|---|
Oracle Server | |
Microsoft SQL Server | |
CSS2 |
Checksum values are calculated by CAST AIP for objects resulting from an analysis and are used to determine whether an object has changed between successive snapshots, however, CAST AIP is not able to determine the checksum for certain objects and these objects always have a checksum value of 0.
You can get the checksum value of an object in a given snapshot from the Central base as follows:
SELECT doi.object_checksum FROM dss_object_info doi JOIN dss_objects dos ON dos.object_id = doi.object_id WHERE dos.object_fullname = '<FULL_NAME>' AND doi.snapshot_id = <SNAPSHOT_ID>
1933263931
This means that the checksum value of object whose full name is <FULL_NAME>'is equal to 1933263931 in sanpshot <SNAPSHOT_ID>
Checksum values are calculated by CAST AIP for objects resulting from an analysis and are used to determine whether an object has changed between successive snapshots, however, CAST AIP is not able to determine the checksum for certain objects and these objects always have a checksum value of 0.
You can get the checksum value of an object in a given snapshot from the Central base as follows:
SELECT doi.object_checksum FROM dss_object_info doi JOIN dss_objects dos ON dos.object_id = doi.object_id WHERE dos.object_fullname = '<FULL_NAME>' AND doi.snapshot_id = <SNAPSHOT_ID>
245461564
This means that the checksum value of object whose full name is <FULL_NAME> is equal to 245461564 in snapshot <SNAPSHOT_ID>
Checksum values are calculated by CAST AIP for objects resulting from an analysis and are used to determine whether an object has changed between successive snapshots, however, CAST AIP is not able to determine the checksum for certain objects and these objects always have a checksum value of 0.
You can get the checksum value of an object in a given snapshot from the Central base as follows:
SELECT doi.object_checksum FROM dss_object_info doi JOIN dss_objects dos ON dos.object_id = doi.object_id WHERE dos.object_fullname = '<FULL_NAME>' AND doi.snapshot_id = <snapshot_id>
245461564
This means that the checksum value of the object whose full name is <FULL_NAME> is equal to 245461564 in snapshot <SNAPSHOT_ID>