remove fastload lock

[mikin]

Hi, I need help with fastload. I want to remove lock on a table which was fastloaded and fastload fails (record were wrong). If the fastload fails, than the table is locked and you can't work with it. Error is: RDBMS error 2652: Operation not allowed: _db_._table_ is being Loaded.

I know, that one solution is to drop-create the table, but I don't find that nice to use it in the production. Do you have any idea, how to remove locks.

Thanks for any idea.
--petr

 

[al1x24]

The first way I use to unlock a mis-fastloaded table is to close the fastload operation on this table with an empty fasload command.

fastload <<-!Eof >> ${LOG_FILE} 2>&1
logon ${DWHTDP}/${DWHUSR},${DWHPWD} ;
begin loading ${TBL_BASE}.${TBL_NAME}
errorfiles ${TBL_BASE}.${TBL_NAME}_ER1
, ${TBL_BASE}.${TBL_NAME}_ER2
;
end loading ;
logoff ;
!Eof

 

[al1x24]

Before using the DROP solution, try to close your already opened fastload session :

logon ... ;
begin loading	...
errorfiles	..., ... ;
end loading ;
logoff ;

In most cases, it's enough to unlock your tables.