1.1.1

This procedure enables or disables a specific trace flag for the distributed system as a whole. You must be a
system user to execute this procedure. See Using Trace Flags for Advanced Debugging on page 262 for a
description of some commonly-used trace flags.
Syntax
SYS.SET_TRACE_FLAG (
IN TRACE_FLAG VARCHAR(256),
IN ON BOOLEAN
)
TRACE_FLAG
Specifies name of the trace flag to enable or disable.
ON
Specifies boolean value: "true" to enable the trace flag, or "false" to disable it.
Example
This command traces all JAR installation, update, and removal operations in the SQLFire
distributed system:
call sys.set_trace_flag ('TraceJars', 'true');
SYS.SHOW_USERS
Displays a list of all BUILTIN users that are configured in the system.
This procedure displays the BUILTIN users that you have configured in the distributed system. See Creating
Users for BUILTIN Authentication on page 243.
Syntax
SYS.SHOW_USERS ()
SYS.START_GATEWAYSENDER
Start a configured gateway sender process.
Syntax
SYS.START_GATEWAYSENDER(
IN GATEWAYSENDER_ID VARCHAR(128) NOT NULL)
GATEWAYSENDER_ID
The name of the gateway sender to start. This attribute cannot be null.
Note: You must specify the gateway sender name in all uppercase letters. Use
single quotes to specify the sender name when you call the procedure from an
interactive sqlf session.
Example
This command starts all primary and secondary senders with the name cluster-1-sender:
sqlf> call sys.start_gatewaysender ('CLUSTER-1-SENDER');
This example executes the procedure from a Java client:
java.sql.Connection conn = getConnection();
CallableStatement cs = conn.prepareCall("CALL
SYS.START_GATEWAYSENDER(?)");
vFabric SQLFire User's Guide622
vFabric SQLFire Reference