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
View Data fails for large number of records
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 385
- Joined: Tue Oct 07, 2003 4:55 am
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Premium Member
- Posts: 385
- Joined: Tue Oct 07, 2003 4:55 am
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
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