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
  • 1.  Dostats

    Posted yesterday
    

     

    Hi, Art,

    Recently, We found somehow our dostats running could ask Informix to add quite some extra virtual memory segments , 


    1) Online log.


    07/05/2026 22:18:31   Dynamically allocated new virtual shared memory segment (size 8000000KB)

    07/05/2026 22:19:47   Dynamically allocated new virtual shared memory segment (size 8000000KB)

    07/05/2026 22:22:52   Dynamically allocated new virtual shared memory segment (size 8000000KB)

    07/05/2026 22:27:34   Dynamically allocated new virtual shared memory segment (size 8000000KB)

    07/05/2026 22:28:41   Dynamically allocated new virtual shared memory segment (size 8000000KB)

    07/05/2026 22:31:10   Dynamically allocated new virtual shared memory segment (size 8000000KB)

    07/05/2026 22:33:17   Dynamically allocated new virtual shared memory segment (size 8000000KB)

    07/05/2026 22:34:29   Dynamically allocated new virtual shared memory segment (size 8000000KB)

    07/05/2026 22:35:38   Dynamically allocated new virtual shared memory segment (size 8000000KB)


    2)  onstat -g seg

     

    IBM Informix Dynamic Server Version 14.10.FC8XO -- On-Line -- Up 4 days 18:55:52 -- 115673060Kbytes

    2026-07-10 13:18:27

     

    Segment Summary:

    id         key        addr             size             ovhd     class blkused  blkfree

    18         52614801   44000000         569851904        7119592  R     139124   0

    19         52614802   65f74000         10240000000      120001944 V     230843   2269157

    20         52614803   2c8514000        33911361536      1        B     8279141  0

    21         52614804   aad979000        8192000000       96001896 V     24908    1975092

    22         52614805   c95df9000        8192000000       96001896 V     24674    1975326

    23         52614806   e7e279000        8192000000       96001896 V     24599    1975401

    24         52614807   10666f9000       8192000000       96001896 V     24243    1975757

    25         52614808   124eb79000       8192000000       96001896 V     24132    1975868

    26         52614809   1436ff9000       8192000000       96001896 V     24000    1976000

    27         5261480a   161f479000       8192000000       96001896 V     23815    1976185

    28         5261480b   18078f9000       8192000000       96001896 V     23686    1976314

    29         5261480c   19efd79000       8192000000       96001896 V     23538    1976462

    Total:     -          -                118449213440     -        -     8866703  20051562

     

       (* segment locked in memory)

    No reserve memory is allocated

     

    3) our dostats version,


    dostats -V

     

    dostats_ng: Features Version 7.00 - NG, Source Revision: 1.61 !

            Copyright 2009 - 2016 by Art S. Kagel.

            License for private usage (including use by commercial enterprise

            for its own needs) is granted.  Commercial and exploitation rights   are reserved.



    The server  is not busy, not much other jobs running there. 


    Any tips or suggestions?


    Thanks a lot!

    Frank 



  • 2.  RE: Dostats

    Posted yesterday

    Frank:

    Let's take this discussion offline. Reach out to me via email (art.kagel@gmail.com) and send me your ONCONFIG file for me to look over. Also, what release of Informix are you using on what platform?

    Also the release of dostats you have to more than 9 years old. The current release is 1.92 which you can download as part of the utils2_ak package from my web site: My Utilities

    Art



    ------------------------------
    Art S. Kagel, President and Principal Consultant
    ASK Database Management Corp.
    www.askdbmgt.com
    ------------------------------