Informix - Problem description
Problem IT39738 | Status: Closed |
ON A VERY BUSY SYSTEM "ONSTAT -G SES NNN" DOES NOT PROVIDE SESSION DETAILS. | |
product: | |
INFORMIX SERVER / 5725A3900 / E10 - | |
Problem description: | |
The problem is observed on 14.10.xC7 Solaris Machine. On a busy system, if they run "onstat -g ses" report when sessions are being being added and/or destroyed we seem to have session control block structures in the list but they contain next/prev of null, resulting not to print some session details. Where as "onstat -g sql" on same session id is printing the details correctly. ex: -bash-4.4$ onstat -g ses 31087254 IBM Informix Dynamic Server Version 14.10.FC7 -- On-Line (Prim) -- Up 12 days 02:38:38 -- 12967936 Kbytes 2022-01-26 10:10:11 Last 20 Sessions Terminated Ses ID Username Hostname PID Time Reason 20676719 scmroot -1 12/01/2022.21:11 onmode z 20688143 scmroot -1 12/01/2022.21:19 onmode z -bash-4.4$ onstat -g sql 31087254 IBM Informix Dynamic Server Version 14.10.FC7 -- On-Line (Prim) -- Up 12 days 02:38:44 -- 12967936 Kbytes 2022-01-26 10:10:11 Sess SQL Current Iso Lock SQL ISAM F.E. Id Stmt type Database Lvl Mode ERR ERR Vers Explain 31087254 - testdb CR Wait 5 0 0 9.28 Off Current Role : db_role Last parsed SQL statement : select * from employee | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * Users of Informix Server prior to 14.10.xC8. * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Informix Server 14.10.xC8. * **************************************************************** | |
Local Fix: | |
Solution | |
Workaround | |
**************************************************************** * USERS AFFECTED: * * Users of Informix Server prior to 14.10.xC8. * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Informix Server 14.10.xC8. * **************************************************************** | |
Comment | |
Fixed in Informix Server 14.10.xC8. | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 25.01.2022 07.04.2022 07.04.2022 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |