Database SCON logging - reduce logging — NetBackup IT Analytics 11.8

Database SCON logging - reduce logging

To minimize output to the scon.log file, you can prune the content using this procedure:

Log into the database server and switch to aptare user.
Edit the config.sql file.
Linux: /opt/aptare/database/stored_procedures/config.sql
Windows: C:\opt\oracle\database\stored_procedures\config.sql

Change the output setting to LOW, as shown in BOLD in the following example.

set Echo     Off
set Feedback OffCREATE OR REPLACE PACKAGE config AS
    
    -- Valid APTARE StorageConsole Logging levels are as follows:
    -- constant.DEBUG_OFF
    -- constant.DEBUG_LOW
    -- constant.DEBUG_MEDIUM
    -- constant.DEBUG_HIGH    -- To change the global APTARE StorageConsole 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
   
   --UNCOMMENT BELOW TO ENABLE SCON.LOG writing. SAME parameter is available under System Configurations> Database Administration > Enable scon.log real time logging (minutes)
       --UPDATE apt_system_parameter SET param_value = 10 WHERE param_name = 'ENABLE_SCON_REAL_LOG_MINS'; COMMIT;
       
    -- The following directory will be used to store the APTARE StorageConsole
    -- 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' ;    
    
    -- Following parameters are used in datacoll_exec_tracking_pkg
    NO_OF_DC_SP_LOG_ROWS                CONSTANT NUMBER(5)    := 100;--Defines the number of Data Collection log rows. This log contains execution tracking.
    NO_OF_DC_QUERY_LOG_ROWS             CONSTANT NUMBER(5)    := 50;--Defines the number of rows for the Data Collection query log. This log contains execution tracking.
    DATACOLL_LOGGING_ENABLED            CONSTANT NUMBER(1)    := 1;--Enables/disables data persistance transaction logging during data collection. This logging helps to isolate collection performance issues. If collection performance is degraded, you can temporarily disable the process.
    
END config;
/
SHOW ERRORS;

Apply and validate new settings with the following utilities:

Linux:

sqlplus portal/<portal_password>@//localhost:1521/scdb@/opt/aptare/database/
stored_procedures/config.sql 
sqlplus portal/<portal_password>@//localhost:1521/scdb@/opt/aptare/database/tools/validate_sp

Windows:

sqlplus portal/<portal_password>@//localhost:1521/scdb@C:\opt\oracle\database\
stored_procedures\config.sql 
sqlplus portal/<portal_password>@//localhost:1521/scdb@C:\opt\oracle\database\tools\
validate_sp