ml_add_property system procedure

Use this system procedure to add or delete MobiLink properties. This system procedure changes rows in the ml_property system table.

Syntax

ml_add_property ( 
'comp_name', 
'prop_set_name', 
'prop_name', 
'prop_value'
)

Parameters

Syntax	Description
comp_name	VARCHAR(128). The component name. To save properties by script version, set to ScriptVersion. For MobiLink server properties, set to MLS. For server-initiated synchronization properties, set to SIS.
prop_set_name	VARCHAR(128). The property set name. If the component name is ScriptVersion, then this parameter is the name of the script version. If the component name is MLS, then this parameter can be either ml_user_log_verbosity to specify verbosity for a MobiLink user, or ml_remote_id_log_verbosity to specify verbosity for a remote ID. If the component name is SIS, then this parameter is the name of the Notifier, gateway, or carrier that you are setting a property for.
prop_name	VARCHAR(128). The property name. If the component name is ScriptVersion, then this parameter is a property that you define. You can reference these properties using DBConnectionContext: getVersion and getProperties, or ServerContext: getPropertiesByVersion, getProperties, and getPropertySetNames. If the component name is MLS, then this property is either a MobiLink user name or remote ID that you define.
prop_value	TEXT. The property value. If the prop_set_name is ml_user_log_verbosity or ml_remote_id_log_verbosity, this must be a valid mlsrv -v option. For Adaptive Server Enterprise, this parameter is VARCHAR(16384). For DB2 LUW, this parameter is VARCHAR(4000). For Oracle, this parameter is CLOB. To delete a property, set to null.

Log verbosity for targeted MobiLink users and remote IDs

The MobiLink server can be set to use different log verbosity for a targeted MobiLink user or remote ID. The MobiLink server checks the ml_property table every five minutes and looks for verbose settings for a MobiLink user or remote ID. If verbose settings exist, then it uses the new setting to log output messages for the given MobiLink user or remote ID. This enables you to see the details for a specific user or remote ID without the need for high verbosity settings that would negatively impact the server farm, and without requiring a restart of each server in the farm.

To set maximum verbosity for a targeted MobiLink user, for example ml_user1, log into the consolidated database and issue the following SQL command:

call ml_add_property( 'MLS', 'ml_user_log_verbosity', 'ml_user1', '-v+' )

To set maximum verbosity for a targeted remote ID, for example rid_1, log into the consolidated database and issue the following SQL command:

call ml_add_property( 'MLS', 'ml_remote_id_log_versity', 'rid_1', '-v+' )

Note that verbose_setting must be a valid MobiLink server -v option. For example, to log row data and undefined table scripts, the verbose_setting can be -vru or vru. The MobiLink server will use this verbose setting for ml_user1 or rid_1 after 5 minutes. See -v option.

To disable log verbosity for a MobiLink user, log into the consolidated database and issue the following SQL command:

call ml_add_property( 'MLS', 'ml_user_log_verbosity', 'ml_user', NULL )

To disable log verbosity for a MobiLink remote ID, log into the consolidated database and issue the following SQL command:

call ml_add_property( 'MLS', 'ml_remote_id_log_verbosity', 'rid_1', NULL )

The MobiLink server stops using the previous verbose setting for ml_user or rid_1 after five minutes.

If both the ml_user_log_verbosity and ml_remote_id_log_verbosity are set for a given MobiLink user and remote ID, and if the MobiLink user name and remote ID in a synchronization are identical to the given targeted MobiLink user and remote ID, the MobiLink server will use the ml_remote_id_log_verbosity setting to log output messages.

Server-initiated synchronization

For server-initiated synchronization, the ml_add_property system procedure allows you to set properties for Notifiers, gateways, and carriers.

For example, to add the property server=mailserver1 for an SMTP gateway called x:

ml_add_property( 'SIS','SMTP(x)','server','mailserver1' );

The verbosity property applies to all Notifiers and gateways, and so you cannot specify a particular property set name. To change the verbosity setting, leave the property set name blank:

ml_add_property( 'SIS','','verbosity',2 );

Script Version

For regular MobiLink synchronization, you can use this system procedure to associate properties with a script version. In this case, set the component_name to ScriptVersion. You can specify any properties, and use Java and .NET classes to access them.

For example, to associate an LDAP server with a script version called MyVersion:

ml_add_property( 'ScriptVersion','MyVersion','ldap-server','MyServer' )