Table of Contents
This chapter describes functions added to or modified in Tibero 6 FixSet01.
The following describes new functions added to Tibero 6 FixSet01.
The following functions have been added.
ASH (Active Session History)
ASH (Active Session History) records and maintains a history of the running session on shared memory. The history is in circular queue format and recorded at relatively short intervals. The administrator can view recent session history in SQL format to diagnose performance issues.
TBCM (Tibero Cluster Manager)
VIP monitoring and failover function. It provides a function that executes VIP failover even when only an instance fails when the VIP status is monitored in CM.
Function that stores logs in CM GUARD.
Parameter that improves the speed of monitoring failed nodes.
For more information, refer to "Chapter 9. Tibero Cluster Manager" in Tibero Administrator's Guide.
TSC (Tibero Standby Cluster)
Provides a function that stores index fast build logs and DPI/DPL logs in the NOARCHIVE mode.
Provides a function that delays the application of the standby redo log for a specified period of time.
Backup & Recovery
Supports the "alter database datafile ~ offline for drop" statement for deleting a tablespace that contains a data file with an error.
Provides a function that detects corrupt DB blocks. The function is integrated with RMGR so that only the relevant blocks are recovered when media recovery is performed.
Provides the mean crash recovery time function, which can set the mean crash recovery time.
For more information, refer to "Chapter 6. Backup and Recovery" in Tibero Administrator's Guide.
TPR (Tibero Performance Repository)
In Tibero 6, APM (Automatic Performance Monitoring) is now TPR (Tibero Performance Repository).
For more information, refer to "Chapter 14. Tibero Performance Repository" in Tibero Administrator's Guide.
Baseline
Sets the performance standard of the DB load.
Aggregation Retention Over
Combines TPR snapshots with expired retentions into a summary and then stores it.
Comparison between TPR snapshots
Compares the difference in performance between user-defined snapshots.
TPR Report
Added physical reads, logical reads, ITL waits, buffer busy waits, and row lock waits information by segment.
Added SQL ordered by extra I/O and elapsed time per execution information.
Added the parameter change history and the range display function.
Added the APM session information collection, storage, and output report function.
Added the I/O overview section display function.
Background Process Reboot
Previously, if a background process abnormally terminated, Tibero sometimes shut down. To prevent these abnormal reboots and to enhance stability, some background processes are now automatically restarted if they abnormally terminate.
Listener Multi-port Support
Added a function that dynamically specifies multiple listener ports that can access Tibero database.
For more information, refer to "5.5.3. Dynamically Adding and Deleting a Listener Port" in Tibero Administrator's Guide.
OS Authentication Support
Provides a function that allows a user to log into the DBMS through OS authentication instead of authenticating through the DBMS password system.
For more information, refer to "5.1.4. Creating an OS Authenticated User" in Tibero Administrator's Guide.
BINARY TIP
Provides a function that stores initialization parameter values into a binary file.
For more information, refer to "2.6. Using Binary TIP" in Tibero Administrator's Guide.
Indexing in TDE
Added a function that allows range searches and index unique searches even when columns are encrypted through the TDE function.
Data Definition Language (DDL)
The following statements have been added. For more information, refer to Tibero SQL Reference Guide.
ALTER TABLE statement
Provides the range/list composite partition merge function.
Provides the partition exchange statement, which replaces a segment of a partition of a partitioned table with a segment of another table.
The PARALLEL function has been added to the MOVE PARTITION statement.
ALTER INDEX statement
Added a function that can recreate partition indexes.
ALTER VIEW statement
Data Manipulation Language (DML)
Provides a function that allows DML execution to continue even if an error occurs during execution. If an error occurs, error information and data are stored in the error logging table and then the next ROW is executed.
New Data Types
Added the BINARY_FLOAT and BINARY_DOUBLE data types for processing floating point data.
Recursive WITH Statement
Supports the recursive WITH statement which is a recursive common table expression defined in the SQL-99 standard.
Query Outline
Provides a function that can store created plan information so that the plan can be later used for the same queries.
Bind Variable Capture
Provides a function that periodically stores SQL bind variables in the server.
Advanced Queuing
Provides an advanced queuing function. It is a message queuing function that is integrated with the Tibero
SQL PLAN HISTORY
Provides a function that monitors unintended changes in a plan by saving the history of optimizer and statistics changes.
Adaptive Cursor Sharing
Creates multiple plans when SQL has a bind variable in order to find an optimal plan even when various bind variable values are entered.
Result Cache Statistics
Displays the hit ratio for each result cache by using the V$RESULT_CACHE_STATISTICS and V$RESULT_CACHE_OBJECT_STATISTICS views.
VPD (Virtual Private Database)
Provides a rule-based database access control function.
Bitmap Index
Can efficiently execute OLAP queries.
Analytic Function Transformation
When using an aggregation subquery for the same table and the conditions are met, SQL statements can be transformed into an analytic function for efficient execution.
Materialized View with a Remote Storage
Added a function that can synchronize data in the base table in Tibero by using the materialize view in heterogeneous databases.
For more information, refer to Tibero SQL Reference Guide.
PSM
Added the wrapper function.
Provides a function that can encrypt PSM function/procedure/package body sources.
Object type
Provides abstract data types that capsulized data components of data types and sub programs.
Can use collection type via global variables.
Can use Continue Syntax in a loop statement.
Provides XMLType/Geometry computation functions.
For more information, refer to Tibero tbPSM Guide.
Job Scheduler
Provides functions that allow statements that can be used in PSM to be registered and executed as jobs.
Time based Job Scheduling
Periodically starts tasks at a set time.
Dependency based Job Scheduling
Sequentially runs the next task if the previous task succeeds.
Character Sets
The following character sets have been added.
| (Regional) Language | Character Set | Description |
|---|---|---|
| Chinese, Hong Kong | ZHT16HKSCS | HKSCS2001 Hong Kong MS Windows Code Page 950 Chinese |
| Vietnamese | VN8VN3 | VN3 8-bit Vietnamese |
| Eastern European | EE8ISO8859P2 | ISO8859-2 Eastern European |
| Western European | WE8MSWIN1252 | MS Windows Code Page 1252 Western European |
| WE8ISO8859P1 | ISO8859-1 Western European | |
| WE8ISO8859P9 | ISO8859-9 Western European (Turkish) | |
| WE8ISO8859P15 | ISO8859-15 Western European | |
| Russian, Bulgarian | CL8MSWIN1251 | MS Windows Code Page 1251 Cyrillic Script |
| CL8KOI8R | KOI8-R Cyrillic Script | |
| CL8ISO8859P5 | ISO8859-5 Cyrillic Script |
Static/Dynamic Views
The following view tables have been added.
| View Table | Description |
|---|---|
| V$INTERCONNECT_LATENCY | Displays interconnect latency time. |
| V$SHP_ADVICE | Displays the recommended shared pool size. |
| V$BG_SESSION | Displays information of each background session. |
| V$LOG_HISTORY | Displays log history. |
| V$ENCRYPTION_WALLET | Displays WALLET status. |
| V$RUNNING_JOBS | Displays information about running jobs. |
| V$RUNNING_JOBS_WITH_NAME | Displays information about running jobs with a name. |
| V$SQL | Displays statistics of the child cursor of each SQL. |
| V$SQLAREA | Displays statistics of an SQL statement. |
| V$SYS_TIME_MODEL | Displays the time information of the system level for statistical analysis. |
| V$SESS_TIME_MODEL | Displays the time information of the session level for statistical analysis. |
Embedded Functions
The following functions have been added. For more information, refer to Tibero SQL Reference Guide.
| Function | Description |
|---|---|
| XMLCDATA() | Creates the CDATA section using the results of expr. |
| XMLROOT() | Creates XML declaratives. |
| XMLCOLATTVAL() | Creates an XML fragment and expands the resulting XML. Each XML fragment has the name "column" with the "name" property. The parameters are combined and then returned. |
Packages
The following packages have been added or improved. For more information, refer to Tibero tbPSM Reference Guide.
| Package | Description |
|---|---|
| DBMS_AQ | Provides procedures and functions related to the advanced queuing function. |
| DBMS_AQADM | Provides procedures and functions that can be used to configure and manage the advanced queuing function. |
| DBMS_DEBUG | Provides procedures and functions that can debug a PSM program by using two sessions. |
| DBMS_PIPE | Provides procedures and functions that can communicate between sessions in the same instance. |
| DBMS_RESULT_CACHE | Provides procedures and functions that allow the DBA to control the result cache in the shared memory of a database. |
| DBMS_RLS | Provides procedures and functions that can be used to configure and manage the virtual private database functions of a DBMS. |
| DBMS_SCHEDULER | Registers statements that can be used in the PSM as a JOB. It also provides the procedures and functions that can execute the registered JOB. |
| DBMS_XMLGEN | Provides procedures and functions that can create the result set of the entered query into xmltype. |
| DBMS_XPLAN | Provides procedures for selecting the user-desired items for the plan information and the plan's execution information. This package can display the plan information and execution information in various formats. |
| UTL_HTTP | Provides a package that provides a client role according to the HTTP protocol, which is a web standard (RFC2616). |
The following are the functions that have been added to existing packages.
| Package | Added Functions |
|---|---|
| DBMS_CRYPTO | Provides ARIA algorithms and encryption for BLOB data. |
| DBMS_UTILITY | The following procedures have been added.
|
| DBMS_LOB | The following procedures have been added.
|
| DBMS_LOCK | The following procedures have been added.
|
| UTL_TCP | Added the CRLF constant which contains carriage return characters and line feed characters. |
The following functions have been added.
Gateway
C Gateway
The CONFIG property, which can specify the location of the gateway configuration file, has been added in tbdsn.tbr.
The CHARACTER_SET option, which can configure the character sets to be used, has been added in the gateway configuration file (tbgw.cfg).
Java Gateway
Supports the national character set in Tibero to MS-SQL.
For more information, refer to "7.4. Database Links (DBLinks)" in Tibero Administrator's Guide.
tbJDBC
The following is the function that has been added to the JDBC driver.
Added connection properties
| Property Name | Description |
|---|---|
| defaultNChar | Character strings configured using PreparedStatement.setSting() API are forcibly sent to the server by using the national charset configuration. |
OLE DB
The following are the functions that have been added to OLE DB driver.
The following options that can be used in the connection string have been added.
| Option | Description |
|---|---|
| OLE DB Services | Option to use a connection pool.
|
| Connect Timeout | Connection timeout for the database. (Unit: seconds) |
| Connect Lifetime | Period for which the connection pool that is connected to the database in a connected status is maintained. (Unit: seconds) |
| Max Pool Size | Maximum number of connections allowed in the connection pool. |
| Min Pool Size | Minimum number of connections allowed in the connection pool. |
| Enlist | Option to use DTC (Distributed Transaction Coordinator).
|
Provides the MultipleResultSet function which can return multiple CURSORS when calling the stored procedure.
The following functions have been added.
Recovery Manager (RMGR)
The following functions have been added to RMGR. For more information, refer to "Chapter 6. Backup and Recovery" in Tibero Administrator's Guide.
Auxiliary database recovery functions that can create a new database and perform recovery are supported.
| Option | Description |
|---|---|
| --auxiliary | Specifies the directory in which RMGR creates auxiliary databases. |
| --auxiliary-ip | Specifies the access IP of the auxiliary database. |
| --auxiliary-port | Specifies the access port of the auxiliary database. |
The following are the added options.
| Option | Description |
|---|---|
| info | Checks the BACKUP LIST. |
| --beforetime | Deletes the backup file before the specified time. |
| --archive-log | Backs up the ARCHIVE LOG. |
| -c, --compress | Compresses the backup during FULL BACKUP. |
| --datafile | Backs up and recovers data files. |
| --tablespace | Backs up and recovers tablespaces. |
| --untilcancel | Performs incomplete recovery until the user cancels. |
| -t, --thread | Performs backup and recovery in parallel. (Only supported in UNIX) |
Tibero Block Verifier (tbdv)
A utility for monitoring the integrity of the database datafile has been added.
tbSQL
The following functions have been added to tbSQL.
A function called Connection Specification, which can access a database by directly specifying the access data without using the tbdsn.tbr file, has been added.
The following system variables have been added.
| System Variable | Description |
|---|---|
| EXITCOMMIT | Option to commit when shutting down a utility. |
| HEADSEP | Sets the newline character of the header. |
| NEWPAGE | Sets the number of empty lines to be added at the beginning of each page. |
| RECSEP | Sets the unit for row separators. |
| RECSEPCHAR | Sets the character for row separators. |
| UNDERLINE | Sets the character used for the underline of the header. |
The following command has been added.
| Command | Description |
|---|---|
| ARCHIVE LOG | Displays redo log file information. |
The statements of the following commands in tbSQL have been added.
The NEW_V[ALUE] statement, which sets the variable that will store column values, has been added to the COLUMN command.
The DEF[AULT] statement, which sets the substitute variable that is used if the user does not enter a value, has been added to the ACCEPT command.
The following statement that can be used in the [exit_option] has been added to the WHENEVER command.
| Item | Description |
|---|---|
| SQL.SQLCODE | Returns an error code if an error occurs. |
tbLoader
The following option has been added.
| Option | Description |
|---|---|
| -c|--charset | Checks the character sets supported in Tibero |
tbMigrator 2.0
The following option has been added.
| Option | Item | Description |
|---|---|---|
| DDL | Execute DDLs | Option to execute an extracted DDL statement in the target database. |
| Conversion | Remove Double Quotation | Ignores case sensitivity of object names during migration. |
The following databases, which can be migrated, have been added.
SQL Server
PostgreSQL
tbExport
The following options have been added.
| Option | Description |
|---|---|
| CONSISTENT | Exports data based on the time of export. |
| EXCLUDE | Sets the users and tables to be excluded during export. |
| GEOM_ASBYTES | Option to retrieve geometry columns in WKB or bytes. |
| TEMP_DIR | Specifies the directory in which temporary dump files are created during export. |
| SAVE_CREDENTIAL | Uses encrypted USERNAME and PASSWORD for export. |
| TRIGGER | Option to import trigger during export. |
| LOG | Enters the export log file name. |
| LOGDIR | Enters the directory name that contains the export log file. |
tbImport
The following functions have been added.
| Option | Description |
|---|---|
| DBLINK | Option to import DBLink during import. |
| ROLE | Option to import the role during import. |
| PSM | Option to import PSM objects during import. |
| SEQUENCE | Option to import sequences during import. |
| SYNONYM | Option to import synonyms during import. |
| TRIGGER | Option to import triggers during import. |
| TEMP_DIR | Specifies the directory in which temporary dump files are created during import. |
| SAVE_CREDENTIAL | Uses encrypted USERNAME and PASSWORD for import. |
| GEOM_ASBYTES | Option to retrieve geometry columns in WKB or bytes. |
| LOG | Enters the import log file name. |
| LOGDIR | Enters the directory name that contains the import log file. |
tbESQL/C
The following functions have been added.
ESQL_TYPE_UINT and ESQL_TYPE_INT are supported for unsigned and signed declared variables.
Added EXEC SQL VAR and EXEC SQL TYPE for datatype equivalencing.
Supports multi-line EXEC SQL INCLUDE statements.
Supports the EXEC SQL WITH identifier AS (subquery) SELECT ~ statement.
tbESQL/COBOL
The following functions have been added.
Added PIC9_WITH_SIGN, which specifies if the PIC 9 type has the (+) sign, to the PIC COMP-3 type.
Added the COMP5 option, which does not convert the COMP type to COMP-5 type.
The following describes functions modified in Tibero 6 FixSet01.
The following functions have been improved.
Improved Search Space
Applied the improved Search Space version.
Applied the CRX on PGA function.
Applied the Non Block Format function.
Fast cleanout is only performed in local blocks.
Improved LOB Processing Speed
Improved performance when small sized LOB are processed.
Improved Buffer Cache and I/O Performance
LRU management function
CACHE usage rate
Redo Log Flush/Wait related performance
DB Writer I/O efficiency for consecutive blocks
TBCM (Tibero Cluster Manager)
CM runs properly even when the OS time is modified.
TAC (Tibero Active Cluster)
Checkpoint performance.
Interconnect function/performance.
Can use Smart Scan during Full Table Scan.
Implemented the BATCH LOCK protocol.
Split Brain policy.
TPR (Tibero Performance Repository)
APM(Automatic Performance Monitoring) has been changed to TPR(Tibero Performance Repository).
Increased the Maximum Index Column Length
The maximum length of an index column has been increased from 4062 bytes to 6424 bytes.
Improved Function for Handling Connection Failure between Heterogeneous Databases
TIMEOUT is now processed when a response is not received within a specific period when attempting a connection between heterogeneous databases.
Improved Analytic Function Performance
Optimized the analytic function that does not have a window clause to improve performance.
Improved Sort Performance
Applied AIO when reading temp segments.
PSM
PSM source save type has been changed from LONG to VARCHAR to support LIKE search.
The following function has been improved.
tbJDBC
Improved Blob Data Read speed.
The following functions have been improved.
Recovery Manager (RMGR)
Improved the incremental backup performance
tbSQL
Changed the FILEEXT parameter to SUFFIX.
Deleted the FILEPATH parameter.
tbMigrator 2.0
IOT (Index Organized Table) migration support
Global/Local Partitioned Index migration support
tbExport/tbImport
IOT(Index Organized Table) support
Global/Local Partitioned Index support
MView (Materialized View) support
Encrypted PSM Object support