Column analysis Error

vinu1103sharma · Post by **vinu1103sharma** » Mon Jun 01, 2015 11:21 am

We are not able to Column analysis on entire table; therefore we are running it column by column. Request you to suggest if there is any alternate way or if we are missing any setting.

rjdickson · Post by **rjdickson** » Mon Jun 01, 2015 2:03 pm

Hi,
It sounds like you may be overloading your server. Try enabling Workload Manager (WLM). You can restrict how many jobs get submitted at a time.

I hope this helps!
Robert

ray.wurlod · Post by **ray.wurlod** » Mon Jun 01, 2015 3:07 pm

Perhaps also choose a sample for your initial analysis, and select the option not to profile columns over 500 characters.

As they put it in the training class for IA: "don't try to boil the ocean".

qt_ky · Post by **qt_ky** » Tue Jun 02, 2015 2:32 pm

Out of curiosity, what is the error you get?