Release note_7.2

This chapter briefly describes newly added and updated features in Tibero 7.2.

New Features

This section lists and briefly describes newly added features.

DBMS Engine

JSON Type

– Supports the JSON_MERGEPATCH and JSON_OBJECTAGG functions.

– Supports Function-based indexes for JSON_VALUE. (Options for JSON_VALUE must match.)

– Supports declaration of JSON type variables and an IN/OUT parameter in PSM.

SQL PROFILE

It allows SQL tuning when the user cannot modify an SQL query within an application.

For more information about how to use SQL profiles, refer to "DBMS_SQLTUNE" in Tibero tbPSM Reference Guide.

SQL PLAN BASELINE

– Stores SQL plans to be used by the user without choosing the Optimizer for optimized plans.

Patch and rollback tasks when TAS meta files are added or removed

– Added DDLs to support a patch implementation that requires adding or removing TAS meta files, without reconfiguring TAS.

Tibero Recovery Catalog

It supports metadata management for multiple databases.

• Tibero Recovery Catalog stores metadata of different databases to physically separated locations. The database storing metadata is referred to as Catalog database (Catalog).

• When a database is registered in the catalog, tbrmgr scans the database's control file and extracts metadata, which is sent and stored to the catalog.

• It keeps data up-to-date.

• It updates metadata when backups are created or deleted using the rmgr client, or when the administrator requests resynchronization.

For more information, refer to "Tibero Recovery Catalog" in Tibero Administrator's Guide.

Copying files based on the redundancy number with ASCMD commands

– Added an option for the cp and cptolocal commands to specify a mirror of a target file through ascmd.

– The -redun option (set to a value between 0 and 2) copies a file according to the redundancy number.

MVIEW

– Added new MVIEW features.

• [DBA|ALL|USER]_MVIEW_DETAIL_RELATIONS : displays MVIEW-related objects information.

• [DBA|ALL|USER]_MVIEW_REFRESH_TIMES : displays refresh time of MVIEW.

CONTEXT INDEX

– Added views for CONTEXT INDEX.

• CTX_PREFERENCES

• CTX_PREFERENCE_VALUES

• CTX_STOPLISTS

Utilities

SET MARKUP for tbSQL

– Displays output of tbsql in html.

Client Drivers

JDBC 4.1 Standards

• It supports java.math.BigInteger and JDBC type BIGINT.

• It supports disconnection using the connection.abort function.

• It supports specifying schema using the connection.setSchema function.

• It supports specifying a timeout using the connection.setNetworkTimeout function.

• It supports closing statements upon the end of result sets using the statement.closeOnCompletion function.

• It supports specifying return types using a class as the argument of the Resultset.getObject function.

JDBC 4.2 Standards

• It supports java.time.LocalDate, LocalTime, LocalDateTime, OffsetTime, and OffsetDateTime types.

• It supports specifying types using SQLType as the argument of the setObject and registerOutParameter functions.

• It supports returning the affected row count value in the long data type using the Statement.executeLargeUpdate function.

For more information, refer to "JDBC Standards" in Tibero JDBC Developer's Guide.

---

Updated Features

This section lists and briefly describes modified and improved key features.

DBMS Engine

DBMS_VERIFY

It supports DBMS_VERIFY for local partitioned indexes.

SYSTEM VIEW

– Added TYPE column for the following views.

• [DBA|ALL|USER]_TAB_PRIVS

• [DBA|ALL|USER]_TBL_PRIVS

• [ALL|USER]_TAB_PRIVS_MADE

DBMS_UTILITY

– Added the MAXNAME_ARRAY type in the DBMS_UTILITY package.

DBMS_XMLGEN

– Added the SETBINDVALUE procedure in the DBMS_XMLGEN package.

Client Drivers

Default Character Set

– Changed the default character set for client environments from MSWIN949 to UTF8. (Set the TB_NLS_LANG environment variable.)