Dropping temporary tables

You can drop all data from your temporary tables and indexes that hold data because a job process failed to complete. Run the following scripts weekly or whenever you have planned maintenance or downtime.

Dropping temporary aggregate tables and indexes

You can drop all of your temporary aggregate tables and indexes of your import and update jobs to restore storage space and speed-up database utilities. The drop_temp_agg_tables.pl is a bash shell script that starts CLI and SQL for DB2®, or SQLPLUS for Oracle, for the respective backend databases.

Run the drop_temp_agg_tables.pl script that is in the $TOP/src/db/schema/util folder:
```
$TOP/src/db/schema/util/drop_temp_agg_tables.pl
```

Dropping temporary user log tables

You can drop all of your temporary tables that start with TCTG_ULE_USER_LOG_ENTRY and associated temporary sequences in your database to restore storage space and speed-up database utilities. The drop_log_tables_seq.pl is a bash shell script that starts CLI and SQL for Db2, or SQLPLUS for Oracle, for the respective backend databases.

Important: If you use User-Defined Logs in business logic or for auditing, do not run this script. Starting this script deletes all User-Defined Logs entries.

Run the drop_log_tables_seq.pl script that is in the $TOP/src/db/schema folder:
```
$TOP/src/db/schema/drop_log_tables_seq.pl
```