> Expert > CommCell Management > Tools and Utilities for Troubleshooting

Automatic Healing of the Temporary Database on the CommServe Computer

The temporary database stores temporary user objects and internal objects that are created by the database engine on the Commserve computer or any device where the CommServe database is stored. The temporary database is located on the disk or network storage of the CommServe computer.

The automatic healing feature deletes the temporary objects stored in the temporary database on the CommServe computer. The following functions are configured by default for the automatic healing of the temporary database:

  • The automatic healing process starts when 85 percent of the disk space and 30 percent of the temporary database is utilized.

  • When an error occurs and dump files are generated, the process dump files and sub-process dump files consuming the temporary database are deleted based on the ProcessID and SPID.

  • The dump and the log files with the prefix ‘AHT’ that are generated during the automatic healing of the temporary database are deleted after 7 days.

    The dump and log files are stored in the log directory which is located in the following path:
    C:\Program Files\Commvault\ContentStore\Log Files

    Note

    • The log files are saved in the log directory located with "AHT_Log_ ProcessName_timeStamp.7z" format in a compressed zip-file (.7z).

    • The process dump files are saved in the log directory with "AHT_Dump_ProcessName _UniqueTimestampDay_Freq.dmp" format.

  • The automatic healing of temporary database takes place 15 minutes after restarting the CVD process.

  • For each process that terminates unexpectedly, dump files are created in the temporary database only 5 times per day. When the limit is reached, the alert is sent to the user through email.

  • When an error occurred during the execution of the stored procedure, an error message appears that says "Cannot execute stored procedure - APP_DetectHighTempDBUsageSPID".

  • When the automatic healing process is completed, the alerts will be sent to the user through email.

By default, the automatic healing feature is enabled on the CommServe computer. If you want to disable this feature on the CommServe computer, in the Command Center or CommCell Console, set the value of bAHTAutoTempDbCorrection additional setting to false.

Loading...