Left over ORCH_WORK_ tables in the database

kishorenvkb · Post by **kishorenvkb** » Wed Aug 20, 2008 3:18 pm

Hello,

We have been running our Datastage jobs for a while now with Teradata as the target database.

On a routine check... we saw that the work database on Teradata is growing in size.

When looked we have a lot of tables starting with ORCH_WORK_ followed by some numbers.

Does anyone know what these are and why they are left behind?

Thanks

keshav0307 · Post by **keshav0307** » Thu Aug 21, 2008 12:08 am

The ORCH_WORK_XXXX table will not be dropped if the job abort.
similarly ORCH_ERR_XXXX will not be dropped if there are any error records.

shershahkhan · Post by **shershahkhan** » Thu Aug 21, 2008 3:17 am

ORCH_WRK_XXXX tables are working tables for Teradata Enterprise stage it use this table to load the load using fastload and then do insert select from this table to the final table, if the job aborts due to any reason these tables will not drop.

kishorenvkb · Post by **kishorenvkb** » Thu Aug 21, 2008 6:15 am

Makes sense. Thank you very much.