NZORCH tables not getting Dropped Post DS Job execution

palak08 · Post by **palak08** » Mon Mar 26, 2012 8:37 am

Hi All,

We are using Datastage with Netezza Combination. We use Netezza Enterprise stage to load data in Netezza tables.
While loading data, Datastage creates external tables in between the process. These tables have names starting with 'NZORCH'. Even after the process finish successfully, DS do not clean up these tables. Is there an option to clear these tables post execution of DS job?

Thanks in Advance for any help on this issue!

mobashshar · Post by **mobashshar** » Mon Mar 26, 2012 9:12 am

Hi,
When you load NZ tables with Load Method = ET, then it creates External Tables which you have to clean manually. Please use Load Method - nzload and you will solve the issue.
M.

palak08 · Post by **palak08** » Mon Mar 26, 2012 11:19 pm

Thanks Mobashshar for the reply. We are using nzload in all our jobs. Still to give it a try, I changed the option to ET and it did not create any External table.

Can there be something else causing this issue?

Thanks Again!