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.

Comments