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) |