This guide is intended for database administrators (DBAs) who intend to use Tibero® (hereafter Tibero). This guide describes the various utilities provided.
The user must have knowledge of the following in order to understand this guide:
Databases
RDBMSs
SQL
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 the "Tibero Installation Guide."
This guide consists of 6 chapters.
Descriptions for each are as follows:
Chapter 1: tbSQL
Introduces and describes the tbSQL utility which processes Interactive SQL commands.
Chapter 2: tbMigrator 2.0
Introduces and describes the tbMigrator 2.0 which migrates existing database to Tibero.
Chapter 3: tbExport
Introduces and describes the tbExport utility which extracts database objects, stored inTibero.
Chapter 4: tbImport
Introduces and describes the tbImport utility which extracts database objects from the Export file, generated by tbExport and stores them in Tibero.
Chapter 5: tbLoader
Introduces and describes the tbLoader which is used to load mass data in a single transaction into Tibero database.
Chapter 6: Utility API
Describes APIs required for application programs to call Tibero
| Convention | Meaning |
|---|---|
| <AaBbCc123> | Filename of a program source code |
| <Ctrl>+C | Hold down the Control key and press C |
| [Button] | Button or Menu title |
| 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
| Mail account, website, 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 |
| | | Argument with choices |
| Requirements | |
|---|---|
| Supported Platforms | HP-UX 11i (PA-RISC, ia64) |
| Solaris (SPARC 9/Solaris 9) | |
| AIX (PPC 5L/AIX 5.3) | |
| GNU (X86, 64, IA64) | |
| Linux Kernel 2.6 or later | |
| Windows (x86) 32bit/64bit | |
| Hardware | At least 1.5 GB hard disk space |
| More than 512 MB RAM | |
| Compiler | PSM (C99 support needed) |
| tbESQL/C (C99 support needed) |
| Document | Description |
|---|---|
|
Tibero Installation Guide | Describes system requirements and specific steps for installation and uninstallation. |
|
Tibero tbCLI Guide | Describes the tbCLI's (Call Level Interface) concepts, components, and program structures, along with data types, functions, and error messages, needed to write tbCLI programs. |
|
Tibero Application Developer's Guide | Describes methods to develop application programs using various application libraries. |
|
Tibero External Procedure Guide | Describes how to create and use external procedures. |
|
Tibero JDBC Developer's Guide | Describes methods to develop application programs using JDBC functions provided by Tibero. |
|
Tibero tbESQL/C Guide | Describes how to write diverse database applications using the C programming language. |
|
Tibero ttbESQL/COBOL Guide | Describes how to write diverse database applications using the COBOL programming language. |
|
Tibero tbPSM Guide | Describes tbPSM's (Procedure Storage Module) concepts, syntax, components, control structures, composite types, subprograms, packages, SQL execution methods, and error handling, which are necessary for writing tbPSM programs. |
|
Tibero tbPSM Guide | Describes the details of tbPSM packages, such as prototypes, parameters, and examples of each procedure and function included in those packages. |
|
Tibero Administrator's Guide | Describes what a DBA should know to logically and physically manageTibero, and introduces diverse tools to support management activities. |
|
Tibero tbAdmin Guide | Describes tbAdmin, a GUI-based tool which provides SQL/PSM processing and system management functions for DBAs, along with installation and operation methods. |
|
Tibero Utility Guide | Describes database-handling utilities and their installation, configuration, and operation methods. |
|
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 SQL statements needed to work with databases and write applications. |
TmaxData Co., Ltd.
5, Hwangsaeul-ro 329beon-gil, Bundang-gu,
Seongnam-si, Gyeonggi-do, 463-824
South Korea
Tel: +82-31-779-7113
Fax: +82-31-779-7119
Email: tibero@tmaxdata.com
Web (Korean): http://www.tmaxdata.com
Technical Support: http://technet.tmaxsoft.com
TmaxSoft, Inc.
560 Sylvan Avenue Englewood Cliffs, NJ 07632
USA
Tel: +1-201-567-8266
Fax: +1-201-567-7339
Email: info@tmaxsoft.com
Web (English): http://us.tmaxsoft.com
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://jp.tmaxsoft.com
Beijing TmaxSoft System Software Co., Ltd.
Room 1101, Building B, Recreo International Center,
East Road Wang Jing, Chaoyang District, Beijing, 100102
P.R.C
Tel: +86-10-5783-9188
Fax: +86-10-5783-9188 (#800)
Email: info@tmaxsoft.com.cn
Web (Chinese): http://cn.tmaxsoft.com
Tmax Brasil Sistemas e Serviços Ltda.
Av. Copacabana, 177, sala 32, 18 do Forte Empresarial,
Alphaville, Barueri, São Paulo, Brasil, CEP 06472-001
Brazil
Tel: +55-11-4191-3100
Fax: +55(11) 4191-3705 (extension#112)
Email: info.bra@tmaxsoft.com
Web (Chinese): http://br.tmaxsoft.com
Tmax Rus L.L.C.
Grand Setun Plaza, No A204 Gorbunova st.2,
Moscow, 121596
Russia
Tel: +7(495)970-01-35
Email: info.rus@tmaxsoft.com
Web (Russian): http://ru.tmaxsoft.com
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
TmaxSoft UK Ltd.
Surrey House, Suite 221, 34 Eden Street,
Kingston-Upon-Thames, KT1 1ER
United Kingdom
Tel: + 44-(0)20-8481-3776
Fax: +44-203-092-4681
Email: info.uk@tmaxsoft.com
Web (English): http://www.tmaxsoft.com