home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Latest versionsfixlist
14.10.xC12 FixList
12.10.xC16.X5 FixList
11.70.xC9.XB FixList
11.50.xC9.X2 FixList
11.10.xC3.W5 FixList
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26

Informix - Problem description

Problem IT46173 Status: Closed

PERFORMANCE -> SESSIONS IS CONFUSING WHEN A SESSIONS HAS MORE THREADS -
FOR EXAMPLE BECAUSE OF PDQ

product:
INFORMIX SERVER / 5725A3900 / E10 - 
Problem description:
session           effective                             #RSAM
total      used       dynamic
id       user     user      tty      pid      hostname  threads
memory     memory     explain
97       informix -         -        29200    server     3
368640     357240     off

tid      name     rstcb            flags    curstk   status
114      sqlexec  4548aac0         Y--P---  7280     cond wait
netnorm   -
116      scan_1.0 454917e0         Y------  576      cond wait
await_MC1 -
118      scan_3.0 45492a10         Y------  576      cond wait
await_MC3 -

shows as 3 sessions in Performance -> Sessions

97 	informix	29200	server       2024-05-16 13:18:53 	360 KB
	0	0.031
97 	informix	29200	server       2024-05-16 13:18:53 	360 KB
	0	0
97 	informix	29200	server       2024-05-16 13:18:53 	360 KB
	0	0.001
Problem Summary:
****************************************************************
* USERS AFFECTED:                                              *
* Users of InformixHQ prior to 3.0.0.                          *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* See Error Description                                        *
****************************************************************
* RECOMMENDATION:                                              *
* Update to InformixHQ 3.0.0.                                  *
****************************************************************
Local Fix:
Solution
Workaround
****************************************************************
* USERS AFFECTED:                                              *
* Users of InformixHQ prior to 3.0.0.                          *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* See Error Description                                        *
****************************************************************
* RECOMMENDATION:                                              *
* Update to InformixHQ 3.0.0.                                  *
****************************************************************
Comment
Fixed in InformixHQ 3.0.0.
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
16.05.2024
25.10.2024
25.10.2024
Problem solved at the following versions (IBM BugInfos)
Problem solved according to the fixlist(s) of the following version(s)