CMS Snapshot Analysis - Run Analyzer - SQL Analyzer - Update SQL XXL Table Size - Information - Check if the SQL XXL Tables were loaded

Purpose

This page can be used to check if the SQL XXL Tables were properly loaded.

Applicable in CAST Version

Applicable RDBMS

Details

Checking SQLTABLESIZE information upload

To know which table has been tagged with the SQLTABLESIZE information, you can run on local site the following query:

SELECT OBJECT_NAME    ,
       OBJECT_FULLNAME,
       OI.InfVal
FROM   CDT_OBJECTS CO,
       ObjInf OI
WHERE  OI.IdObj     = CO.OBJECT_ID
AND    OI.InfTyp    = 1101000
AND    OI.InfSubTyp = 2

Finding XXL tables

To know which are the XXL tables, you can run on local site, run the following query:

SELECT OBJECT_NAME    ,
       OBJECT_FULLNAME,
       OI.InfVal
FROM   CDT_OBJECTS CO,
       ObjInf OI
WHERE  OI.IdObj     = CO.OBJECT_ID
AND    OI.InfTyp    = 1101000
AND    OI.InfSubTyp = 2
AND    OI.InfVal   >= 100000 -- change the value if you updated the threshold in the Assessment Model

If these two queries return no rows,then the SQL XXL Tables are not loaded.

Notes / Comments

The above queries are running based on CDT_OBJECTS which generally doesn’t contains data.

To populate data in CDT_OBJECTS, we need to run analysis with the CSV option available in the tool after analysis,

Related Pages