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