TIBCO ActiveSpaces® Installation
Important Information
TIBCO Documentation and Support Services
About This Product
Terminology Used to Address the TIBCO FTL Realm
Product Overview
Preparing for Installation
Requirements
Guidelines for UNIX
Guidelines for Microsoft Windows
Installation
Installing on Windows
Installing in GUI Mode
Installing in Console Mode
PostInstallation Steps
Verifying the Installation on Windows
Installing on Mac
Installing in GUI Mode
Installing in Console Mode
PostInstallation Steps
Verifying the Installation on Mac
Installing on Linux
PostInstallation Steps
Verifying the Installation on Linux
Uninstallation
Uninstalling on Windows
Uninstalling on Mac
Uninstalling on Linux
Upgrading from an Earlier Version
TIBCO ActiveSpaces® Concepts
Important Information
TIBCO Documentation and Support Services
About This Product
Overview of TIBCO ActiveSpaces
Why ActiveSpaces?
What Is ActiveSpaces?
Benefits of ActiveSpaces
Attributes of ActiveSpaces
Redesigned from the Ground Up
Terminology Used to Address the TIBCO FTL Realm
Grid Computing in ActiveSpaces
What Is a Data Grid?
How Is the Data Stored in a Data Grid?
Replication
Processes in ActiveSpaces
The Workflow for a PUT Operation
Log Levels
Transaction Isolation
Checkpoints
Checkpoint Types
Disaster Recovery
Gridsets
Types of Data Grids
Mirroring
Best Practices for a Development Environment
Best Practices for a Production Environment
Programming with ActiveSpaces
Structuring Programs
Task A Initializing ActiveSpaces Objects
Task B Performing Date Grid Operations
Task C Cleaning up and Closing the Connection
Connection
Session
Table
PUT
GET
DELETE
Iterator
Table Listener
Filtering Events
Listening to Specific Event Types
Statement
Properties
Parameters
Executing Statements
ResultSet
Row Objects
ResultSet MetaData
SQL Identifiers
Column Data Types
tibDateTime
Querying a Data Grid Table
Table Iterator
Session Statement
Data Consistency for Queries
The SQL SELECT Statement
Unsupported SQL Features
The Syntax of the SELECT Statement
The FROM Clause
The Select List
Asterisk
Value Expression
Restrictions on Using a Value Expression
CASE Expressions used in the Select List
Case Expression Restrictions
Functions Used in The Select List
The WHERE Clause
Tips on Constructing an Efficient WHERE Clause
Operators Used in the WHERE Clause
Using Date and Time Functions in the WHERE Clause
Function Usage on Index Columns
WHERE Clause Examples
Querying tibDateTime Columns
Error Conditions
Using String Functions in the WHERE Clause
Using Multi-Argument MIN, MAX Functions in the WHERE Clause
The GROUP BY Clause
The ORDER BY Clause
LIMIT Clause
Modifying Data in a Table
The SQL INSERT Statement
Adding Rows To a Table by Using the SQL INSERT Statement
Errors
INSERT Statement and Expressions
Parameter Binding with INSERT Statements
The INSERT OR REPLACE Statement
SQL Expressions
Operators
LIKE Operator
Negation
Compound Expressions
Order of Operations
CASE Expressions
SQL Functions
Aggregate Functions
Date and Time Functions
timevalue Format
Modifiers
Result Column Examples
SQL String Functions
The ActiveSpaces JDBC Driver
Connecting to the Data Grid by Using ActiveSpaces JDBC Driver
Setting up the Environment
Registering the ActiveSpaces JDBC Driver with the Driver Manager
Creating the ActiveSpaces JDBC Connection
JDBC URL Format
ActiveSpaces Connection Properties
Using the ActiveSpaces JDBC Driver With Third Party Tools
JDBC Implementation Notes
JDBC Data Types
DatabaseMetaData Pattern Parameters
ResultSetMetaData and Function Return Values
JDBC Compliance
Sizing Guide
Example of a Sizing Calculation
Comparison Matrix
TIBCO ActiveSpaces® Administration
Important Information
TIBCO Documentation and Support Services
About This Product
Who Should Read This Document
Administrative Concepts
Copysets
State Keeper
Realm Service
Terminology Used to Address the TIBCO FTL Realm
Development Environment
Production Environment
String Encoding
Starting a Realm Service
Administration Tool
Administration Tool Reference
Environment Variables for the Administration Tool
tibdg Status
tibdg Table Stats
tibdg Grid Generate and tibdg Table Generate
The tibdg Commands That Support Interaction
Using tibdg grid mode to Put a Data Grid into Maintenance Mode
tibdgadmind
Stop the tibdg Daemon
Designing a Data Grid
Defining a Data Grid
Grid Create Configuration Options
Memory Usage Considerations with the node_read_cache_size Option
Configuration Options to Use Specific Ports and Network Interfaces
Configure Ports
Configuration Options when the Proxy and Client are on Different Subnets
Configuring a Proxy That Can Be Accessed from Different Subnets
Configure Network Interfaces
Configure Internal Subnet Masks
Starting the Data Grid Processes
Component Command-Line Parameters
Starting a State Keeper
Keeper Reference
Starting a Node
Node Reference
Starting Multiple Nodes
three_copysets.tibdg
one_copyset_two_replicas.tibdg
Starting a Proxy
Proxy Reference
Starting a Proxy with an External Host and Port
Methods of Selecting a Proxy for a Client
Adding Copysets
Data Redistribution
Defining a Table
Column Names
Special Characters in Column Names
Secondary Indexes
Enabling Statistics
Row Expiration
Defining a Table with Row Expiration
Overriding the Default TTL for a Single Row
Deletion of Expired Rows
Defining a Table by Using SQL DDL Commands
Creating a New Table
Dropping a Table
Creating an Index
Dropping an Index
SQL Data Type Mapping
Security
Enabling Transport Encryption on a Data Grid
Trust File
Using Trust Files with Primary Realm Service
Using Trust Files with the Disaster Recovery Feature
Authentication and Authorization
Authorization Groups
Password File
Starting Realm Services with Authentication
Starting Data Grid Processes With Authentication
Grid and Table Permissions
Enabling Permission Checking on Data Grids and Tables
ActiveSpaces Custom Roles
Enabling Permission Checking when Creating or Modifying a Data Grid
The tibdg Commands to Set Permissions on a Table
Granting Permission To a User or a Role
Revoking Permission from a User or a Role
ActiveSpaces Monitoring Service
Using ActiveSpaces Monitoring Service
Installing or Uninstalling ActiveSpaces Processes as Windows Services
Deployment Scenario for Running ActiveSpaces Processes as Windows Services
Preparing for Installation
Installing TIBCO FTL Server as a Windows Service
Creating the ActiveSpaces Data Grid
Installing the ActiveSpaces State Keeper as a Windows Service
Installing the ActiveSpaces Node as a Windows Service
Installing the ActiveSpaces Proxy as a Windows Service
Installing the ActiveSpaces tibdgadmind as a Windows Service
Running an ActiveSpaces Sample
Uninstalling the Sample Windows Services
Stopping a Data Grid Gracefully
Selecting a Secondary Node to be Promoted as the Primary Node
Clearing a Data Grid Definition
Checkpoints
Creating a Checkpoint
Creating a Manual Checkpoint
Creating a Periodic Checkpoint
Listing Checkpoints
Listing Tables in a Checkpoint
Deleting Checkpoints
Automatically Deleting Old Checkpoints
Validating Checkpoints
Checkpoint Properties
Checkpoint Best Practices
Live Backup and Restore
Restoring a Data Grid
Realm Service Database Restore
Realm Service Checkpoint Restore
Restoring State Keepers
Restoring a tibdg Node
Disaster Recovery
Suggested Deployment Model for Disaster Recovery
A Quick Look at Setting Up Disaster Recovery
Gridset Configuration
Getting Help on the gridset Command
Creating a Gridset
Adding Data Grids to a Gridset
Modifying a Gridset
Configuring a Proxy with Static Mirroring Host and Port
Activating the Mirror Grid as the Primary Grid
Preventing Data Loss by Using the Maintenance Mode
Retention Limits
Automatic Mirroring
Recovery Objectives
Recovery Point Objective
Recovery Time Objective
Capacity and Sizing
Disk Space Used by the Checkpoint Metadata
Query Capacity
Security in a Disaster Recovery Setup
Disaster Recovery Playbook
Setting Up a Planned Cutover to a Mirror Grid
Disaster Recovery at a Mirror Grid
Multiple Mirror Sites
Read Replicas
TIBCO ActiveSpaces® Security
Important Information
TIBCO Documentation and Support Services
About This Product
Product Overview and Security Features
Product Connectivity
Setting up a Secure TIBCO FTL Server
Setting up a Secure Data Grid
Securing Client-to-Proxy Communication
Transport Encryption on a Data Grid
Authentication and Authorization
Permissions
Commands to Start a Secure Data Grid
Initial Setup to Start a Secure Data Grid
Create Directories Needed to Run the Processes
Setting Up and Starting TIBCO FTL Servers
Starting ActiveSpaces Processes
TIBCO ActiveSpaces® API Reference
Important Information
TIBCO Documentation and Support Services
About This Product
API Documentation for TIBCO ActiveSpaces® 4.4