Tibero
		Next

Tibero Utility Guide

Tibero 6

Copyright © 2017 TmaxData Co., Ltd. All Rights Reserved.

Restricted Rights Legend

All TmaxData Software (Tibero^®) and documents are protected by copyright laws and international convention. TmaxData software and documents are made available under the terms of the TmaxData License Agreement and this document may only be distributed or copied in accordance with the terms of this agreement. No part of this document may be transmitted, copied, deployed, or reproduced in any form or by any means, electronic, mechanical, or optical, without the prior written consent of TmaxData Co., Ltd.

Nothing in this software document and agreement constitutes a transfer of intellectual property rights regardless of whether or not such rights are registered) or any rights to TmaxData trademarks, logos, or any other brand features.

This document is for information purposes only. The company assumes no direct or indirect responsibilities for the contents of this document, and does not guarantee that the information contained in this document satisfies certain legal or commercial conditions.

The information contained in this document is subject to change without prior notice due to product upgrades or updates. The company assumes no liability for any errors in this document.

Trademarks

Tibero^® is a registered trademark of TmaxData Co., Ltd. Other products, titles or services may be registered trademarks of their respective companies.

Open Source Software Notice

Some modules or files of this product are subject to the terms of the following licenses: OpenSSL, RSA Data Security, Inc., Apache Foundation, Jean-loup Gailly and Mark Adler, Paul Hsieh's hash

Detailed Information related to the license can be found in the following directory: ${INSTALL_PATH}/license/oss_licenses

Document Information

Title: Tibero Utility Guide

Publication Date: 2017-02-24

Software Version: Tibero 6 (FixSet06)

Edition: v2.1.6

Table of Contents

About This Document

1.1. Overview

1.2. Quick Start

1.2.1. Executing Utility
1.2.2. Accessing Database
1.2.3. Interface
1.2.4. Configuration Environment
1.2.5. Terminating Utility

1.3. System Variables

1.4. Basic Functions

1.4.1. Entering Commands
1.4.2. Executing Commands
1.4.3. Additional Functions

1.5. Advanced Functions

1.5.1. Script Function
1.5.2. DBA Functions
1.5.3. User Access Control
1.5.4. Encrypting Connection String

1.6. Commands

1.7. Column Formats

1.7.1. Character Type
1.7.2. Numeric Type

2.1. Overview

2.2. Main Screen

2.3. Compatibility Analysis

2.3.1. Analysis Screen
2.3.2. Compatibility Analysis Targets

2.4. Migration Functions

2.4.1. Migration Options Screen
2.4.2. Migration Progress Screen
2.4.3. Migration Report Screen
2.4.4. Migration Targets

2.5. User Privileges for Migration

2.6. Compatibility Analysis Example

2.7. Migration Example

3. tbExport

3.1. Overview

3.2. Features

3.3. Quick Start

3.3.1. Preparations Before Use
3.3.2. Export Modes
3.3.3. Executing tbExport

3.4. Specifying Parameters at the Command Prompt

3.4.1. Parameters

3.5. Operation Example

4. tbImport

4.1. Overview

4.2. Quick Start

4.2.1. Preparation before Execution
4.2.2. Import Mode
4.2.3. Executing tbImport

4.3. Operation Method

4.3.1. Importing the Table that Has Constraints
4.3.2. Importing the Compatible Table
4.3.3. Importing Data into a Table that Already Exists

4.4. Specifying Parameters at the Command Prompt

4.4.1. List of Parameters

4.5. Usage Example

5. tbLoader

5.1. Overview

5.2. Quick Start

5.3. I/O File

5.3.1. Control File
5.3.2. Data File
5.3.3. Log File
5.3.4. Error File

5.4. Loading Methods

5.5. Constraints

5.5.1. Duplicate Delimiter Values
5.5.2. When ESCAPED BY Option is Not Specified
5.5.3. When Table Owner and User are Different

5.6. Whitespace Rules

