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 | |
8.2.x | |
8.1.x | |
8.0.x |
Applicable RDBMS
RDBMS | Yes/No |
---|---|
Oracle Server | |
Microsoft SQL Server | |
CSS2 |
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