Contents
- Introduction
- Input Port
- Properties: General Tab
- Properties: Operator Properties Tab
- Properties: Container Tab
- Properties: Get and Set Info Tab
- Properties: Free Form Tab
- Properties: Dynamic Variable Tab
- Properties: Operator Property Tab
- Properties: List Tab
- Properties: JDBC Tab
- Properties: Starting and Stopping Tab
- Properties: Concurrency Tab
- Related Topics
This topic explains how to use the TIBCO StreamBase Admin operator and describes the configuration settings you can make in the operator's Properties view.
The StreamBase Admin operator is a global Java operator that provides a way to run sbadmin subcommands as a Java process without opening a shell command prompt. This feature is especially useful in StreamBase high availability design patterns, where an application in one container might need to send an sbadmin subcommand to an application in another container or on another StreamBase Server.
Configure the operator to send a single sbadmin subcommand to a single target server or container. Once configured, the operator's subcommand is sent on receipt of a tuple with any schema on the operator's input port. To send more than one sbadmin subcommand, use more than one instance of the operator in your application.
Specify the subcommand to run using the Command field of the Operator Properties tab. The subcommand you select may require arguments or parameters. If so, enter those on other tabs of the Properties view. Fields in other tabs are dimmed and unavailable unless they are relevant to the subcommand selected in the Command field.
Select the StreamBase Admin operator from the Insert an Operator or Adapter dialog, which you invoke with one of the following methods:
-
Drag the Adapters, Java Operators token from the Operators and Adapters drawer of the Palette view to the canvas.
-
Click in the canvas where you want to place the operator, and invoke the keyboard shortcut
O V -
From the top-level menu, invoke → → .
From the Insert an Operator or Adapter dialog that opens, select StreamBase Admin and double-click or press OK.
By default, the StreamBase Admin operator has one input port that accepts a tuple with any schema. The operator runs its configured command on the receipt of a tuple, not based on the contents of the tuple.
You can also add an optional Error Output port, which outputs a StreamBase error tuple for any error thrown by the operator, as described in General Tab.
This section describes the properties on the General tab in the Properties view for the External Process operator.
Name: Use this field to specify or change the component's name, which must be unique in the application. The name must contain only alphabetic characters, numbers, and underscores, and no hyphens or other special characters. The first character must be alphabetic or an underscore.
Operator: A read-only field that shows the formal name of the operator.
Class: A field that shows the fully qualified class name that implements the functionality of this operator. Use this class name when loading the operator in StreamSQL programs with the APPLY JAVA statement. You can right-click this field and select Copy from the context menu to place the full class name in the system clipboard.
Start with application: If this field is set to Yes or to a module parameter that evaluates to true, an instance of this operator starts as part of the containing StreamBase Server. If this field is set to No or to a module parameter that evaluates to false, the adapter is loaded with the server, but does not start until you send an sbadmin resume command, or until you start the component with StreamBase Manager. With this option set to No or false, the operator does not start even if the application as a whole is suspended and later resumed. The recommended setting is selected by default.
Enable Error Output Port: Select this check box to add an Error Port to this component. In the EventFlow canvas, the Error Port shows as a red output port, always the last port for the component. See Using Error Ports and Error Streams to learn about Error Ports.
Description: Optionally enter text to briefly describe the component's purpose and function. In the EventFlow canvas, you can see the description by pressing Ctrl while the component's tooltip is displayed.
This section describes the properties on the Operator Properties tab in the Properties view for the StreamBase Admin operator.
- Command
-
This field is central to the operation of the operator. Use the drop-down list in the Command field to select the exact sbadmin subcommand to send with this instance of the operator. The available subcommands are:
Add Container
Add Deploy
Describe
Free Form
Get Dynamic Variable
Get Leadership
Get Operator Status for Container
List Connections
List
Kill Connection
Manage Jdbc Connections
Modify Container
Remove Container
Restart Operator
Restart Container
Resume
Set Dynamic Variable
Set Leadership
Shutdown Server
Shutdown Operator
Status
SuspendAll commands except
Free Formcorrespond to an sbadmin subcommand, as documented on the sbadmin reference page. TheFree Formcommand lets you type a subcommand with custom arguments for custom uses.Once you select an sbadmin subcommand with the Command field, you may need to provide further information on one of the other tabs of the Properties view. See the sbadmin reference page for details on the required and optional arguments and parameters for your selected subcommand.
- Remote server
-
By default, this operator sends its command to the same StreamBase Server instance that is hosting and running this operator. Select this check box to send the command to any other server instance, including to another server running on a different port on the same machine.
- Server URI
-
If you selected the Remote server check box, enter a StreamBase URI in this field in the form of an expression. See sburi for the format of a StreamBase URI.
- Username
-
If you did not select the Remote server check box and the StreamBase server is running with authentication enabled, enter a user name in this field in the form of an expression. A username and password is never required when running locally.
Note
This property is deprecated and will be removed in a future release. For remote servers running under authentication, specify the username as part of the Server URI.
- Password
-
If you did not select the Remote server check box and StreamBase Server is running with authentication enabled, enter a password in this field in the form of an expression. A username and password is never required when running locally.
Note
This property is deprecated and will be removed in a future release. For remote servers running under authentication, specify the password as part of the Server URI.
- Number of async worker threads
-
The default value of 1 means that the operator's commands are performed serially. This is ideal behavior when using the operator to perform commands that must be run in sequence, such as
Add Container, thenModify Container. Positive values specify a limit on the number of threads to spawn to perform the operator's requested operations. Negative or 0 means the operator spawns an unlimited number of threads. - Enable Status Port
-
The status port can be enabled to allow the operator to output status tuples to give the user more information during processing. Status tuples for this operator will be emitted for errors and rejections of input tuples. A rejection status tuple will be emitted if there is a validation problem on the input tuple. A error status tuple will be emitted if there is an error during processing.
- Log Level
-
Controls the level of verbosity the adapter uses to issue informational traces to the console. This setting is independent of the containing application's overall log level. Available values, in increasing order of verbosity, are: OFF, ERROR, WARN, INFO, DEBUG, TRACE, and ALL.
This section describes the properties on the Container tab in the Properties view for the StreamBase Admin operator. First select the sbadmin subcommand to send using the Command field on the Operator Properties tab. If the subcommand affects containers or container operations, enter further subcommand arguments on this tab. Enter arguments in all fields in the form of a StreamBase expression, which usually means simply placing quotes around a string argument.
- Container Name
-
If your selected subcommand requires it, enter a container name to which the command is to be addressed.
- Container application file name
-
If your selected subcommand requires it, enter the path to an EventFlow or StreamSQL file to load into a container.
- Container options
-
If your selected subcommand requires it, enter further arguments or parameters for your container-related command. Enter the arguments as a list of strings like the following examples for adding a container:
-
Container name:
"A" -
Container application file name:
"mainprocess.sbapp" -
Container options:
list("--enqueue","DISABLED")
The equivalent sbadmin command for the second example would be:
sbadmin addContainer A mainprocess.sbapp --enqueue=DISABLEDFor descriptions of relevant options, see the commands section in the sbadmin documentation and find the subcommand you are invoking with the operator.
-
This section describes the properties on the Get and Set Info tab in the Properties view for the StreamBase Admin operator. First select the sbadmin subcommand to send using the Command field on the Operator Properties tab. If the subcommand affects a get or set info or leadership operation, then enter further subcommand arguments on this tab. Enter arguments in the fields in the form of a StreamBase expression, which usually means simply placing quotes around a string argument.
- Deploy File
-
If your selected subcommand requires it, enter the deploy file to use.
- Feature Name
-
If your selected subcommand requires it, enter feature name.
- Name
-
If your selected subcommand requires it, enter the StreamBase URI for a server instance.
- Connection Id
-
If your selected subcommand is
Kill Connections, enter the Id of the connection to kill. - Leadership
-
If your selected subcommand is
Set Leadership, enter either LEADER or NON-LEADER.
This section describes the properties on the Free Form tab in the Properties view for the StreamBase Admin operator. First select Free Form in the Command field on the Operator Properties tab. Then enter the sbadmin subcommand in the Command field and its arguments in the Command line parameters field. Provide arguments in the form of
a list of quoted strings containing subcommand options and StreamBase expressions.
- Command
-
Commands are case-sensitive and must be surrounded with quotes. Enter them exactly as they appear in the Operator Properties drop-down menu. This string can differ from the actual sbadmin command name. For example, you would enter
Modify Container, notmodifyContainer. - Command line parameters
-
Enter parameters to provide to the indicated sbadmin command. For example, to execute an
Add ContainerCommand, enter the following:-
Command:
"Add Container" -
Command line parameters:
"A mainprocess.sbapp --enqueue=DISABLED"
Parameters should also be entered as a single quoted string, not the list of strings that the Container tab's Container Options requires.
The equivalent sbadmin command for the second example would be:
sbadmin addContainer A mainprocess.sbapp --enqueue=DISABLEDVerbose mode is always enabled when the sbadmin command is called from this operator.
The sbadmin subcommand readTable is not supported.
-
This section describes the properties on the Dynamic Variable tab in the Properties view for the StreamBase Admin operator. First select Get/Set Dynamic Variable in the Command field on the Operator Properties tab. Then type the full sbadmin subcommand and its arguments in the fields of this tab. Enter arguments in both fields in the form of a StreamBase expression,
which usually means simply placing quotes around a string argument.
- Variable Path
-
Enter the full path of the dynamic variable.
- Variable Value
-
Enter the value used when performing a set operation.
This section describes the properties on the Operator Property tab in the Properties view for the StreamBase Admin operator. First select Get/Set Operator Property in the Command field on the Operator Properties tab. Then type the full sbadmin subcommand and its arguments in the fields of this tab. Enter arguments in both fields in the form of a StreamBase expression,
which usually means simply placing quotes around a string argument.
- Operator Name
-
Enter the operator name.
- Operator Property Name
-
Enter the name of the property for the operator.
- Operator Property Value
-
Enter the value used when performing a set operation.
This section describes the properties on the List tab in the Properties view for the StreamBase Admin operator. First select the List command using the Command field on the Operator Properties tab. Enter arguments in the fields in the form of a StreamBase expression, which usually means simply placing quotes around a string argument.
- Connection Type
-
If your selected subcommand is
List Connections, enter either current, old, all, or clearOld. - Entity Type
-
The entity type to list. May be schema, stream, output-stream, input-stream, box, operator, table, tableconcrete, window, windows, window-spec, window-specs, container-connection.
- Fully Qualified Names
-
Include the container name in the entity name.
- Include Modules
-
Include all sub-modules.
- Container
-
The container to list entities for. If not specified, the
defaultcontainer is used.
This section describes the properties on the List tab in the Properties view for the StreamBase Admin operator. First select the Manage JDBC Connections command using the Command field on the Operator Properties tab. Enter arguments in the fields in the form of a StreamBase expression, which usually means simply placing quotes around a string argument.
- JDBC Action
-
The type of action to perform on the connection: close, count.
- JDBC Data Source
-
The data source to perform the action on.
This section describes the properties on the Starting and Stopping tab in the Properties view for the StreamBase Admin operator. First select the sbadmin subcommand to send using the Command field on the Operator Properties tab. If the subcommand affects starting or stopping a server or container, enter further subcommand arguments on this tab. Enter any arguments in the form of a StreamBase expression, which usually means simply placing quotes around a string argument.
- Name
-
Enter a StreamBase URI of a server or container instance to start, pause, resume, or shutdown.
Use the Concurrency tab to specify parallel regions for this instance of this component, or multiplicity options, or both. The Concurrency tab settings are described in Concurrency Options, and dispatch styles are described in Dispatch Styles.
Caution
Concurrency settings are not suitable for every application, and using these settings requires a thorough analysis of your application. For details, see Execution Order and Concurrency, which includes important guidelines for using the concurrency options.