Purpose

This page provides information on how to determine DLM (Dynamic Link Manager) status based on tables in the local database (KB).

For more information, refer to:

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)
Details

Run the following query on the KB to determine the information on the links stored in the KB.

SELECT
         CASE
                  WHEN prop=0
                  THEN 'default link non-DLM'
                  WHEN prop=1
                  THEN 'DLM link to be reviewed'
                  WHEN prop=32769
                  THEN 'DLM link reviewed validated'
                  WHEN prop=65537
                  THEN 'DLM link reviewed ignored'
         END,
         COUNT(prop)
FROM     acc
GROUP BY prop
ORDER BY prop;
  • A value of 0 for the prop column of the acc table indicates that these links are the default links from the analyzer (not Dynamic links).
  • A value of 1 for the prop column of the acc table indicates that these links are Dynamic links which need to be reviewed.
  • A value of 32769 for the prop column of the acc table indicates that these links are Dynamic links which have been reviewed and are validated.
  • A value of 65537 for the prop column of the acc table indicates that these links are Dynamic links which have been reviewed and are being ignored.

The query above will list the number of links found for each of these values of the column as shown below.

Query result example

"default link non-DLM";100

"DLM link to be reviewed";10

"DLM link reviewed validated";9

"DLM link reviewed ignored";7


Notes/comments

 

Related Pages