Skip to end of metadata
Go to start of metadata

Purpose

SAP IQ server starts with a configration parameters usually written in cfg file. Some of them are dynamic. This page explores those parameters and explains how to dynamically change them.

Overview

Restarting IQ server requires a downtime which is critical in most production environments.Hence, it interesting to know IQ dynamic parameters and how to change them in DBA Sql session when it is required..

For example, enable/disable srvlog debugging mode, enable/disable Sql logging, change server idle timeout, etc.

 

Dynamic parameters and online setting

Parameters below are dynamic and can be changed live using system procedure sa_server_option.

Syntax.

call sa_server_option('parameter_name', 'value');

In Table hereafter a list of  start_iq parameters and their corresponding sa_server_option parameters:

Start_iq parametersa_server_option parameterValuesDefault
-csCacheSizingStatisticsYES, NOYES
-tiIdleTimeout

Integer (minutes)

240
-tlLivenessTimeoutInteger (seconds)120
-iqmsgszIQMsgMaxSize 0-2047 (MB)0 (no limit)
-iqmsgnumIQMsgNumFiles0 – 640
-oConsoleLogFile filenamesrvlog file located in logfiles
-onConsoleLogMaxSizefile-size (bytes)0 (no limit)
-zDebuggingInformationYES, NONO
 -zr RequestLogging

SQL, HOSTVARS, PLAN, PROCEDURES, TRIGGERS,

OTHER, BLOCKS, REPLACE, ALL, YES, NONE 

 NONE
 -zo RequestLogFile Filename 
 -zs RequestLogMaxSize file-size (bytes) 0 (No limit)
 -zn RequestLogNumFiles Integer 1
 -sf SecureFeatures feature-list 
 -sksp_use_secure_feature_key  key
 -tq QuittingTime Valid date and time Disabled
 -gtcMinMultiProgrammingLevel IntegerDefault is the minimum of the value of the -gtc server option and                                     the number of logical CPUs on the computer.
 iqrlvmem rlv_memory_mb Ineteger (MB) 2048 MB

 

Display current setting

To display dynamic parameters setting, use "sa_eng_properties" system procedure or  "Property" system function.

Examples.

call sa_eng_properties;

Displays all server properties, including dynamic parameters mentioned above.

 

Display one parameter (called also engine property)

Select Property(<property_name>) ;

Property_Name : any dynamic parameter mentioned above or any other server property like MachineName, TempDir, etc.

 

Select Property('RequestLogging');

Result.

NONE

Select Property('IdleTimeout') ;

Result.

4400

 

Examples

1- Check if Server request logging -(-zr server option) is enabled and dynamically enable it if not intially enabled or change the logging level:

 

  • Check first if the tracing is enabled, and see the related trace file 
     select property('RequestLogging');
    select property('RequestLogFile') ;


  • Speciffy request logging output file name
    CALL sa_server_option( 'RequestLogFile', ‘file_name_zr.out’ );

 

  • Specify SQL logging level
    CALL sa_server_option('RequestLogging', 'SQL' );
  • Specify Full SQL logging 
    CALL sa_server_option( 'RequestLogging', ‘ALL' );


  • Disable Request logging
    CALL dbo.sa_server_option('RequestLogging', 'NONE') ; 
 
 2- Check current value of Idle TimeOut (-ti start_server option) and change it :
  • Display Current value 
    Select property('IdleTimeout');  

 
 

  • Change value to 10 minutes
    Call sa_server_option('IdleTimeout', ‘10' );

 

Related Documents

Sa_server_option System Procedure

Start_iq options

Sa_eng_properties system procedure

 

 

 

 

  • No labels