5.6.1. When a Field Value Contains Only Whitespace(s)
5.6.2. When a Field Value Contains Whitespace(s)
5.6.3. Specifying White Spaces As Data

5.7. Command Line Parameters

5.7.1. Parameters

5.8. Advanced Functions

5.8.1. Parallel DPL
5.8.2. Encrypting Access Information

5.9. Control File Options

5.9.1. CHARACTERSET
5.9.2. INFILE
5.9.3. LOGFILE
5.9.4. BADFILE
5.9.5. DISCARDFILE
5.9.6. SKIP_ERRORS
5.9.7. Processing Existing Data
5.9.8. PRESERVE BLANKS
5.9.9. Specifying Tables
5.9.10. Specifying Loading Conditions
5.9.11. Creating Indexes
5.9.12. FIELDS TERMINATED BY
5.9.13. FIELDS OPTIONALLY ENCLOSED BY
5.9.14. FIELDS ESCAPED BY
5.9.15. LINES FIX
5.9.16. LINES STARTED BY
5.9.17. LINES TERMINATED BY
5.9.18. TRAILING NULLCOLS
5.9.19. IGNORE LINES
5.9.20. Columns and Properties
5.9.21. Comment

5.10. Examples

5.10.1. Delimited Records
5.10.2. Fixed-Length Records - Terminated by EOL
5.10.3. Fixed-Length Records - Lines Fixed
5.10.4. Large Object Data Types

6.1. Overview
6.2. Quick Start
6.3. Usage Example

7. Utility APIs

7.1. Header File

7.2. Structure

7.3. Utility API

7.3.1. TBConnect
7.3.2. TBDisconnect
7.3.3. TBExport
7.3.4. TBImport

List of Figures

[Figure 2.1] Main Screen
[Figure 2.2] Select All Mode
[Figure 2.3] Schema Mode
[Figure 2.4] Table Mode
[Figure 2.5] Analysis Screen
[Figure 2.6] Directory/File Selection Screen
[Figure 2.7] Migration Options Pop-up
[Figure 2.8] Migration Progress Screen
[Figure 2.9] Migration Report Screen
[Figure 2.10] Compatibility Analysis Main Screen
[Figure 2.11] Analysis Screen (1)
[Figure 2.12] Analysis Screen (2)
[Figure 2.13] Compatibility Analysis Report - Statistics
[Figure 2.14] Compatibility Analysis Report - Details
[Figure 2.15] Analysis - SQL File
[Figure 2.16] Analysis - Directory/File Selection Screen
[Figure 2.17] Analysis - SQL File
[Figure 2.18] Migration Main Screen
[Figure 2.19] Migration - Source Database Connection Information
[Figure 2.20] Migration - Target Database Connection Information
[Figure 2.21] Migration - Migration Options Screen
[Figure 2.22] Migration - Select & Execute
[Figure 2.23] Migration - Migration Progress
[Figure 2.24] Migration - Report Screen
[Figure 2.25] Migration - Completion Screen
[Figure 3.1] Export Mode
[Figure 4.1] Import Mode

List of Examples

[Example 1.1] Executing tbSQL
[Example 1.2] Connecting to Database
[Example 3.1] Executing the tbExport utility
[Example 3.2] Executing Export by Using the tbExport Utility
[Example 4.1] Executing the tbImport Utility
[Example 4.2] Executing Import using the tbImport utility
[Example 5.1] Executing tbLoader
[Example 5.2] tbLoader Command Line Parameters
[Example 5.3] Using Parallel DPL in tbLoader
[Example 5.4] Using Encryption File (wallet)
[Example 6.1] Executing tbdv
[Example 6.2] When a block is marked with incorrect DBA
[Example 6.3] When a fractured block is found
[Example 6.4] When the available and used spaces in a block sums up incorrectly

		Next
		About This Document

Copyright © 2017 TmaxData Co., Ltd. All Rights Reserved.