Chapter 5. Tibero 6 FixSet04

Table of Contents

5.1. New Functions
5.1.1. DBMS Engine
5.1.2. Client Drivers
5.1.3. Utilities
5.2. Modified Functions
5.2.1. DBMS Engine
5.2.2. Utilities

This chapter describes functions added to or modified in Tibero 6 FixSet04.

5.1. New Functions

The following describes new functions added to Tibero 6 FixSet04.

5.1.1. DBMS Engine

The following functions have been added.

  • Cache

    • Can perform Scattered Multi-Block Read (MBR) for blocks that do not exist in a buffer cache after copying them to PGA through AIO.

    • Added the Flashback Database function that recovers an entire database to a specific TSN.

  • Tibero Cluster Manager (TBCM)

    • Removed the -n option from the tbcm command.

      Note

      For more information, refer to "Chapter 9. Tibero Cluster Manager" in Tibero Administrator's Guide.

  • Tibero Active Cluster (TAC)

    • Added the "ALTER SYSTEM SWITCH LOGFILE GLOBAL" statement.

  • Tibero Standby Cluster (TSC)

    • Can create a Standby DB without stopping a database by performing a hot (online) backup.

    • Displays a hotfix patch applied to Tibero in a TPR report.

  • Tibero Performance Repository (TPR)

    • Can create a TPR report every hour.

    • Can create a report about a user-specified snapshot.

      Note

      For more information, refer to "Chapter 14. Tibero Performance Repository" in Tibero Administrator's Guide.

  • Data Definition Language (DDL)

    • Added the ACTION column to DBA|ALL|USER_AUDIT_TRAIL views.

    • Added flashback-related DDL statements.

      Note

      For more information, refer to Tibero SQL Reference Guide.

  • PSM

    • Added the UTL_RECOMP package.

    • Added the DBMS_LOB.LOADFROMFILE procedure.

    • Added the FORALL statement to run a dynamic DML statement multiple times.

  • system.sh Script

    • Can record the start time of executing the system.sh script.

    • Added the -e option to find script errors that can occur when executing system.sh.

    • Added the Temp Tablespace Shrink function for tablespaces.

  • DB Link

    • Displays a dump about PGA memory allocation used by libraries when linking databases.

  • Executor

    • Added the SESSIONTIMEZONE function.

    • Support functions for object tables.

    • Can use a member function for object tables.

    • Can transform WGS84 coordinates.

  • Optimizer

    • Can unnest subqueries in the select list when executing the "INSERT INTO SELECT" statement.

  • Parser

    • Added functions for Japanese lexer.

  • Character Set

    • Displays Tibero character sets that are shown as the result of "tbboot -C".

  • Packages

    The following packages have been added.

    • DBMS_SERVER_ALERT package

    • DBMS_MONITOR package

    • DBMS_SERVER_ALERT package

  • Parameter

    The following parameters have been added.

    ParameterDescription
    AS_ADDRIP address of the TAS instance accessed by Tibero instance.
    FLASHBACK_LOG_ARCHIVE_ FORMATFlashback database archive log format.
    PSM_ERROR_CONVOption to automatically convert errno to user-specified error number when compiling PSM.
    USE_ACTIVE_STORAGEUSE_TAS used in previous versions is renamed to USE_ACTIVE_STORAGE.
    USE_RESOURCE_MANAGEROption to use instance caging.

    The following parameters have been removed.

    ParameterDescription
    USE_TASRenamed to USE_ACTIVE_STORAGE.
    CM_NODE_IDRemoved because TBCM no longer manage membership manually.
    CM_NODESRemoved because TBCM no longer manage membership manually.

5.1.2. Client Drivers

The following function has been added.

  • JDBC

    • Added the function that encrypts login passwords.

5.1.3. Utilities

The following functions have been added.

  • tbExport

    • Added the COMPRESS parameter (default value: N) that can allow to perform export and compression in parallel.

    • Can export libraries.

  • tbImport

    • Added the function that imports libraries.

5.2. Modified Functions

The following describes functions modified in Tibero 6 FixSet04.

5.2.1. DBMS Engine

The following functions have been improved.

  • Data Definition Language (DDL)

    • The maximum number of columns in a table is changed from 1000 to 1500.

  • Data Layer

    • Can merge indexes created by "CREATE INDEX" for non-NUMBER and non-VARCHAR columns.

  • Executor

    • Can perform a full table scan with Multi Block Read Count that has a changeable value, not a fixed value, such as 1, 2, and 4 regardless of the rownum condition.

  • Tibero Active Storage (TAS)

    • Establishes only one connection when Tibero accesses a TAS instance.

    • Added the DMON (Disk Monitor) thread to periodically try to perform disk I/O. If the I/O fails, the disk status becomes FAIL.

5.2.2. Utilities

The following functions have been improved.

  • tbExport

    • Can export materialized view indexes.

  • tbMigrator

    • Migrates Boolean data in PostgreSQL tables to the 't' or 'f' character.

  • tbSql

    • NCHAR columns refer to the TB_NLS_NCHAR environment variable.