Different output of onstat -g opn in version 11.70

Hi, I have noticed that the ouput of onstat -g opn is different according version of informix server: Versión 11.50 (FC8) and 12.1 (FC4) show the output in the following format: tid rstcb isfd op_mode op_flags partnum ucount ocount lockmode 78 0x0000000044d76768 267 0x00060000 0x00000403 0x0010009c 1 0 0 0 78 0x0000000044d76768 268 0x00060000 0x00000403 0x0010009b 1 0 0 0 110 0x0000000044d7ad68 0 0x00000400 0x00000297 0x001001c1 2 2 9 1 110 0x0000000044d7ad68 1 0x00000002 0x00000117 0x001001c1 2 2 9 0 110 0x0000000044d7ad68 2 0x01000440 0x00000403 0x0010004f 2 0 9 0 but versión 11.70 (FC8W1) shows a different output: rstcb c00000003a3bdcf8 tid 26 isfd op_mode op_flags partnum ucnt ocnt lk ra partp ocnt ucnt 125 0000000000060000 0000000000000403 00000000001000bc 1 0 0 c00000003ceac028 2 4 126 0000000000060000 0000000000000403 0000000000100134 1 0 0 c00000003cec3028 0 1 127 0000000000060000 0000000000000403 000000000010046f 1 0 0 c00000003caa0028 0 2 128 0000000000060000 0000000000000403 00000000001000cc 1 0 0 c00000003cf3e028 0 2 rstcb c00000003a3be568 tid 91 isfd op_mode op_flags partnum ucnt ocnt lk ra partp ocnt ucnt 0 0000000000000400 0000000000000297 0000000000100168 2 2 61 c00000003c4f37f0 1 1 1 0000000000000002 0000000000000003 0000000000100168 2 2 0 c00000003c4f37f0 1 1 2 0000000000000400 0000000000000297 00000000001001fb 2 2 61 c00000003c919028 189 189 3 0000000000000002 0000000000000003 00000000001001fb 2 2 0 c00000003c919028 189 189 5 0000000001000400 0000000000000413 000000000010046c 2 0 X 1 c00000003ce7c4b8 1 2 6 0000000001000400 0000000000000413 000000000010046c 2 0 X 1 c00000003ce7c4b8 1 2 I have scripts that are based in onstat -g opn, and were built for 7.31 and work in 11.50 FC8 but in 11.70 don't work. This change is not documented in Administrator's Reference for version 11.70. Anybody knows this strange behavior ? Thanks

Roger: The output on v12.10 is also different from both 11.50 and 11.70 and the documentation in the Administrator's Reference seems to be from even earlier. The IBM Documentation group needs to examine this. Hai-Nhu? Art Art S. Kagel, President and Principal Consultant ASK Database Management www.askdbmgt.com Blog: http://informix-myview.blogspot.com/ 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. On Tue, Aug 11, 2015 at 12:39 PM, ROGER VILCA <rvilca@luzdelsur.com.pe> wrote: > Hi, > > I have noticed that the ouput of onstat -g opn is different according > version > of informix server: > > Versión 11.50 (FC8) and 12.1 (FC4) show the output in the following format: > > tid rstcb isfd op_mode op_flags partnum ucount ocount lockmode > 78 0x0000000044d76768 267 0x00060000 0x00000403 0x0010009c 1 0 0 0 > 78 0x0000000044d76768 268 0x00060000 0x00000403 0x0010009b 1 0 0 0 > > 110 0x0000000044d7ad68 0 0x00000400 0x00000297 0x001001c1 2 2 9 1 > 110 0x0000000044d7ad68 1 0x00000002 0x00000117 0x001001c1 2 2 9 0 > 110 0x0000000044d7ad68 2 0x01000440 0x00000403 0x0010004f 2 0 9 0 > > but versión 11.70 (FC8W1) shows a different output: > > rstcb c00000003a3bdcf8 tid 26 > isfd op_mode op_flags partnum ucnt ocnt lk ra partp ocnt ucnt > 125 0000000000060000 0000000000000403 00000000001000bc 1 0 0 > c00000003ceac028 > 2 4 > 126 0000000000060000 0000000000000403 0000000000100134 1 0 0 > c00000003cec3028 > 0 1 > 127 0000000000060000 0000000000000403 000000000010046f 1 0 0 > c00000003caa0028 > 0 2 > 128 0000000000060000 0000000000000403 00000000001000cc 1 0 0 > c00000003cf3e028 > 0 2 > > rstcb c00000003a3be568 tid 91 > isfd op_mode op_flags partnum ucnt ocnt lk ra partp ocnt ucnt > 0 0000000000000400 0000000000000297 0000000000100168 2 2 61 > c00000003c4f37f0 1 > 1 > 1 0000000000000002 0000000000000003 0000000000100168 2 2 0 > c00000003c4f37f0 1 > 1 > 2 0000000000000400 0000000000000297 00000000001001fb 2 2 61 > c00000003c919028 > 189 189 > 3 0000000000000002 0000000000000003 00000000001001fb 2 2 0 c00000003c919028 > 189 189 > 5 0000000001000400 0000000000000413 000000000010046c 2 0 X 1 > c00000003ce7c4b8 > 1 2 > 6 0000000001000400 0000000000000413 000000000010046c 2 0 X 1 > c00000003ce7c4b8 > 1 2 > > I have scripts that are based in onstat -g opn, and were built for 7.31 and > work in 11.50 FC8 but in 11.70 don't work. > > This change is not documented in Administrator's Reference for version > 11.70. > Anybody knows this strange behavior ? > > Thanks > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --001a113ffdbc980e66051d0d4682

