• 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