Oninit cdi / Archive
Talk to an expert →

NREADS

Posted in 2006

Topics: High Availability & Replication

Valeriano Villegas Juan — — source: IIUG Forums & Mailing Lists

Hi Masters: What is the SQL for retrieve nreads y nwrites like onstat -u IBM Informix Dynamic Server Version 7.31.UD7W4 -- On-Line -- Up 14 days 06:56: 38 -- 1465040 Kbytes Userthreads address flags sessid user tty wait tout locks nreads nwrites cd693018 ---P--D 1 informix - 0 0 0 29874 9147 cd6a1e08 ---P--B 50 informix - 0 0 0 6239 5033 cd6a2318 ---P--D 433 informix - 0 0 0 28058 17403 cd6b4dc8 B--PR-- 25127482 ssia5300 tMd 948e8624 0 1 447948 0 d2d488e8 --BPR-- 25076861 cdr - 0 0 125 2369393 11031 d5a9fa68 L--PR-- 25162028 cdr - 8c84d09c -1 4 71815 0 d5aa64b8 ---PR-- 24927803 portal01 - 0 0 2 1998154 2159 d5aab0a8 ---PR-- 25124814 gtacb657 tkc 0 0 1 4263 0 d5ab9478 ---PR-- 25067521 gtacb657 tNd 0 0 1 17460 183 b4de7b98 ---PR-- 24972580 psp03300 the 0 0 3 3355917 4380 b4df3bf8 Y-BP--- 25139818 psn43300 tcf dd590988 0 15 2423 216 b85a3628 ---PR-- 25066928 portal01 - 0 0 2 1007067 1607 d7b0c2e8 ---PR-- 25092638 portal01 - 0 0 1 520000 527 d7b164e8 ---PR-- 24898317 portal01 - 0 0 4 1414195 4027 d7b21618 B--PR-- 25142342 sscb3300 tbe 951863e4 0 2 146411 0 d7b27648 Y-BP--- 25069262 ppda1651 tbd da8e0988 0 13 61690 72 d993d0d8 --BP--- 24751047 pge00300 tIe 0 0 15355 19437342 1068131 0 db3bd5b8 B--PR-- 24765690 psn27300 tkd 9529d5e8 0 2 28408135 112 dd199cf8 ---PR-- 24618903 psce3300 tIb 0 0 2 30564052 18911 dd19e8e8 B--PR-- 25142958 sscb3300 tc 94d075d4 0 1 219405 0 e419d788 B--PR-- 25107340 sscb3300 tW 947a36ec 0 2 1009198 0 e41af308 ---PR-- 24978903 pscf2300 twc 0 0 1 601538 157304 1062 active, 1536 total, 1444 maximum concurrent THANKS IN ADVANCE

↪ replying to Valeriano Villegas Juan
ART KAGEL, BLOOMBERG/ 731 LEXIN — — source: IIUG Forums & Mailing Lists

The information is int sysmaster:syssesprof Art S. Kagel ----- Original Message ----- From: Valeriano V.... <ids@iiug.org> At: 5/08 19:10:06 Hi Masters: What is the SQL for retrieve nreads y nwrites like onstat -u IBM Informix Dynamic Server Version 7.31.UD7W4 -- On-Line -- Up 14 days 06:56: 38 -- 1465040 Kbytes Userthreads address flags sessid user tty wait tout locks nreads nwrites cd693018 ---P--D 1 informix - 0 0 0 29874 9147 cd6a1e08 ---P--B 50 informix - 0 0 0 6239 5033 cd6a2318 ---P--D 433 informix - 0 0 0 28058 17403 cd6b4dc8 B--PR-- 25127482 ssia5300 tMd 948e8624 0 1 447948 0 d2d488e8 --BPR-- 25076861 cdr - 0 0 125 2369393 11031 d5a9fa68 L--PR-- 25162028 cdr - 8c84d09c -1 4 71815 0 d5aa64b8 ---PR-- 24927803 portal01 - 0 0 2 1998154 2159 d5aab0a8 ---PR-- 25124814 gtacb657 tkc 0 0 1 4263 0 d5ab9478 ---PR-- 25067521 gtacb657 tNd 0 0 1 17460 183 b4de7b98 ---PR-- 24972580 psp03300 the 0 0 3 3355917 4380 b4df3bf8 Y-BP--- 25139818 psn43300 tcf dd590988 0 15 2423 216 b85a3628 ---PR-- 25066928 portal01 - 0 0 2 1007067 1607 d7b0c2e8 ---PR-- 25092638 portal01 - 0 0 1 520000 527 d7b164e8 ---PR-- 24898317 portal01 - 0 0 4 1414195 4027 d7b21618 B--PR-- 25142342 sscb3300 tbe 951863e4 0 2 146411 0 d7b27648 Y-BP--- 25069262 ppda1651 tbd da8e0988 0 13 61690 72 d993d0d8 --BP--- 24751047 pge00300 tIe 0 0 15355 19437342 1068131 0 db3bd5b8 B--PR-- 24765690 psn27300 tkd 9529d5e8 0 2 28408135 112 dd199cf8 ---PR-- 24618903 psce3300 tIb 0 0 2 30564052 18911 dd19e8e8 B--PR-- 25142958 sscb3300 tc 94d075d4 0 1 219405 0 e419d788 B--PR-- 25107340 sscb3300 tW 947a36ec 0 2 1009198 0 e41af308 ---PR-- 24978903 pscf2300 twc 0 0 1 601538 157304 1062 active, 1536 total, 1444 maximum concurrent THANKS IN ADVANCE ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.

Related threads

Glossary