Configure System Parameters > Manage Data Persistence System Logging
  
Version 10.1.00
Manage Data Persistence System Logging
Beginning with APTARE StorageConsole 10, a system-wide process logs data persistence transactions during data collection. This logging process captures elapsed time to help you isolate data collection performance issues. By default, system-wide logging is enabled.
When to Disable Data Persistence Logging
If you suspect that performance has degraded during a data collection cycle, it could also be due to the overhead imposed by the logging process itself. Although logging is essential for pinpointing the collection issue, it may be necessary to temporarily disable the process to determine the source of the problem.
1. View the aptare-trans.log file, where long-running logging process transactions are logged.
C:\tmp\aptare-trans.log
/tmp/aptare-trans.log
2. If aptare-trans.log contains frequent activity with long elapsed time values, disable system-wide logging to see if this makes a difference. See Enable/Disable Data Persistence System Logging.
Enable/Disable Data Persistence System Logging
Use the following procedure to configure a system parameter to enable or disable data persistence logging.
1. Log in to the Portal Server as user aptare.
2. Type the following command:
sqlplus portal/<portal_password>
3. To disable logging, set the system parameter to 0:
 
UPDATE ptl_system_parameter set param_value=0 WHERE param_name='DATACOLL_LOGGING_ENABLED';
commit;
 
4. To enable logging, set the system parameter to 1:
 
UPDATE ptl_system_parameter set param_value=1 WHERE param_name='DATACOLL_LOGGING_ENABLED';
commit;