error 106 when doing dbshema

| view attached 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 KbytesLocks 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

oncheck -cc didn't raise any error ------------------------------Jean Francois BOUDRY ------------------------------

Hi, Do you get 106 errors when you stop the scheduler and run dbschema? ------------------------------ SangGyu Jeong Software Engineer Infrasoft Seoul Korea, Republic of ------------------------------

I'm still not having a clue why such query needed exclusive access. But that also was the case when discovering APAR IT29239 ... which indeed might be your problem. To verify you're running into this problem check 'onstat -T' for partitions carrying 'flgs' 20 (this is 0x20). A restart would fix this, next fixpack (12.10.FC14) will fix it for good. ------------------------------ Andreas Legner ------------------------------

i found one line with this flag 28499 7000000288ca028 20 0 507075 5:26587316 64 37 12 614 4 but didn't identify yet what table it is. I will stop/restart the instance this we. So probably it will be ok Thanks ------------------------------ Jean Francois BOUDRY ------------------------------

Download Art Kagel's myschema, which is part of "utils2_ak", which you can find in the IIUG member area. It doesn't require the exclusive locks. Also, myexport can replace dbexport, without using exclusive locks. It also runs faster, with more options. --EEM

yes, i tried but without success thanks ------------------------------ Jean Francois BOUDRY ------------------------------

This is how to download utils2_ak from Art's website:

thx, i will try on monday. I already downloaded it, but have some problems to compile it on AIX. I will try, but when executing the simple select request manually, i also have the same problem, probably i will have also with myschema. As i will stop/start the instance this we, problem will disapear (i hope). But i would like to get these utilities, i will continue to try to compile. Thanks ------------------------------ Jean Francois BOUDRY ------------------------------

Jean: Again, if you have trouble compiling on AIX reach out to me directly (my email address is in the package and also on my web site) and I can help. The biggest difficulty with compiling on AIX is that there are three different compilers with different options and using GCC requires one to modify the esql script! Art Art S. Kagel, President and Principal Consultant ASK Database Management www.askdbmgt.com Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves.

Hi Andreas, Thank you for your help. Just for information, stop/start of informix instance solved the issue. Regards ------------------------------ Jean Francois BOUDRY ------------------------------