7445 Mload table XXXXX cannot be released be release because fallback exists

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.