Hi Art, Our team will take a look at this. Thanks! Hai-Nhu ------------------- Hai-Nhu Tran Content Design Manager IBM Analytics Platform (415) 486-4151 | T/L 2= 00-4151 hntran@us.ibm.com ----- Origi= nal message ----- From: Art Kagel <art.kagel@gmail.com> To: "id= s@iiug.org" <ids@iiug.org> Cc: Subject: Re: Different output of= onstat -g opn in version 11.70 [35591] Date: Tue, Aug 11, 2015 11:29 AM= Roger: The output on v12.10 is also different from= both 11.50 and 11.70 and the documentation in the Administrator's Referenc= e seems to be from even earlier. The IBM Documentation group needs to= examine this. Hai-Nhu? Art Art S. Kagel, President and Principal Consultant ASK Database Management [1]www.askdbmgt.= com Blog: [2]http://informix-myview.blogspot.com/ Disclaimer:= Please keep in mind that my own opinions are my own opinions and do not re= flect on the IIUG, nor any other organization with which I am associated ei= ther explicitly, implicitly, or by inference. Neither do those opinio= ns reflect those of other individuals affiliated with any entity with which= I am affiliated nor those of the entities themselves. On Tue, Aug 11, 2015 at 12:39 PM, ROGER VILCA <<= a href=3D"mailto:rvilca@luzdelsur.com.pe" target=3D"=5Fblank" >rvilca@luzde= lsur.com.pe> wrote: Hi, I have noticed that the ouput of onstat -g opn is diff= erent according version of informix server: Versi=C3=B3n 11.50 (F= C8) and 12.1 (FC4) show the output in the following format: tid rstc= b isfd op=5Fmode op=5Fflags partnum ucount ocount lockmode 78 0x00000000= 44d76768 267 0x00060000 0x00000403 0x0010009c 1 0 0 0 78 0x0000000044d76= 768 268 0x00060000 0x00000403 0x0010009b 1 0 0 0 110 0x0000000044d7a= d68 0 0x00000400 0x00000297 0x001001c1 2 2 9 1 110 0x0000000044d7ad68 1 = 0x00000002 0x00000117 0x001001c1 2 2 9 0 110 0x0000000044d7ad68 2 0x0100= 0440 0x00000403 0x0010004f 2 0 9 0 but versi=C3=B3n 11.70 (FC8W1) sh= ows a different output: rstcb c00000003a3bdcf8 tid 26 isfd op=5Fm= ode op=5Fflags partnum ucnt ocnt lk ra partp ocnt ucnt 125 0000000000060= 000 0000000000000403 00000000001000bc 1 0 0 c00000003ceac028 2 4 126 = 0000000000060000 0000000000000403 0000000000100134 1 0 0 c00000003cec30280 1 127 0000000000060000 0000000000000403 000000000010046f 1 0 0 c0000= 0003caa0028 0 2 128 0000000000060000 0000000000000403 00000000001000c= c 1 0 0 c00000003cf3e028 0 2 rstcb c00000003a3be568 tid 91 isf= d op=5Fmode op=5Fflags partnum ucnt ocnt lk ra partp ocnt ucnt 0 0000000= 000000400 0000000000000297 0000000000100168 2 2 61 c00000003c4f37f0 1 1<= br>1 0000000000000002 0000000000000003 0000000000100168 2 2 0 c00000003c4f3= 7f0 1 1 2 0000000000000400 0000000000000297 00000000001001fb 2 2 61 c= 00000003c919028 189 189 3 0000000000000002 0000000000000003 000000000= 01001fb 2 2 0 c00000003c919028 189 189 5 0000000001000400 00000000000= 00413 000000000010046c 2 0 X 1 c00000003ce7c4b8 1 2 6 000000000100040= 0 0000000000000413 000000000010046c 2 0 X 1 c00000003ce7c4b8 1 2 = I have scripts that are based in onstat -g opn, and were built for 7.31 and= work in 11.50 FC8 but in 11.70 don't work. This change is not do= cumented in Administrator's Reference for version 11.70. Anybody knows t= his strange behavior ? Thanks ***************************= **************************************************** Forum Note: = Use "Reply" to post a response in the discussion forum. References 1. 3D"http://www.askdbmgt.com"/ 2. 3D"http://informix-myview.blogspot.com/";