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.