SQL Queries - CAST Central Base - Queries on Objects - How to get the checksum of an object in a given snapshot based on its full name

Purpose

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

Applicable in CAST Version

Applicable RDBMS

Query for CSS

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>

Query result example

1933263931

Query result interpretation

This means that the checksum value of object whose full name is <FULL_NAME>‘is equal to 1933263931 in sanpshot <SNAPSHOT_ID>

Query for Oracle

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>

Query result example

245461564

Query result interpretation

This means that the checksum value of object whose full name is <FULL_NAME> is equal to 245461564 in snapshot <SNAPSHOT_ID>

Query for SQL Server

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>

Query result example

 245461564

Query result interpretation

This means that the checksum value of the object whose full name is <FULL_NAME> is equal to 245461564 in snapshot <SNAPSHOT_ID>

Notes/comments

Related Pages

SQL Queries - CAST Knowledge Base - Queries on objects - How to get the checksum of an object