tty value
HI, Guys,
I am wondering the TTY values from onstat -u.
It is normally a number, but the folowing looks.....
Any idea?
AIX 5.3, IDS10 UC5
Tahnks,
Frank
IBM Informix Dynamic Server Version 10.00.UC5 -- On-Line -- Up 18:50:39
-- 77088 Kbytes
Userthreads
address flags sessid user tty wait tout locks nreads
nwrites
501fe018 ---P--D 1 informix - 0 0 0 63 296
501fe524 ---P--F 0 informix - 0 0 0 0
2174
501fea30 ---P--F 0 informix - 0 0 0 0 0
501fef3c ---P--F 0 informix - 0 0 0 0 0
501ff448 ---P--F 0 informix - 0 0 0 0 0
501ff954 ---P--F 0 informix - 0 0 0 0 0
501ffe60 ---P--F 0 informix - 0 0 0 0 0
5020036c ---P--F 0 informix - 0 0 0 0 0
50200878 ---P--F 0 informix - 0 0 0 0 0
50200d84 ---P--- 10 informix - 0 0 0 0 0
50201290 ---P--B 11 informix - 0 0 0 0 0
50201ca8 Y--P--- 98 aradmin ) ;0h± 50dc05c0 0 1 0 0
502021b4 ---P--D 14 informix - 0 0 0 0 0
502026c0 Y--P--- 95 aradmin ) ;0h± 50b94b38 0 1 0 0
50202bcc Y--P--- 89 aradmin ) ;0h± 50e6dd18 0 1 0 0
502030d8 Y--P--- 88 aradmin ) ;0h± 50eb6820 0 1 1288 1288
502035e4 Y--P--- 93 aradmin ) ;0h± 51025e38 0 1 0 0
50203af0 Y--P--- 90 aradmin ) ;0h± 50d78a20 0 1 809 1966
50203ffc Y--P--- 94 aradmin ) ;0h± 50b94ae8 0 1 0 0
50204508 Y--P--- 96 aradmin ) ;0h± 51025f28 0 1 0 0
50204a14 Y--P--- 91 aradmin ) ;0h± 51025bb0 0 1 692 1882
50204f20 Y--P--- 92 aradmin ) ;0h± 51025c50 0 1 15670 0
5020542c Y--P--- 97 aradmin ) ;0h± 51025770 0 1 16639 0
50205938 Y--P--D 28 informix - 4007db44 0 0 0 0
24 active, 128 total, 0 maximum concurrent
I see the same type of garbage on an HDR secondary after a number of days (IDS
10.00.UC4) on a session that usually points back to an oninit on the primary.
I also see it with "onstat -g ses". I have a case open on it.
Bob Roussey
Unix / Informix Administration
Spirit Airlines
Robert.Roussey@SpiritAir.com
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of FRANK
Sent: Wednesday, June 13, 2007 10:34 AM
To: ids@iiug.org
Subject: tty value [9346]
HI, Guys,
I am wondering the TTY values from onstat -u.
It is normally a number, but the folowing looks.....
Any idea?
AIX 5.3, IDS10 UC5
Tahnks,
Frank
IBM Informix Dynamic Server Version 10.00.UC5 -- On-Line -- Up 18:50:39
-- 77088 Kbytes
Userthreads
address flags sessid user tty wait tout locks nreads
nwrites
501fe018 ---P--D 1 informix - 0 0 0 63 296
501fe524 ---P--F 0 informix - 0 0 0 0
2174
501fea30 ---P--F 0 informix - 0 0 0 0 0
501fef3c ---P--F 0 informix - 0 0 0 0 0
501ff448 ---P--F 0 informix - 0 0 0 0 0
501ff954 ---P--F 0 informix - 0 0 0 0 0
501ffe60 ---P--F 0 informix - 0 0 0 0 0
5020036c ---P--F 0 informix - 0 0 0 0 0
50200878 ---P--F 0 informix - 0 0 0 0 0
50200d84 ---P--- 10 informix - 0 0 0 0 0
50201290 ---P--B 11 informix - 0 0 0 0 0
50201ca8 Y--P--- 98 aradmin ) ;0h± 50dc05c0 0 1 0 0
502021b4 ---P--D 14 informix - 0 0 0 0 0
502026c0 Y--P--- 95 aradmin ) ;0h± 50b94b38 0 1 0 0
50202bcc Y--P--- 89 aradmin ) ;0h± 50e6dd18 0 1 0 0
502030d8 Y--P--- 88 aradmin ) ;0h± 50eb6820 0 1 1288 1288
502035e4 Y--P--- 93 aradmin ) ;0h± 51025e38 0 1 0 0
50203af0 Y--P--- 90 aradmin ) ;0h± 50d78a20 0 1 809 1966
50203ffc Y--P--- 94 aradmin ) ;0h± 50b94ae8 0 1 0 0
50204508 Y--P--- 96 aradmin ) ;0h± 51025f28 0 1 0 0
50204a14 Y--P--- 91 aradmin ) ;0h± 51025bb0 0 1 692 1882
50204f20 Y--P--- 92 aradmin ) ;0h± 51025c50 0 1 15670 0
5020542c Y--P--- 97 aradmin ) ;0h± 51025770 0 1 16639 0
50205938 Y--P--D 28 informix - 4007db44 0 0 0 0
24 active, 128 total, 0 maximum concurrent
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.
Check the corresponding onstat -g ses lines, these are probably networked
connections so the tty is meaningless.
Art S. Kagel
----- Original Message -----
From: Frank <ids@iiug.org>
At: 6/13 10:34:22
HI, Guys,
I am wondering the TTY values from onstat -u.
It is normally a number, but the folowing looks.....
Any idea?
AIX 5.3, IDS10 UC5
Tahnks,
Frank
IBM Informix Dynamic Server Version 10.00.UC5 -- On-Line -- Up 18:50:39
-- 77088 Kbytes
Userthreads
address flags sessid user tty wait tout locks nreads
nwrites
501fe018 ---P--D 1 informix - 0 0 0 63 296
501fe524 ---P--F 0 informix - 0 0 0 0
2174
501fea30 ---P--F 0 informix - 0 0 0 0 0
501fef3c ---P--F 0 informix - 0 0 0 0 0
501ff448 ---P--F 0 informix - 0 0 0 0 0
501ff954 ---P--F 0 informix - 0 0 0 0 0
501ffe60 ---P--F 0 informix - 0 0 0 0 0
5020036c ---P--F 0 informix - 0 0 0 0 0
50200878 ---P--F 0 informix - 0 0 0 0 0
50200d84 ---P--- 10 informix - 0 0 0 0 0
50201290 ---P--B 11 informix - 0 0 0 0 0
50201ca8 Y--P--- 98 aradmin ) ;0h± 50dc05c0 0 1 0 0
502021b4 ---P--D 14 informix - 0 0 0 0 0
502026c0 Y--P--- 95 aradmin ) ;0h± 50b94b38 0 1 0 0
50202bcc Y--P--- 89 aradmin ) ;0h± 50e6dd18 0 1 0 0
502030d8 Y--P--- 88 aradmin ) ;0h± 50eb6820 0 1 1288 1288
502035e4 Y--P--- 93 aradmin ) ;0h± 51025e38 0 1 0 0
50203af0 Y--P--- 90 aradmin ) ;0h± 50d78a20 0 1 809 1966
50203ffc Y--P--- 94 aradmin ) ;0h± 50b94ae8 0 1 0 0
50204508 Y--P--- 96 aradmin ) ;0h± 51025f28 0 1 0 0
50204a14 Y--P--- 91 aradmin ) ;0h± 51025bb0 0 1 692 1882
50204f20 Y--P--- 92 aradmin ) ;0h± 51025c50 0 1 15670 0
5020542c Y--P--- 97 aradmin ) ;0h± 51025770 0 1 16639 0
50205938 Y--P--D 28 informix - 4007db44 0 0 0 0
24 active, 128 total, 0 maximum concurrent
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.
Art,
onstat -g ses 's output. The tty is there.
Thanks,
Frank
fqu@otto $ onstat -g ses 98
IBM Informix Dynamic Server Version 10.00.UC5 -- On-Line -- Up 19:09:32
-- 77088 Kbytes
session #RSAM total used
dynamic
id user tty pid hostname threads memory memory
explain
98 aradmin ) ;0h± 1081514 mindy.cl 1 65536 48592
off
tid name rstcb flags curstk status
130 sqlexec 50201ca8 Y--P--- 3992 cond wait(netnorm)
Memory pools count 2
name class addr totalsize freesize #allocfrag #freefrag
98 V 50ede020 61440 14496 100 11
98*O0 V 50f11020 4096 2448 1 1
name free used name free used
overhead 0 3296 scb 0 96
opentable 0 1600 filetable 0 336
log 0 14096 temprec 0 4680
keys 0 616 gentcb 0 1216
ostcb 0 2736 sqscb 0 13768
sql 0 40 rdahead 0 1600
hashfiletab 0 280 osenv 0 1800
sqtcb 0 2040 fragman 0 232
udr 0 160
sqscb info
scb sqscb optofc pdqpriority sqlstats optcompind directives
50dfe7b8 50edf018 0 0 0 0 1
Sess SQL Current Iso Lock SQL ISAM F.E.
Id Stmt type Database Lvl Mode ERR ERR Vers
Explain
98 - arsystem CR Wait 0 0 9.03 Off
Last parsed SQL statement :
SELECT T20.C1,T20.C1,C1101,C1103,C1102,C1104,C1101 FROM T20 ORDER BY 7 ASC
On 6/13/07, ART KAGEL, BLOOMBERG/ 731 LEXIN <kagel@bloomberg.net> wrote:
>
> Check the corresponding onstat -g ses lines, these are probably networked
> connections so the tty is meaningless.
>
> Art S. Kagel
> ----- Original Message -----
> From: Frank <ids@iiug.org>
> At: 6/13 10:34:22
>
> HI, Guys,
>
> I am wondering the TTY values from onstat -u.
>
> It is normally a number, but the folowing looks.....
>
> Any idea?
>
> AIX 5.3, IDS10 UC5
>
> Tahnks,
> Frank
>
> IBM Informix Dynamic Server Version 10.00.UC5 -- On-Line -- Up 18:50:39
> -- 77088 Kbytes>
> Userthreads
> address flags sessid user tty wait tout locks nreads
> nwrites
> 501fe018 ---P--D 1 informix - 0 0 0 63 296
> 501fe524 ---P--F 0 informix - 0 0 0 0
> 2174
> 501fea30 ---P--F 0 informix - 0 0 0 0 0
> 501fef3c ---P--F 0 informix - 0 0 0 0 0
> 501ff448 ---P--F 0 informix - 0 0 0 0 0
> 501ff954 ---P--F 0 informix - 0 0 0 0 0
> 501ffe60 ---P--F 0 informix - 0 0 0 0 0
> 5020036c ---P--F 0 informix - 0 0 0 0 0
> 50200878 ---P--F 0 informix - 0 0 0 0 0
> 50200d84 ---P--- 10 informix - 0 0 0 0 0
> 50201290 ---P--B 11 informix - 0 0 0 0 0
> 50201ca8 Y--P--- 98 aradmin ) ;0h± 50dc05c0 0 1 0 0
> 502021b4 ---P--D 14 informix - 0 0 0 0 0
> 502026c0 Y--P--- 95 aradmin ) ;0h± 50b94b38 0 1 0 0
> 50202bcc Y--P--- 89 aradmin ) ;0h± 50e6dd18 0 1 0 0
> 502030d8 Y--P--- 88 aradmin ) ;0h± 50eb6820 0 1 1288 1288
> 502035e4 Y--P--- 93 aradmin ) ;0h± 51025e38 0 1 0 0
> 50203af0 Y--P--- 90 aradmin ) ;0h± 50d78a20 0 1 809 1966
> 50203ffc Y--P--- 94 aradmin ) ;0h± 50b94ae8 0 1 0 0
> 50204508 Y--P--- 96 aradmin ) ;0h± 51025f28 0 1 0 0
> 50204a14 Y--P--- 91 aradmin ) ;0h± 51025bb0 0 1 692 1882
> 50204f20 Y--P--- 92 aradmin ) ;0h± 51025c50 0 1 15670 0
> 5020542c Y--P--- 97 aradmin ) ;0h± 51025770 0 1 16639 0
> 50205938 Y--P--D 28 informix - 4007db44 0 0 0 0
> 24 active, 128 total, 0 maximum concurrent
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
Thank you, Bob! Please keep us informed.
Frank
On 6/13/07, Robert Roussey(IT) <Robert.Roussey@spiritair.com> wrote:
>
> I see the same type of garbage on an HDR secondary after a number of days
> (IDS
> 10.00.UC4) on a session that usually points back to an oninit on the
> primary.
> I also see it with "onstat -g ses". I have a case open on it.
>
> Bob Roussey
> Unix / Informix Administration
> Spirit Airlines
> Robert.Roussey@SpiritAir.com
>
> -----Original Message-----
> From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
> FRANK
> Sent: Wednesday, June 13, 2007 10:34 AM
> To: ids@iiug.org
> Subject: tty value [9346]
>
> HI, Guys,
>
> I am wondering the TTY values from onstat -u.
>
> It is normally a number, but the folowing looks.....
>
> Any idea?
>
> AIX 5.3, IDS10 UC5
>
> Tahnks,
> Frank
>
> IBM Informix Dynamic Server Version 10.00.UC5 -- On-Line -- Up 18:50:39
> -- 77088 Kbytes>
> Userthreads
> address flags sessid user tty wait tout locks nreads
> nwrites
> 501fe018 ---P--D 1 informix - 0 0 0 63 296
> 501fe524 ---P--F 0 informix - 0 0 0 0
> 2174
> 501fea30 ---P--F 0 informix - 0 0 0 0 0
> 501fef3c ---P--F 0 informix - 0 0 0 0 0
> 501ff448 ---P--F 0 informix - 0 0 0 0 0
> 501ff954 ---P--F 0 informix - 0 0 0 0 0
> 501ffe60 ---P--F 0 informix - 0 0 0 0 0
> 5020036c ---P--F 0 informix - 0 0 0 0 0
> 50200878 ---P--F 0 informix - 0 0 0 0 0
> 50200d84 ---P--- 10 informix - 0 0 0 0 0
> 50201290 ---P--B 11 informix - 0 0 0 0 0
> 50201ca8 Y--P--- 98 aradmin ) ;0h± 50dc05c0 0 1 0 0
> 502021b4 ---P--D 14 informix - 0 0 0 0 0
> 502026c0 Y--P--- 95 aradmin ) ;0h± 50b94b38 0 1 0 0
> 50202bcc Y--P--- 89 aradmin ) ;0h± 50e6dd18 0 1 0 0
> 502030d8 Y--P--- 88 aradmin ) ;0h± 50eb6820 0 1 1288 1288
> 502035e4 Y--P--- 93 aradmin ) ;0h± 51025e38 0 1 0 0
> 50203af0 Y--P--- 90 aradmin ) ;0h± 50d78a20 0 1 809 1966
> 50203ffc Y--P--- 94 aradmin ) ;0h± 50b94ae8 0 1 0 0
> 50204508 Y--P--- 96 aradmin ) ;0h± 51025f28 0 1 0 0
> 50204a14 Y--P--- 91 aradmin ) ;0h± 51025bb0 0 1 692 1882
> 50204f20 Y--P--- 92 aradmin ) ;0h± 51025c50 0 1 15670 0
> 5020542c Y--P--- 97 aradmin ) ;0h± 51025770 0 1 16639 0
> 50205938 Y--P--D 28 informix - 4007db44 0 0 0 0
> 24 active, 128 total, 0 maximum concurrent
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>