rs_session_setting

Sets Sybase IQ parameters and database options for the duration of the connection to the Sybase IQ replicate database.

Examples

  • Example 1 – Create the rs_session_setting function string for the my_iq_fclass function-string class, and include the Sybase IQ parameters you want to set such as, the LOAD_MEMORY_MB, MINIMIZE_STORAGE, and JOIN_PREFERENCE Sybase IQ database options:
    create function string rs_session_setting
for my_iq_fclass
output language
'set temporary option Load_Memory_MB=''200''
set temporary option Minimize_Storage=''on''
set temporary option join_preference=5'
go

Usage

  • The values for the Sybase IQ database options are set with the TEMPORARY keyword and therefore, apply only to the current Sybase IQ connection. The values revert to the default values or the values set earlier without the TEMPORARY keyword, when the connection to the Sybase IQ database is restarted. See Sybase IQ 15.2 > Reference: Statements and Options > Database Options > Introduction to Database Options > Setting Options.

  • rs_session_setting has function-string class scope.

  • Replication Server creates an initial rs_session_setting function string for the system-provided function-string classes during installation.

  • Create or customize an rs_session_setting function string at the Replication Server that is the primary site for the class.

  • The default generated function string for the rs_session_setting function for the:
    • rs_sqlserver_function_class and rs_default_function_class classes is an empty string
    • rs_iq_function_class class is: 
      {set temporary option Load_Memory_MB=''200'' 
set temporary option Minimize_Storage=''on''
set temporary option join_preference=5}
  • The LOAD_MEMORY_MB database option is deprecated in Sybase 15.2 and later. See Sybase IQ 15.2 > New Features Summary > Behavior Changes > Database Option Changes.
Parent topic: Replication Server System Functions