Table of Contents
This chapter describes functions added to or modified in Tibero 6 FixSet03.
The following describes new functions added to Tibero 6 FixSet03.
The following functions have been added.
TAC
Message communication can be made between TBCM and MTHR via the watchdog channel.
Added the V$INTERCONNECTION view that shows INC information about connections between TAC clusters.
Added the CR Request Async Service (CRAS) and Buffer Request Async Service (BRAS) threads.
Thread | Description |
---|---|
CRAS | When another node in TAC requests building CR blocks, the building can fail. In this case, the CRAS thread is used to wait until the building is possible and to reattempt the building. |
BRAS | If a block header (bh) was insufficient in TAC when caching blocks received along with messages from another node, CMPT (RCVR) continuously tried to allocate bh with blocking. Now the BRAS thread is used to allocate bh. If the allocation is successful, the bh is included in a message and CMPT can operate again. |
system.sh Script
Added the "-e" option to abort the execution of the system.sh script if an error occurred.
Hint
Added the NO_JOIN_ELIMINATION hint that disables unnecessary join elimination.
Tibero Resource Manager
Added the Resource Manager.
Backup & Recovery
Can change an operating TAC to a single instance.
DDL
Can drop a specific partition of a global partitioned index.
Can set Verify_Function in a profile to OLD_PASSWORD.
Added the Partition Exchange function for IOT partitions.
Can use proxy users. For more information, refer to Tibero SQL Reference Guide.
Added the function that allows separation of administrator privileges. For more information, refer to "Chapter 15. Separation of Duties" in Tibero Administrator's Guide.
PSM
Added the NCLOB type.
Added the "CONTINUE WHEN" statement and relevant LABEL.
Added the "FORALL ~ SAVE EXCEPTION" statement.
Character Set
The following character sets have been added.
RU8PC866 for Russian.
TH8TISASCII for Thai.
Static/Dynamic View
The following columns have been added.
TIP_FILE to the V$INSTANCE view
LOGGING to the USER_TAB_PARTITIONS view
Packages and Functions
The following packages and functions have been added.
DBMS_XMLQUERY package
DBMS_DB_VERSION package
UTL_COMPRESS package
DBMS_STANDARD package
DBMS_SQLTUNE.REPORT_SQL_ADVISOR function
DBMS_SESSION.IS_SESSION_ALIVE function
The following functions have been added.
Gateway
Can cancel statements by using the port of the gateway base port + 1 to the Java gateway.
tbJDBC
Added scalar functions (space, left, right, insert, repeat, convert, database, and ifnull) to the JDBC escape syntax.
Supports the NLS_XXX_FORMAT initialization parameters when calling getString() for a DATE or TIMESTAMP column.
The following functions have been added.
Recovery Manager (RMGR)
Added the --a option for the tbrmgr command to back up multiple archive files into a single file.
tbdv
Can be used in a raw device by using the added -l option.
tbSQL
The following commands have been added.
Command | Description |
---|---|
Export | Exports table data to a data or control file. |
History Save | Saves the SQL command list in history as a file. |
History Restore | Loads SQL statements in a file to a history buffer. |
Can define a policy for a specific user to access commands.
tbExport
Can export bitmap Indexes.
Can export physical attributes and indexes of materialized views.
The following describes functions modified in Tibero 6 FixSet03.
The following functions have been improved.
TAC
Improved (distributed) deadlock detection and its performance.
TSC
Increased performance by caching log data. The cached data is used in a Primary DB. Blocks that are not read from a disk by the Primary DB are also not read by a Standby DB.
Binary TIP (BTIP)
BTIP is supported for parameters that cannot be modified dynamically.
DDL
The password_grace_time constraint for a user profile can be set to 0.
The following functions have been improved.
tbdv
Increased performance by using the Multi Block Read funciton.
tbExport
Restricted functions related to SYS, SYSCAT, and SYSGIS users.
Exports objects of all users except for SYS, SYSCAT, and SYSGIS in the full database mode.
Displays 'Error: cannot export system users' if exporting objects of SYS, SYSCAT, or SYSGIS in the user mode.
tbImport
Restricted functions related to SYS, SYSCAT, and SYSGIS users.
Imports objects of all users except for SYS, SYSCAT, and SYSGIS in the full database mode.
Displays 'Error: cannot import system users' if importing objects of SYS, SYSCAT, or SYSGIS in the user mode.