Informix

Informix

Connect with Db2, Informix, Netezza, open source, and other data experts to gain value from your data, share insights, and solve problems.

 View Only
Back to discussions
Expand all | Collapse all

error 106 when doing dbshema

  • 1.  error 106 when doing dbshema

    Posted Fri January 24, 2020 09:07 AM
    Hi,

    using IDS12.10FC13 on AIX
    database in no logging mode
    using compression

    When doing a dbschema on one database, i get this error :
    -242 - Could not open database table (informix.sysprocauth).
    -106 - ISAM error: non-exclusive access.

    working fineon another one.
    Nobody connected on this database.

    did a stop/start of the scheduler (i had some persistent locks problem in the pas with that).
    But don't solve the issue

    Trapped this error this morning. The executing request is following :
    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

    executing this request manually generates the same error.

    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 detected.

    somebody has an idea ?

    I will stop/start this instance this we.
    I have an af file and a shmem also.

    Regards

    ------------------------------
    Jean Francois BOUDRY
    ------------------------------

    #Informix