Re: Wierd problem

> We have a home-grown, UNIX-based configuration management (CM) system > builtusing shell scripts, SCCS and make. We use this system not only to > configureand build software loads, but also to build test databases. > This allows eachengineer to easily build a test database for the > specific feature to be tested. > > Lately, we've encountered a problem whereby the building of a test > databasehangs. Re-tries also hang - at exactly the same point. Logical > logs arenot full, ovbuff = 0, nobody's waiting for any locks. However, > the hungprocess is sometimes waiting for a latch and other times waiting > for a buffer. Being relatively new to Informix, I don't know what else > to check. It could be that you are waiting for access to the table of databases or the table of tables- the infamous partition partition. If a lot of this work is happening at the same time these internal tables within Online can be the cause of bottlenecks. I know this problem quite well as I run training courses and this seems to be an annoying intermittent problem. > > Anybody recognize these symptoms and know what to do about it? Any help > would be greatly appreciated. > > Roger Tomas > AG Communication Systems > Malcolm Weallans Online Database Consultancy Phone 01628-72154 Fax 01628-37463 CIX - onlinedbc