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
Release
Yes/No
8.3 x(tick)
Applicable RDBMS
RDBMS
Yes/No
CSS(tick)
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:


Checking SQLTABLESIZE information upload
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:


Finding XXL Tables
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