View Data fails for large number of records

Amos.Rosmarin · Post by **Amos.Rosmarin** » Tue Oct 10, 2006 1:11 pm

Hi,

When I do view-data on a small number of rows it looks fine, but when the number increases (and I talk of 100s not millions) the view data fails and the client crushes (connection brakes).

I guess it has something to do with the machines memory settings in the Windows registry (SharedSection) .
The problem began since a Tivolli agent was installed on the ETL machine.

Has anyone seen this before ?

Thanks
Amos

ray.wurlod · Post by **ray.wurlod** » Tue Oct 10, 2006 2:05 pm

Do you get any error message?

I suspect that the client machine is running out of memory. Monitor memory usage (Task Manager, always on top) when attempting a large View Data.

Amos.Rosmarin · Post by **Amos.Rosmarin** » Tue Oct 10, 2006 2:15 pm

Thanks Ray,

I do get an error message of cennection was broken ... (don't have it with me right now)

It happeneds on all clients (more then 10 + one on the server machine) but I think it is not a client problem but it's in the server: When I do view-data the _slave process is killed so the client pops up a message becasue it looses it's connection.

Are you familliar with the SharedSection registry settings ?

Thanks
Amos