Tibero tbAdmin Guide

Tibero 5 SP1

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 may only be used 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.

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

This product includes open source software developed and/or licensed by "OpenSSL," "RSA Data Security, Inc.," "Apache Foundation," "Jean-loup Gailly and Mark Adler," and "Paul Hsieh's hash". Information about the aforementioned and the related open source software can be found in the "${INSTALL_PATH}/license/oss_licenses" directory.

Manual Information

Title: Tibero tbAdmin Guide

Publication Date: 2014-08-01

Product Number: Tibero 5 SP1

Edition: 2.1.1

Table of Contents

About This Document

1. Introduction to tbAdmin

1.1. Overview

1.2. Starting up and Shutting down

1.2.1. Before start-up
1.2.2. Starting up
1.2.3. Log-in Configuration and Database Access
1.2.4. Shutting down

1.3. Environment Setting

1.3.1. Editor Options
1.3.2. Home Directory

2. Screen Layout

2.1. Initial Screen

2.2. Details of Each Panel of the Screen

2.2.1. Menu
2.2.2. Tool bar
2.2.3. Title bar
2.2.4. Perspective
2.2.5. Schema Tree Browser
2.2.6. Editor
2.2.7. Schema Object Detail
2.2.8. View

3. Basic Functions

3.1. SQL Editor

3.1.1. Editor
3.1.2. Result View
3.1.3. SQL History View

3.2. PSM Editor

3.2.1. Editor
3.2.2. Result View

3.3. Schema Browser

3.4. Schema Tree Browser

3.5. ASCII Table

4. Functions for DBAs

4.1. Overview

4.2. Session Manager

4.3. SQL Monitor

4.4. Transaction Monitor

4.5. Analyze Manager

4.6. Graph and Report

4.7. Parameter Manager

4.8. Extents Viewer

4.9. Database Information

4.10. Tablespace Manager

4.11. Instance Monitor

4.12. Compile Invalid Objects

4.13. Security Manager

4.14. Export, Import

4.14.1. Export
4.14.2. Import

4.15. ExpImp

A. Shortcut Keys

A.1. File
A.2. Edit
A.3. SQL Statement Execution
A.4. Basic Functions
A.5. DBA Functions

Index

List of Figures

[Figure 1.1] Login & Connection Config
[Figure 1.2] Initialization Screen
[Figure 1.3] Preferences
[Figure 1.4] Editor Options - [Appearance] Tap
[Figure 1.5] Editor Options - [Syntax Highlighting] Tab
[Figure 1.6] Editor Options - [Templates] Tab
[Figure 1.7] Table Editor
[Figure 1.8] Home Directory
[Figure 2.1] Initial Screen
[Figure 2.2] Menu
[Figure 3.1] SQL Editor
[Figure 3.2] SQL Editor - Context Menu
[Figure 3.3] SQL Editor - SQL statement input and execution
[Figure 3.4] SQL Editor - Execution Plan
[Figure 3.5] PSM Editor
[Figure 3.6] Schema Browser
[Figure 3.7] Schema Tree Browser
[Figure 3.8] Schema Tree Browser - Context Menu
[Figure 3.9] ASCII Table
[Figure 4.1] The Session Manager
[Figure 4.2] The Session Manager - [Sessions] Tab
[Figure 4.3] The Session Manager - [All Locks] Tab
[Figure 4.4] The Session Manager - [Blocking Locks] Tab
[Figure 4.5] The SQL Monitor
[Figure 4.6] The SQL Monitor - Criteria Section
[Figure 4.7] SQL Monitor - SQL Filter Section
[Figure 4.8] The Transaction Monitor
[Figure 4.9] The Analyze Manager
[Figure 4.10] The Analyze Manager
[Figure 4.11] The Analyze Manager
[Figure 4.12] The Graph and Report
[Figure 4.13] The Batch Report
[Figure 4.14] The Parameter Manager
[Figure 4.15] Parameter Manager - InitParam Value Change Dialog
[Figure 4.16] The Extents Viewer
[Figure 4.17] The Database Information
[Figure 4.18] The Tablespace Manager
[Figure 4.19] The Instance Monitor
[Figure 4.20] The Compile Invalid Objects Dialog
[Figure 4.21] The Security Manager
[Figure 4.22] The Security Manager - [General] Tab
[Figure 4.23] The Security Manager - [Role] Tab
[Figure 4.24] The Security Manager - [System] Tab
[Figure 4.25] Export
[Figure 4.26] Import
[Figure 4.27] ExpImp - [Options] Tab
[Figure 4.28] ExpImp - [Export]
[Figure 4.29] ExpImp - [Import] Tab

Tibero
		Next

		Next
		About This Document