Record locking in Netware
Posted in 2000
Topics: General Discussion
I am using a VERY old version of Informix under Netware. I am almost embarrased to say that the Informix SQL version is 2.10.0.6E. We are moving to a new Informix platform but this legacy system we use is still around at quite a few places. My question relates to how Informix record locking works in conjunction with Netware. I have been trying to resolve some problems with a very old version of an Informix db to do with file / record locking. At some times no-one can access the db becuase 1 user has a table locked. I cannot see who as a number of users have it open. This ususally happens because a certain users PC (running windows) may have crashed. To fix this they need to find this particular PC and reset it. When the Netware connection logs in again all is well for the other users. When I look in Netware monitor for a user it reports that a number of the index tables have record locks. The offset / position of this lock is the same in each index table? Does this offset relate to some other file / structure. Is there a utililty to see exactly who has a file / record lock and the status? If I could find the individual users who has the table locked (lots have the table open but only one is actually causing the lock problem) we could pin pint that PC to fix it. The database I am looking at has DAT and IDX files for the various tables. It also has "system" tables in the same format (DAT and IDX files) to hold table, column, index and other information for the DB. What happens for example is that when I start up a programme that accesses the database I will see that some tables are opened and the SYSTABLE.IDX file gets a record lock of hex 40000852 to 40000852. no other tables as yet are locked. When I then do a search for a patient I see that the patient table files are opened and the patient idx file also then gets a lock of hex 40000852 to 40000852. A temporary table is created (SAAA130.DAT / IDX) with a lock on hex 40000000 to hex 4000FFFF (64K. Same as Novell block size??). If I open other tables I see the same pattern. The actual table idx file gets a lock of 40000852 and the temp file gets the 64K lock. What files / offsets are these actually referring too?