TRACKING Table Set-Up and Maintenance
The TRACKING table is a table in the global schema of the SFX installation that is used to keep track of changes in any of the local instance databases or the global schema. The TRACKING table is updated by triggers and stores all changes to be included in SFX-Verde publishing and in the incremental build of the RSI and eBook Search indexes.
To access this option, select 13 TRACKING table set-up and maintenance (only by sfxglb41) from the Main menu. The following is displayed
|
1 Check status of TRACKING table and triggers 2 Create table and triggers 3 TRACKING table cleanup |
:
Checking the Status of the Tracking Table and the Triggers
Select 1 Check status of TRACKING table and triggers to check the status of the TRACKING table and the triggers. If they have been set up and do not have any problems, the following is displayed:
|
Checking use of TRACKING table: TRACKING table is enabled. Checking TRACKING table: TRACKING table OK. Checking size of TRACKING table: 42 entries found in TRACKING table. Earliest entry found: 2012-03-23 Most recent entry found: 2012-03-23 Checking triggers: Triggers are ok. |
If there are problems with the triggers, the following is displayed:
|
Checking triggers: Problem detected with triggers in following instance(s): sfxlcl41,sfxtst41. Triggers will need to be recreated. Please run step 2. |
Creating the Table and the Triggers
Select 2 Create table and triggers to create the table and triggers if they do not exist or to recreate them if problems have been detected. The following is displayed:
|
Checking existence of TRACKING table: TRACKING table exists. Do you wish to create / recreate triggers? [Y/n]y |
Type y to create the triggers. This process does not change the TRACKING table and can be performed without causing any harm to SFX-Verde publishing.
Cleaning the TRACKING Table
Select 3 TRACKING table cleanup to clean up the TRACKING table. The following is displayed:
|
1 Clean TRACKING table 2 Schedule clean-up of TRACKING table 3 List scheduled tasks for clean-up of TRACKING table |
Select 1 Clean TRACKING table to clean the TRACKING table. The following is displayed:
|
Do you want to delete entries from TRACKING table which are no longer needed by programs using this data? [Y/n] |
Type y. The following is displayed:
|
/exlibris/sfx_ver/sfx4_1/tmp/tracking_table_archive/archive_TRACKING_TABLE_1.sql.gz created. Entries no longer needed are now removed. Removed 10334 entries. |
An archive file with the old data from the TRACKING table is stored in the /exlibris/sfx_ver/sfx4_1/tmp/tracking_table_archive/ directory, and the archived data is removed from the TRACKING table.
Data is archived if it is older than 6 months. Data not published to Verde as part of the SFX-Verde publishing process is not archived.
