Netezza Connector- Temp Tables - Not Dropped Automatically
Posted: Tue Apr 21, 2015 6:36 am
Hi,
We are using Netezza Connector stage to load data to a Netezza Table using nzload. I have noticed when the job fails, since Netezza extensively uses External Tables, tables named like "NZCC_20150417154349152486_7252_1" are created bur NOT dropped even if we select the option "Temporary Work Table Mode" = Automatic" and "Drop Table" = Yes
Any way we can ensure such intermediate temp tables gets dropped, irrespective of whether the Datastage job fails or succeeds as we do not want these meaningless tables sitting in the Database?
Thanks,
NV
We are using Netezza Connector stage to load data to a Netezza Table using nzload. I have noticed when the job fails, since Netezza extensively uses External Tables, tables named like "NZCC_20150417154349152486_7252_1" are created bur NOT dropped even if we select the option "Temporary Work Table Mode" = Automatic" and "Drop Table" = Yes
Any way we can ensure such intermediate temp tables gets dropped, irrespective of whether the Datastage job fails or succeeds as we do not want these meaningless tables sitting in the Database?
Thanks,
NV