Purpose

This page provides you with the definition of the checksum value of an object, and how to get this value from the knowledge base

Applicable in CAST Version
Release
Yes/No
8.3.x(tick)
8.2.x(tick)
8.1.x(tick)
8.0.x(tick)
Applicable RDBMS
RDBMS
Yes/No
Oracle Server(tick)
Microsoft SQL Server(tick)
CSS2(tick)
Query for CSS, Oracle, 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 from the Knowledge base as follows:

SELECT Inf.infval 
FROM   objinf Inf 
       join objfulnam Obj 
         ON Inf.idobj = obj.idobj 
WHERE  Inf.inftyp = 4 
       AND Inf.infsubtyp = 0 
       AND obj.fullname = '<FULL_NAME>'
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

Notes/comments