This page guides you to get the the content of the too large SCC if there is one, for more information about SCC refer to Transaction Configuration Center - Information - Definition and impacts of the large Strongly Connected Component
- CAST AIP 8.2 : TCC - CAST Transaction Configuration Center
- CAST AIP 8.1 : TCC - CAST Transaction Configuration Center
- CAST AIP 8.0 : TCC - CAST Transaction Configuration Center
|Microsoft SQL Server|
You can get the content of the largest SCC, or since 8.2.0 the content of the N most large SCC, for this you can perform the following:
If you are using an AIP version lower then 8.2.0 then run the following 2 queries on the KB:
delete from SYS_SITE_OPTIONS where OPTION_NAME = 'GRAPH_SAVE_LARGEST_SCC_GROUP'; Insert into SYS_SITE_OPTIONS(OPTION_NAME, OPTION_VALUE) values ('GRAPH_SAVE_LARGEST_SCC_GROUP', '1');
Else run the following 2 queres on the KB for getting the content of the N most large SCC (available only since 8.2.0):
delete from SYS_SITE_OPTIONS where OPTION_NAME = 'GRAPH_SAVE_LARGEST_SCC_GROUP'; Insert into SYS_SITE_OPTIONS(OPTION_NAME, OPTION_VALUE) values ('GRAPH_SAVE_LARGEST_SCC_GROUP', 'N'); -- where N is any integer value > 1
Relaunch results computation in TCC to populate
FP_LargestSCCtable if option value is 1
FP_LargeSCCtable if option value is > 1
Only one of these 2 tables will be populated, meaning that if option value is > 1, the
FP_LargestSCCtable will never get populated.
If option value is 1, the
FP_LargestSCCtable now contains in its only column
Object_IDthe list of all objects ID belonging to the largest SCC.
If option value is > 1, the
FP_LargeSCCtable now contains in its columns
Object_IDthe list of all objects ID belonging to the N largest SCCs, sorted by decreasing SCC size.
FP_LargestSCCtable would have been filled instead, we would have had
( select Object_ID from
select Object_ID from FP_LargeSCC where
If option value is 1, only objects in the largest SCC group will be reported in
FP_LargestSCC; if there are more than 1 excluded large SCC, you will only be able to investigate the largest one.
If option value is N > 1 (available only since 8.2.0), objects in the N most large SCC groups will be reported in
FP_LargeSCC, but N can be set as big as necessary for being able to investigate on any large SCC group.
In order to list the content you can run the following:
SELECT * FROM fp_largestscc
As output you will get the Ids of objects involved in the LSCC, the bellow result illustrate one row of the output