Hi, when doing a dbshema on a database (nobody connected on it), i get the following error
-242 - Could not open database table (informix.sysprocauth).
-106 - ISAM error: non-exclusive access.
working on 12.10FC13 version on AIX.
database is in no logging mode and this specific instance is for development purpose.
using compression.
Trapped the error and the request executing is :
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
whe executing manually this request, i have the same error.
No locks on this table :
/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
I stopped then restart the scheduler because i already had some issues like that, but nothing solved.
I will probably stop/restart the instance this we.
Does somebody have an idea ?
attached the af file
Regards
------------------------------
Jean Francois BOUDRY
------------------------------
#Informix