Re: unexpected table lock

>>> In my opinion the DBSA has to be able to monitor the >>> status of a table at all times. >>> How do you think about it? >>> >> if that is the case and your apps fall over then: >> >> set isolation to dirty read; >Yes but the results may be wrong >I'm searching for a list of adminstrative task and the implied lock modes. >Didn't find anything in the manuals. Has this table been recreated recently and without row-level locking? You may be hitting a page-level lock (default), blocking your access. Run dbschema -t tablename -ss -d databasenameto view the locking leveling you are using. ________________________________________________________________________ Check Out the new free AIM(R) Mail -- 2 GB of storage and industry-leading spam and email virus protection.