APAR status
Closed as duplicate of another APAR.
Error description
If a user session executes a SPL after update statistics have been run, then the sysprocplan locks remain until the user session exits. IBM Informix Dynamic Server Version 12.10.FC5 -- On-Line -- Up 00:04:58 -- 58488 Kbytes Locks address wtlist owner lklist type tblsnum rowid key#/bsiz 44199028 0 44bccda8 0 HDR+S 100002 204 0 44199358 0 44bcdf28 0 S 100002 204 0 44199600 0 44bd0ae8 0 HDR+S 100002 205 0 44199820 0 44bd0ae8 44199ac8 HDR+X 100194 3306 K- 1 D 44199a40 0 44bd0ae8 4419a348 HDR+X 100194 3304 0 I 44199ac8 0 44bd0ae8 4419b800 HDR+X 100194 3306 0 I 44199ce8 0 44bd0ae8 4419a898 HDR+X 100194 3307 K- 1 D 44199d70 0 44bd0ae8 4419b5e0 HDR+X 100194 3403 K- 1 I 44199e80 0 44bce7e8 0 S 100002 204 0 4419a348 0 44bd0ae8 4419b6f0 HDR+X 100194 3303 K- 1 D 4419a898 0 44bd0ae8 44199820 HDR+X 100194 3307 0 I 4419a9a8 0 44bd0ae8 44199a40 HDR+X 100194 3304 K- 1 D 4419ab40 0 44bcdf28 44199358 HDR+S 100002 201 0 4419b008 0 44bd0ae8 4419b668 HDR+X 100194 3302 K- 1 D 4419b228 0 44bcd668 0 S 100002 204 0 4419b4d0 0 44bd0ae8 44199600 HDR+IX 100194 0 0 4419b5e0 0 44bd0ae8 44199ce8 HDR+X 100194 3403 0 I 4419b668 0 44bd0ae8 4419b4d0 HDR+X 100194 3302 0 I 4419b6f0 0 44bd0ae8 4419b008 HDR+X 100194 3303 0 I 4419b778 0 44bd0ae8 4419a9a8 HDR+X 100194 3305 0 I 4419b800 0 44bd0ae8 4419b778 HDR+X 100194 3305 K- 1 D 21 active, 20000 total, 16384 hash buckets, 0 lock table overflows
Local fix
Problem summary
Problem conclusion
Temporary fix
Comments
This APAR is a duplicate of IC99180
APAR Information
APAR number
IT27593
Reported component name
INFORMIX SERVER
Reported component ID
5725A3900
Reported release
B70
Status
CLOSED DUB
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2018-12-27
Closed date
2019-09-20
Last modified date
2019-09-20
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fix information
Applicable component levels
[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSGU8G","label":"Informix Servers"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"B70","Edition":"","Line of Business":{"code":"","label":""}}]
Document Information
Modified date:
20 September 2019