Hello, I posted this to info-ingres back in December but did not get a reply. The posting got buried in in some sort of poltical spam.
ivm - Ingres visual manager - is continually scanning slow_v4.mnx. About 60 times per second. To see the problem go into task manager, Select view, select columns. Select the Read I/O options. Level 1 support has seen the problem where Level 2 cannot reproduce it. It happens in Ingres 2.6 sp2 but only about 1/5 the rate in R3. Has anyone else has noticed this behaviour or do you know if if there was a fix done in R3 Paul Original posting... Task manager shows IVM is chewing up a huge amount of I/O. It is reproducible on WinXP and Win2000 - three different machines - with and without the Ingres DB installed. It is performing more I/O than any other process including the ingres database server. Level 1 support cannot see the problem, I have it on 3 machines. Machine 1. XP Ingres, gateway and OpenROAD installed, All running. Machine 2. 2000 Ingres and OpenROAD installed. Ingres Net running only. Machine 3 Ingres and OpenROAD installed (from ORSP3). Only ivm running. Process I/O I/O / Machine Reads Bytes Machine 1 iidbms 122078 94269467 ivm 709855 1450042134 Machine 2 ivm 2740202 5592159491 Machine 3 (after running 30 min) ivm 62412 127996950 Using NTfilemon from www.sysinternals.com <http://www.sysinternals.com> I discovered ivm is repeatedly reading slow_v4.mnx. I think this is where the performance problem is. Here is an example: filemon.log 5:04:25 PM ivm.exe:1496 OPEN C:\IngresII\ingres\files\ SUCCESS Options: Open Directory Access: All 5:04:25 PM ivm.exe:1496 DIRECTORY C:\IngresII\ingres\files\ SUCCESS FileBothDirectoryInformation: config.log -:04:25 PM ivm.exe:1496 CLOSE C:\IngresII\ingres\files\ SUCCESS 5:04:25 PM ivm.exe:1496 READ C:\IngresII\ingres\files\english\slow_v4.mnx SUCCESS Offset: 0 Length: 2048 5:04:25 PM ivm.exe:1496 READ C:\IngresII\ingres\files\english\slow_v4.mnx SUCCESS Offset: 2048 Length: 2048 5:04:25 PM ivm.exe:1496 READ C:\IngresII\ingres\files\english\slow_v4.mnx SUCCESS Offset: 2060288 Length: 2048 The last 3 entries are repeated around 60 times then the cycle repeats in around 2-3 seconds. Paul Paul White Peerless IT Pty Ltd 21 Evans Street, Braybrook VIC 3019 Phone : 03 9214 7777 Mobile : 0414 681 799 Fax : 03 9318 5870 Internet : www.peerlessit.com.au _______________________________________________ Users mailing list Users@ingres.ca.com http://ingres.ca.com/mailman/listinfo/users
