# config system global2) Disable SQL and remove the current database (prior 6.2).
set log-mode collector
# config system sql
set status disable
# execute sql-local remove-db <----- This command does not exist after 220.127.116.11) Re-enable SQL (prior 6.2).
# config system sql4) Change operation mode back to analyzer (prior 6.2).
set status local
# config system global5) Rebuild database.
set log-mode analyzer
# exec sql-local rebuild-db6) Set the following value to rebuild the database with logs from the expected date (this depend on how much Analytics days configured for this ADOM)
# config system sql7) Rebuild database.
set start-time <for ex:00:00 2021/06/01>
# execute sql-local rebuild-db <----- Require restart.Or
# execute sql-local rebuild-adom adomName <----- Does not require a restart.
# diag test app sqllogd 4 <----- This will let know which file the rebuilding process is handling at present , it is necessary to run it multiple time to check SQL rebuild status.
# diag sql show db-size <----- This will show if the DB size increases, if it is run it multiple times a few minutes apart.
# diag sql process list <----- It is possible sometimes to see a process here with commands like 'Create table'. 'Insert' or mentioning filenames;
# exe tac report
# exe top <----- Let it run for 5 min.