Information Analyzer

RaviReena · Post by **RaviReena** » Mon Sep 29, 2008 6:29 pm

We installed the Info Server 8.0.1(Information Analyzer) and loaded the data to the DB2 Table come with it. I tested the connectivity to default database(iadb) using example and it is working fine and tested the connection with Information Analyzer which is successful.

But when we run the column analysis on the table it is running for ever and finally i deleted the job.

Any ideas about the best way to test the Information analyzer Column analysis with a sample data.

Thanks.

ray.wurlod · Post by **ray.wurlod** » Mon Sep 29, 2008 8:14 pm

Clearly it is not "running forever" not least because you killed it. Column analysis is the most computationally and I/O intensive analyses that IA performs - you must allow it to finish. I have had column analyses run hours, even tens of hours. For large data sets, we run them over the weekend.

Aruna Gutti · Post by **Aruna Gutti** » Tue Sep 30, 2008 7:50 am

Yes. The column analysis jobs do tend to run for several hours depending on the volume of data and number of fields.

But instead of killing your job, you can check the status of the column analysis jobs on Director by selecting 'ANALYZERPROJECT' project.

By checking the status of column analysis jobs scheduled by Information analyzer you can know whether there is any issue or not.

RaviReena · Post by **RaviReena** » Tue Sep 30, 2008 8:13 am

Aruna Gutti wrote:Yes. The column analysis jobs do tend to run for several hours depending on the volume of data and number of fields.

But instead of killing your job, you can check the status of the column analysis jobs on Director by selecting 'ANALYZERPROJECT' project.

By checking the status of column analysis jobs scheduled by Information analyzer you can know whether there is any issue or not.

I just verified the director , no job is created for my project. What could be the possible problem?

Aruna Gutti · Post by **Aruna Gutti** » Tue Sep 30, 2008 10:04 am

Check and see what kind of errors you are getting in iashandler.log. You can find these logs in '/usr/WebSphere/AppServer/profiles/default' directory.

Also you can check for any errors in Client directory 'C:\IBM\InformationServer\Clients\ISC'.

Either of these logs should tell you what is the exact issue.

RaviReena · Post by **RaviReena** » Wed Oct 01, 2008 11:13 am

We applied the rollup patch 12 for server and client and it is started working fine. Again thanks for info to check the iashandler.log