C-ISAM File Locking Problems

We have just released a new version of our software and we are getting considerable 'waiting on lock problems'. We suspect there may be even some deadlocking problems, but we are having difficulty tracking down the problem programs ( there are about 2000-3000 programs in total). The other complicating factor is that there are about 100+ users on a system at the same time. We have an idea of the files that are being locked but do not know the programs. Our customers run UNIX AIX 4.3* on IBM H50 machines. Ideally we need a utilty to monitor these problem files and if they are locked by the same person for a set time period then a warning needs to be written to a log with the persons id who is locking the file. If there are not any utilties that do this, does anyone know how a C-ISAM file gets 'flagged' when it is locked. Maybe I can just check for this flag? One other problem is that I know nothing about C programming, so C programs (unless allready written) will mean nothing to me. Also does anyone knows of any utilities that allow us to defragment the files. With this I mean that when we delete a record on C-ISAM the size of the data file stays the same. We wish to have a weekly utility that is run that clears down deleted records. Any help on this, however small, will be gratefully accepted. Regards, Robert Sant Sent via Deja.com http://www.deja.com/ Before you buy.