Problem: RELEASE MLOAD Test.target_table IN APPLY; RELEASE MLOAD Test.target_table IN APPLY; *** Failure 7445 Mload table Test.target_table cannot be released be cause fallback exists. See manual to release MLoad lock in Apply for fallback table. Statement# 1, Info =0 *** Total elapsed time was 1 second.
Reason: Customer is running production environment on TD15.10 on fully fallback systems(e.g Intelliflex) and MLOADs was aborted in APPLY phase. As a consequence, customer cannot issue RELEASE MLOAD xx.yy IN APPLY as it fails with Error 7445 (or even 2572 if they try RELEASE MLOAD xx.yy).
Solution: BTEQ -- Enter your SQL request or BTEQ command: create table Test.dummy_table as Test.target_table with no data;
*** Table has been created. *** Total elapsed time was 1 second.
BTEQ -- Enter your SQL request or BTEQ command: locking table Test.target_table for access insert into Test.dummy_table select * from Test.target_table;
locking table Test.target_table for access insert into Test.target_table select * from Test.target_table; *** Insert completed. 1694073 rows added. *** Total elapsed time was 5 seconds.
BTEQ -- Enter your SQL request or BTEQ command: drop table Test.target_table; drop table Test.target_table;
*** Table has been dropped. *** Total elapsed time was 1 second.
BTEQ -- Enter your SQL request or BTEQ command: rename table Test.dummy_table as Test.target_table; rename table Test.dummy_table as Test.target_table;
*** Table has been renamed. *** Total elapsed time was 1 second. |