APAR status
Closed as program error.
Error description
If a user session executes a SPL after update statistics has 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
**************************************************************** * USERS AFFECTED: * * Those using procedures in unlogged databases * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Update to IBM Informix Server 12.10.xC6 * ****************************************************************
Problem conclusion
Problem Fixed In IBM Informix Server 12.10.xC6
Temporary fix
Comments
APAR Information
APAR number
IT09288
Reported component name
INFORMIX SERVER
Reported component ID
5725A3900
Reported release
C10
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2015-06-04
Closed date
2015-12-30
Last modified date
2015-12-30
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fix information
Fixed component name
INFORMIX SERVER
Fixed component ID
5725A3900
Applicable component levels
RB70 PSN
UP
RB70 PSY
UP
RC10 PSN
UP
RC10 PSY
UP
[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSGU8G","label":"Informix Servers"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"C10","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
30 December 2015