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 |
Applicable RDBMS
RDBMS | Yes/No |
---|---|
CSS |
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