Skip to main content

Search

Welcome to Tibero GTS!

Improvement of dbms_verify Function Execution Result Notification

Document Type | Technical Information

Category | Monitoring/Inspection

Applicable Product Version | 6FS06

Document Number | TMOTI008

 

Overview

In the past, when using the binary (tibero6 FS07 CS1902 or earlier versions), there was no result message after performing the verify function, making it ambiguous whether it was executed correctly. This guide explains how to improve this. 
-- When executed on versions without a notification message: no indication if the execution succeeded or failed

SQL> set serveroutput on
SQL> exec DBMS_VERIFY.TABLE_INDEX('TIBERO','STAT_BACKUP');

PSM completed.





-- When executed on versions with notification message: you can see the message "xxxxx is ok!"

SQL> set serveroutput on
SQL> exec DBMS_VERIFY.TABLE_INDEX('TIBERO','STAT_BACKUP');
STAT_BACKUP (TIBERO.STAT_BACKUP) is ok!

PSM completed.

 

 
 

Method

Apply the patch to resolve the issue.
Caution
Apply the patch through technical support provided by Tmax Tibero.
-- Obtain the file $TB_HOME/scripts/pkg/_pkg_dbms_verify.tbw from the latest binary (CS_2005 or later)
-- Transfer this file to the current operating environment (CS_1902 or earlier)
-- Create
SQL> @_pkg_dbms_verify.tbw

-- Verify
SQL> select object_name, status from dba_objects where object_name = 'DBMS_VERIFY';

OBJECT_NAME STATUS 
--------------- -------
DBMS_VERIFY VALID
DBMS_VERIFY VALID
DBMS_VERIFY VALID

-- Check existing binary files
root@przn-0cf4af7c-hxpqp:/tibero/scripts/pkg# ls -al | grep ver
-rw-rw-r-- 1 500 500 8740 Jan 7 2021 _pkg_dbms_verify.tbw
-rw-r--r-- 1 500 500 462 Jan 7 2021 pkg_dbms_verify.sql

-- Check binary files to apply the patch
[tibero@pub1 pkg]$ ls -al | grep verify 
-rw-r--r--. 1 tibero dba 14136 May 24 15:41 _pkg_dbms_verify.tbw
-rw-r--r--. 1 tibero dba 716 May 24 13:01 pkg_dbms_verify.sql

-- You can confirm that the latest file is larger in size.
 
 
 
 
 

Related to