Recovering System When ETM® Database Computer Runs Out of Storage.

Article #ETM824

Synopsis

If your ETM^® Database computer hard drive becomes full, the ETM Server cannot run. You will need to either provide additional storage space or clear some space on the hard drive so that you can restart the ETM Service.

More Information

By default, the ETM Server permanently stores log data; the only size limit is the amount of disk space available. However, you can allow the ETM System to automatically delete old logs according to storage size limits that you specify. For the procedure, see “Enabling Automatic Purging of Logs” in the Using the ETM^® System User Guide or online Help.

Note: If you are unable to start the Server, you will have to clear space on the hard drive first, as described below. Then you can log in to the Server and configure automatic purging.

Clearing Space on the Hard Drive

Removing old Diagnostic Logs should give the ETM System enough storage space to run. You can delete Diagnostic Logs without affecting the performance of the ETM System.

WARNING Clearing a table permanently deletes the data in the table.

To clear the Diagnostic Log table

• Do one of the following:
  • Connect to the database using the ETM Database Maintenance Tool.
    • Right click the Diagnostics table, then click Clear table.
  • If you do not have access to the ETM Database Maintenance Tool but have access to the ETM Database, you can follow the following instructions to clear the Diagnostics table:
    1. Log in to SQL*Plus using the ETM System database user/password combination. For example:c:>sqlplus etmuser/etmpass@etm_database_name
    2. At the SQL> prompt, type:
       truncate table diagnostics;The message table truncated appears.

Either of these methods should clear enough space on the hard drive to start the ETM Management Service. You can then log in to the Server and set up automatic purging.

Versions Affected

ETM^® System v4.0 and later.

Last Updated

3/1/2004

SecureLogix Corporation • 13750 San Pedro, Suite 230 • San Antonio, Texas 78232 • (210) 402-9669 • www.securelogix.com

Support (877) SLC-4HELP • EMAIL support@securelogix.com • http://support.securelogix.com

ETM, SecureLogix, SecureLogix Corporation, TeleWatch Secure, TWSA, the ETM Emblem, the SecureLogix Diamond Emblem, and the ETM Application Suite Emblems are trademarks or registered trademarks of SecureLogix Corporation in the U.S.A. and other countries. All other trademarks mentioned herein are believed to be trademarks of their respective owners.

© Copyright 2004 SecureLogix Corporation. All Rights Reserved.

U.S. Patents No. US 6,249,575 B1, US 6,320,948 B1, US 6,542,592 B1, US 6,687,353 B1, and US 6,700,964 B1.

U.S. and Foreign Patents Pending.