Working with Log Files > Database SCON Logging - Reduce Logging
  
Version 10.0.01
Database SCON Logging - Reduce Logging
To minimize output to the scon.log file, you can prune the content using this procedure:
1. Edit the config.sql file.
Linux: /opt/aptare/database/stored_procedures/config.sql
Windows: C:\opt\oracle\database\stored_procedures\config.sql
2. Change the output setting to LOW, as shown in red in the following example.
set Echo Off
set Feedback Off
 
CREATE OR REPLACE PACKAGE config AS
-- Valid Hitachi Storage Viewer Logging levels are as follows:
-- constant.DEBUG_OFF
-- constant.DEBUG_LOW
-- constant.DEBUG_MEDIUM
-- constant.DEBUG_HIGH
 
-- To change the global Hitachi Storage Viewer logging level, change the following constant
globalDebugLevel PLS_INTEGER := constant.DEBUG_LOW;
 
reportTransLongerThan FLOAT := 0.85; -- Transactions that take longer than this number of seconds will be reported in aptare-trans.log
-- The following directory will be used to store the Hitachi Storage Viewer
-- database logfiles scon.log and scon.err. On a Windows portal server,
-- this will default to C:\opt\oracle\logs
LOGDIRECTORY CONSTANT VARCHAR2(64) := '/tmp' ;
END config;
/
SHOW ERRORS;
3. Apply and validate new settings with the following utilities:
Linux:
sqlplus portal/<portal_password>@/opt/aptare/database/stored_procedures/config.sql
sqlplus portal/<portal_password>@/opt/aptare/database/tools/validate_sp
Windows:
sqlplus portal/<portal_password>@C:\opt\oracle\database\stored_procedures\config.sql
sqlplus portal/<portal_password>@C:\opt\oracle\database\tools\validate_sp