This guide is intended for database administrators (DBA) who intend to use Tibero® (hereafter Tibero).
This guide describes how to create and efficiently manage databases.
The user must have knowledge of the following in order to understand this guide:
Database
RDBMS
Operating systems and system environments
UNIX and Linux
This guide does not contain all the information required to operate Tibero. For information related to installation, configuration, operation and management, refer to each relevant guide.
For more information about Tibero installation and configuration, refer to Tibero Installation Guide.
This guide consists of 15 chapters and 4 appendices.
Descriptions for each are as follows:
Chapter 1: Introduction to Tibero
Describes the basic concepts, processes, and directory structures of Tibero from the perspective of a DBA.
Chapter 2: Basic Database Administration
Describes the basic knowledge needed for the administration of Tibero.
Chapter 3: File and Data Management
Describes the methods used to manage files and data of Tibero.
Chapter 4: Schema Object Management
Describes the methods used to manage schema objects needed for the makeup of databases in Tibero.
Chapter 5: User Management and Database Security
Describes methods to create and manage users, privileges, and roles for database security.
Chapter 6: Backup and Recovery
Describes various backup and recovery methods used for unexpected system failure.
Chapter 7: Distributed Transactions
Describes the functions provided by Tibero to support distributed transactions.
Chapter 8: Tibero Standby Cluster
Describes Tibero Standby Cluster, which is used for high availability, data protection, and disaster recovery.
Chapter 9: Tibero Cluster Manager
Describes the basic concepts, environment configuration, and startup of Tibero New Cluster Manager.
Chapter 10: Tibero Active Cluster
Describes the highly scalable and available Tibero Active Cluster.
Chapter 11: Data Encryption
Describes how to use and manage the data encryption functions in Tibero.
Chapter 12: Communication Encryption
Describes how to use and manage the communication encryption features in Tibero.
Chapter 13: Parallel Execution
Describes parallel execution's basic concepts, operation principles, and execution methods.
Chapter 14: Tibero Performance Repository
Describes Tibero Performance Repository, which is used to monitor Tibero's performance.
Chapter 15: Separation of Duties
Describes how to configure and use Tibero Separation of Duties that allows separation of administrator privileges in Tibero.
Appendix A: tbdsn.tbr
Describes tbdsn.tbr, a configuration file necessary for clients to access Tibero.
Appendix B: V$SYSSTAT
Describes the various system statistics that are contained in the dynamic view V$SYSSTAT.
Appendix C: Troubleshooting
Describes how to solve problems that may occur while using Tibero.
Appendix D: Client Environment Variables
Describes the environment variables that can be specified by clients.
| Convention | Meaning |
|---|---|
| <AaBbCc123> | Program source code file name |
| <Ctrl>+C | Hold down the Ctrl key and press the C key |
| [Button] | Name of a GUI button or menu |
| Bold | Emphasis |
| Italics | Reference to another guide |
| " " (Double quotation marks) | Reference to a chapter or section in this or another guide |
| 'Input' | User input on the screen |
Hyperlink
| Email account, website, or a reference to other chapters or sections |
| > | Proceeding order of menu |
| +---- | Files or directories exist in this directory |
| |---- | Files or directories do not exist in this directory |
Note | Reference or caution |
| [Figure 1.1] | Figure caption |
AaBbCc123 | Commands, screen output after executing command, or sample code |
| { } | Required items |
| [ ] | Optional items |
| | | Selective items |
| Version | Description |
|---|---|
| v2.1.7.4 |
|
| v2.1.7.3 |
|
| v2.1.7.2 |
|
| v2.1.7.1 |
|
System Requirements
Requirements Platform HP-UX 11i (IA64) Solaris (Solaris 10) AIX (PPC 5L/AIX 5.3) GNU (X86-64, IA-64) Linux kernel 2.6 or later Windows (x86) 32-bit/64-bit Hardware At least 2.5 GB hard disk space More than 1 GB RAM Compiler PSM (C99 support needed) tbESQL/C (C99 support needed)
| Document | Description |
|---|---|
Tibero Installation Guide | Describes the system requirements and specific methods for installation and uninstallation. |
Tibero tbCLI Guide | Describes the tbCLI (Call Level Interface) concepts, components and program structure, as well as data types, functions, and error messages needed to write tbCLI applications. |
Tibero Application Developer's Guide | Describes how to develop application programs by using application libraries. |
Tibero External Procedure Guide | Describes how to create and use external procedures. |
Tibero JDBC Developer's Guide | Describes how to develop application programs by using the JDBC functions provided in Tibero. |
Tibero tbESQL/C Guide | Describes how to create various database application programs in the C programming language. |
Tibero tbESQL/COBOL Guide | Describes how to create various database application programs in the C programming language. |
Tibero tbPSM Guide | Introduces the concepts, syntax, and components of tbPSM (Procedure Storage Module). This guide also describes how to execute the control structure, complex type, sub programs, packages, and SQL statements required for creating a tbPSM program and to handle any errors. |
Tibero tbPSM Reference Guide | Introduces the tbPSM package, a storage procedure module. This guide also describes the prototypes, parameters, and examples of each procedure and function included in this package. |
Tibero Utility Guide | Describes how to install, use, and configure the utilities that handle database related operations. |
Tibero TAS Guide | Describes how to manage files in Tibero Active Storage (TAS). |
Tibero Error Reference Guide | Describes troubleshooting methods for various errors that may occur while using Tibero. |
Tibero Reference Guide | Describes the initialization parameters, data dictionary, and static and dynamic views used by Tibero. |
Tibero SQL Reference Guide | Describes the SQL statements required for creating application programs or operating a database. |
Tibero Spatial Reference Guide | Describes the geometry type and spatial procedures and functions of Tibero and how to use them. |
Tibero TEXT Reference Guide | Describes how to create and use the text index provided by Tibero. |