How to check some information of onstat -l
Posted in 2020
Topics: Logging & Checkpoints, Versions, Editions & End-of-Life
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 KbytesPhysical 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
------------------------------
#Informix
A quick look at code seems to show that information doesn't appear to be externalized in the current sysmaster information. ------------------------------ Jacques Renaut ------------------------------
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 ------------------------------