Informix

 View Only
Expand all | Collapse all

error 106 when doing dbshema

  • 1.  error 106 when doing dbshema

    Posted Fri January 24, 2020 09:06 AM
      |   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 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

    Attachment(s)

    gz
    af.ba07a92b.gz   2.31 MB 1 version


  • 2.  RE: error 106 when doing dbshema

    Posted Fri January 24, 2020 09:19 AM
    oncheck -cc didn't raise any error

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

    Original Message


  • 3.  RE: error 106 when doing dbshema

    IBM Champion
    Posted Fri January 24, 2020 10:41 AM
    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
    ------------------------------

    Original Message


  • 4.  RE: error 106 when doing dbshema

    Posted Fri January 24, 2020 11:18 AM

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

    Original Message


  • 5.  RE: error 106 when doing dbshema

    Posted Mon January 27, 2020 05:36 AM

    Hi Andreas,

    Thank you for your help.

    Just for information, stop/start of informix instance solved the issue.

    Regards



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

    Original Message


  • 6.  RE: error 106 when doing dbshema

    Posted Fri January 24, 2020 11:19 AM

    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

     




    Original Message


  • 7.  RE: error 106 when doing dbshema

    Posted Fri January 24, 2020 11:25 AM

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

     

    Art Kagel

    Sep 18, 2019 9:14 AM

    Art Kagel

    I have uploaded another release of utils2_ak. New items in the September 17 release are:

    myschema:
    Added support for the new TSTAMP distinct type.
    Added support for the new Partial Index feature in v14.10.FC2!
    Added support for storagepool commands to the --infrastructure output.
    Moved UDT definitions to the primary file (needed for myexport).
    Fixed security policy display.

    Dostats_ng.ec:
    Fixed the display of the time processing each object ends.

    You can download the latest from: www.askdbmgt.com/my-utilities.html


    ------------------------------
    Art Kagel
    ------------------------------

     

     




    Original Message


  • 8.  RE: error 106 when doing dbshema

    Posted Fri January 24, 2020 11:33 AM

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

    Original Message


  • 9.  RE: error 106 when doing dbshema

    IBM Champion
    Posted Fri January 24, 2020 12:28 PM
    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


    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.






    Original Message


  • 10.  RE: error 106 when doing dbshema

    Posted Fri January 24, 2020 10:40 AM
    Hi, Do you get 106 errors when you stop the scheduler and run dbschema?

    ------------------------------
    SangGyu Jeong
    Software Engineer
    Infrasoft
    Seoul Korea, Republic of
    ------------------------------

    Original Message


  • 11.  RE: error 106 when doing dbshema

    Posted Fri January 24, 2020 11:19 AM

    yes, i tried but without success

    thanks



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

    Original Message