Hi,

using IDS12.10FC13 on AIX

using compression

database in no logging mode

When doing a dbschema on this database, i get the following error :

-242 - Could not open database table (informix.sysprocauth).
-106 - ISAM error: non-exclusive access.

after a stop/start of scheduler, same behaviour (i got some problems of persistant locks due to tasks in scheduler).

nobody connected on this database

trapped error and request generating the error is this one :

Current statement name : authcur0

Current SQL statement (105838) :
select a.owner, a.procname, a.procid, b.grantor, b.grantee, b.procauth
from informix.sysprocedures a, informix.sysprocauth b where a.procid =
b.procid and (a.mode = 'O' OR a.mode = 'D' OR a.mode = 'R') order by
a.procid

when executing it manually, i have the same problem.

list of locks in af file : 

/informix/inst0003/bin/onstat -k:

IBM Informix Dynamic Server Version 12.10.FC13 -- On-Line -- Up 55 days 20:07:58 -- 32208032 Kbytes

Locks
address wtlist owner lklist type tblsnum rowid key#/bsiz
70000001037a328 0 7000000642c13e8 0 HDR+S 100002 204 0
7000000103e0190 0 70000006e076ee8 70000002eb58860 HDR+S 100002 201 0
70000002e6f5ed0 0 700000054044128 0 S 100002 204 0
70000002e6fc558 0 70000005400c4a8 0 S 100002 204 0
70000002e70f7e0 0 70000002515e028 0 S 100002 204 0
70000002e860238 0 700000025174fa8 0 S 100002 204 0
70000002e8cdf98 0 70000004cc5c628 0 S 100002 204 0
70000002e8f4970 0 70000004cc663a8 0 HDR+S 100002 60b 0
70000002eb58860 0 70000006e076ee8 0 S 100002 204 0
70000002ec6c3e0 0 70000004cc663a8 70000002e8f4970 S 100002 201 0
70000002ec84fa8 0 70000004cc90568 0 S 100002 204 0
11 active, 160000 total, 16384 hash buckets, 3 lock table overflows

So no lock on this table.

Does somebody have an idea ?

I will stop/restart the instance this we to solve.

Regards