Category:Operations Guide
From InterBase
Pages in category "Operations Guide"
The following 200 pages are in this category, out of 265 total.
(previous page) (next page)A
- About InterBase 6 and Later, Dialect 1 Databases
- About InterBase backup and restore options
- About InterBase SuperServer Architecture
- About Journals, Journal Files, and Journal Archives
- About NUMERIC and DECIMAL Data Types
- Accessing Local Databases
- Accessing Remote Databases
- Activating a Shadow
- Adding a Database
- Adding a Server
- Adding a Shadow File
- Adding and Subtracting Datetime Data Types
- Adding Comments in an isql Script
- Advantages of Shadowing
- Application Design Techniques
- Application Development Tools
- Auto Mode and Manual Mode
- Automatic Rerouting of Databases
C
- Casting Date/time Data Types
- Choosing a Database Page Size
- Choosing a Processor Speed
- Choosing Blob Segment Size
- Clients and Databases
- Column Defaults and Column Constraints
- Command-line isql Tool
- Committing and Rolling Back Transactions
- Committing Work in a SQL Script
- Communication Diagnostics
- Compiled Objects
- Conditional Shadows
- Configuring Parameters in ibconfig
- Configuring Server Properties
- Configuring the Database Cache
- Configuring your System to Use Journaling and Journal Archiving
- Connecting to a New Database
- Connecting to Servers and Databases
- Connection Refused Errors
- Connection Rejected Errors
- Connection Troubleshooting
- Connection-specific Examples
- Converting TIMESTAMP Columns to DATE or TIME
- Creating a Multifile Shadow
- Creating a Sample Journal Archive
- Creating a Shadow
- Creating a Single-file Shadow
- Creating an isql Script
- Creating Databases
- Creating incremental backups
D
- Database and Server Performance
- Database Backup and Restore
- Database Configuration and Maintenance
- Database Design Principles
- Database File Size
- Database Files
- Database ownership
- Database parameter blocks used by an incremental backup
- Database Properties
- Database Statistics and Connection Monitoring
- Database Statistics Options
- Database Tuning Tasks
- Database User Management
- DATE, TIME, and TIMESTAMP Data Types
- DB Connection Tab
- DECIMAL and NUMERIC Data Types
- Default Clauses
- Deferring Index Updates
- Defining Indexes
- Delimited Identifiers
- Designing a Minimal Configuration
- Designing Query Optimization Plans
- Disabling Automatic Sweeping
- Disconnecting a Database
- Distributing I/O
- Do you really need to migrate your NUMERIC and DECIMAL Data Types?
- Dropping a Shadow
- Dropping Databases
E
F
G
I
- Implementing Stronger Password Protection
- Incremental backup guidelines
- Initiating multi- and single-file backups
- Inspecting Database Objects
- Interactive Query
- InterBase backup and restore tools
- InterBase License Options
- InterBase Limits
- InterBase SQL Dialects
- Introduction to Database and Server Performance
- Introduction to Operations
- Invoking isql
- Isql Command Reference
- Isql Commands
L
M
- Managing Archive Size
- Managing isql Temporary Files
- Managing Temporary Files
- Method One: In-place Migration
- Method Two: Migrating to a New Database
- Migrating Clients
- Migrating Data from Other DBMS Products
- Migrating Databases to Dialect 3
- Migrating NUMERIC and DECIMAL Data Types
- Migrating Older Databases
- Migrating Servers and Databases
- Migrating to a New Server
- Migrating to InterBase
- Migration Issues
- Migration Process
- Miscellaneous Issues
- Monitoring Client Connections with IBConsole
- Monitoring with System Temporary Tables
- Multi-Instance
- Multifile Databases
N
O
P
- Page Appendix File
- Performance Considerations for a Network Configuration
- Performing a full backup using IBConsole
- Performing an Immediate Database Sweep
- Performing an incremental backup using IBConsole
- Performing backups and restores using IBConsole
- Performing backups and restores using the gbak command
- Performing Regular Backups
- Preallocating database space with gbak
- Preparing Parameterized Queries
- Primary InterBase Features
R
- Read-write and Read-only Databases
- Recovering Transactions
- Removing a Server
- Removing Database Backup Files
- Repairing a Corrupt Database
- Requirements and Constraints for Encrypted Network Communications
- Restarting a Database
- Restoring a database using IBConsole
- Restoring a database with gbak
- Retrieving Statistics with isc database info()
- Running a SQL Script
- Running gsec Remotely
- Running gsec with Embedded Database User Authentication
S
- Sample 1: Setting up the Client and Server Without Client Verification by the Server
- Sample 2: Setting up the Client and Server for Verifying the Client
- Sample 3: Setting up a JDBC Client and InterBase Server for Verifying the Client
- Sample OTW Configurations
- Saving isql Input and Output
- Security Model
- Server Configuration
- Server Configuration Using Environment Variables
- Setting Database Properties
- Setting isql Client Dialect
- Setting SQL Dialects
- Setting the Database Dialect
- Setting the Database Page Fill Ratio
- Setting the gpre Dialect
- Setting the isql Client Dialect