CALL sr_add_message_server( 'owner' );

None. An error is returned if there are issues creating the objects required to define the message server.

When a database is first initialized, none of the web services needed to accept HTTP requests from remote users is defined, and neither are definitions to allow the database server to access the directory where the message files are stored. The creation of these objects is automated with the use of the sr_add_message_server stored procedure, which takes an optional parameter to specify who owns all the objects. Object names cannot be duplicated.

• sr_drop_message_server system procedure
• sr_update_message_server system procedure

The following statements cause the message server database (msgsrv) to define all the objects needed for the message server, and specify that all the objects are owned by the cons user (the consolidated database in this instance).

CREATE ROLE FOR USER cons;
SET REMOTE http OPTION cons.root_directory='c:\\tutorial\\messages';
CALL sr_add_message_server( 'cons' );
COMMIT;