Informix

nested-group-icon.png

DB2

Expand all | Collapse all

How to check some information of onstat -l

  • 1.  How to check some information of onstat -l

    Posted 21 days ago
    Edited by SangGyu Jeong 21 days ago
    Hello All,
    I see Log Space Used for each Subsystem entry (OLDRSAM / SBLOB / HA / DDL) in onstat -l, does the same information exist in the sysmaster database?


    IBM Informix Dynamic Server Version 12.10.FC12W1XC -- On-Line -- Up 55 days 01:50:25 -- 4490888 Kbytes Physical Logging Buffer bufused bufsize numpages numwrits pages/io P-2 187 256 297 3 99.00 phybegin physize phypos phyused %used 2:53 16357 3935 473 2.89 Logical Logging Buffer bufused bufsize numrecs numpages numwrits recs/pages pages/io L-1 0 128 11162 616 229 18.1 2.7 Subsystem numrecs Log Space used OLDRSAM 11161 957128 HA 1 44 address number flags uniqid begin size used %used 47fe6a60 7 U-B---- 436 3:53 1536 1536 100.00 47fe6ac8 8 U-B---- 437 3:1589 3074 3074 100.00 47fe6b30 9 U-B---- 438 3:4663 3074 3074 100.00 47fe6b98 1 U-B---- 439 3:7737 3074 3074 100.00 47fe6c00 2 U-B---- 440 3:10811 3074 3074 100.00 47fe6c68 3 U-B---- 441 3:13885 3074 3074 100.00 47fe6cd0 4 U-B---- 442 3:16959 3074 3074 100.00 47fe6d38 5 U---C-L 443 3:20033 3074 1218 39.62 47fe6da0 6 U-B---- 433 3:23107 3074 3074 100.00 47fe6e08 10 U-B---- 434 3:26181 3074 3074 100.00 47fe6e70 11 U-B---- 435 3:29255 3074 3074 100.00 11 active, 11 total​
    ------------------------------
    SangGyu Jeong
    Software Engineer
    Infrasoft
    Seoul Korea, Republic of
    ------------------------------


  • 2.  RE: How to check some information of onstat -l

    Posted 21 days ago
    A quick look at code seems to show that information doesn't appear to be externalized in the current sysmaster information.

    ------------------------------
    Jacques Renaut
    ------------------------------



  • 3.  RE: How to check some information of onstat -l

    Posted 21 days ago
    Thanks Jacques.
    I am a bit frustrated that there is no explanation for the subsystem in the knowledge center. Hope it will be updated later.

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