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.
CautionApply 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.