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> | Filename of a program or source code |
| <Ctrl>+C | Hold the Control key and press C |
| [Button] | Button or Menu name |
| Boldface | Emphasis |
| " " (double quotes) | Reference to chapters or sections in the manual, or to other related documentation |
| 'Input Item' | Description for an input item on the screen |
Hyperlink | E-mail account, website, or a link to other chapters or sections |
| > | Progress order of menus |
| +---- | Files or directories exist below |
| |---- | Files or directories do not exist below |
Note | Reference or note |
| [Figure 1.1] | Figure name |
| [Table 1.1] | Table name |
AaBbCc123 | Command, execution result, or example code |
| { } | Required argument |
| [ ] | Optional argument |
| | | Selective argument |
| Requirements | |
|---|---|
| Platform | HP-UX 11i (IA64) |
| Solaris (Solaris 10) | |
| AIX (PPC 5L/AIX 5.3) | |
| GNU (X86, 64, IA64) | |
| Linux kernel 2.6 or later | |
| Windows (x86) 32bit/64bit | |
| 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 COBOL 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 Active Storage Administrator's Guide | Describes how to manage Tibero files using 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 |
Tibero Hadoop Connector Guide | Describes how to use the Tibero Hadoop Connector. |
| Product | Guide |
|---|---|
| Tibero MMDB | Administrator's Guide |
TmaxData Co., Ltd.
45, Jeongjail-ro, Bundang-gu,
Seongnam-si, Gyeonggi-do, 13613
South Korea
Tel: +82-31-8018-1000
Fax: +82-31-8018-1115
Email: tibero@tmaxdata.com
Web (Korean): http://www.tmaxdata.com
TechNet: http://technet.tmaxsoft.com
TmaxSoft Inc.
230 West Monroe Street Suite 1950
Chicago, IL 60606
U.S.A
Tel: +1-312-525-8330
Fax: +1-312-525-8340
Email: info@tmaxsoft.com
Web (English): http://www.tmaxsoft.com/us_en/home
TmaxSoft Japan Co., Ltd.
5F Sanko Bldg, 3-12-16 Mita, Minato-Ku, Tokyo, 108-0073
Japan
Tel: +81-3-5765-2550
Fax: +81-3-5765-2567
Email: info@tmaxsoft.co.jp
Web (Japanese): http://www.tmaxsoft.co.jp
Beijing TmaxSoft System Software Co., Ltd.
Room103, No.2 Huizhong Building, Seven Street Shangdi,
Haidian District, Beijing, 100085
P.R.China
Tel: +86-10-6298-8827
Email: info@tmaxsoft.com.cn
Web (Chinese): http://www.tmaxsoft.com/cn_en/home_cn_en
Tmax Brasil Sistemas E Serviços Ltda.
Av. Copacabana, 177, sala 32~35 Empresarial 18 do Forte
Alphaville Barueri, Sao Paulo, 06472-001
Brazil
Tel: +55-11-4191-3100
Fax: +55(11) 4191-3705 (extension#112)
Email: info.bra@tmaxsoft.com
Web (Portuguese): http://www.tmaxsoft.com/br_en/home_br_en
Tmax Rus L.L.C.
Leninsky prospekt, 113/1 (Park Place Moscow),
Office 318e, Moscow, 117198
Russia
Tel: +7(495)970-0135
Email: info.rus@tmaxsoft.com
Web (Russian): http://www.tmaxsoft.com/ru_ru/home_ru_ru
Tmax Singapore Pte. Ltd.
430 Lorong 6, Toa Payoh #10-02,
OrangeTee Building, 319402
Singapore
Tel: +65-6259-7223
Fax: +65-6258-7112
Email: info.sg@tmaxsoft.com
Web (English): http://www.tmaxsoft.com/sg_en/home_sg_en
TmaxSoft UK Ltd.
215 Knyvett House, Watermans Business Park,
The Causeway, Staines TW18 3BA
United Kingdom
Tel: +44-1784-895005
Email: info.uk@tmaxsoft.com
Web (English): http://www.tmaxsoft.com/gb_en/home_gb_en
TmaxSoft Canada, Inc.
2425 Matheson Blvd East, 8th floor,
Unit 825 Mississauga, ON, L4W 5K4
Canada
Tel: +1-905-361-2888
Email: info.canada@tmaxsoft.com
Web (English): http://www.tmaxsoft.com/ca_en/home_ca_en
TmaxSoft Proprietary Limited
L32, 101 Miller Street, North Sydney 2060
Australia
Tel: +61-2-8019-7054
Email: info.aus@tmaxsoft.com
Web (English): http://www.tmaxsoft.com/au_en/home_au_en
TmaxSoft Technologies Private Limited
Sobha Alexander Plaza, 3rd Floor,
16/2 Commissariat Road, Bangalore-560025
India
Tel: +91-7619-482-582
Email: info.india@tmaxsoft.com
Web (English): http://www.tmaxsoft.com/in_en/home_in_en
TmaxSoft Co., Ltd. Turkey Liaison Office
Windowist Tower. Eski Buyukdere Cad. No:26,
Maslak 34467 Istanbul
Turkey
Tel: +90-212-214-7345
Email:info.tr@tmaxsoft.com
Web (English): http://www.tmaxsoft.com/tr_en/home_tr_en