APAR status
Closed as program error.
Error description
A query that involves the sysmaster table syslcktab with a where clause that includes the indx column will loop continuously and return no data with the value associated with the indx if the column is greater than or equal to the current size of the lock table. The query cannot be interrupted, nor the session killed, and the server must be restarted to remove it. Example: select * from syslcktab where indx = 20000 If the value of the LOCKS onconfig parameter is 20000, and the lock table has not been extended, then the above query will hang. With a value of 19999 or less, the query will work as expected. The same problem will also occur when using a filter on the lk_id column of the syslocktab view.
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: * * QUERY WILL HANG WHEN USING SYSMASTER TABLE SYSLCKTAB WITH * * FILTER * * ON INDX COLUMN GREATER THAN OR EQUAL TO SIZE OF LOCK TABLE * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Update to IDS-11.70.xC8 * ****************************************************************
Problem conclusion
Problem Fixed In IDS-11.70.xC8
Temporary fix
Comments
APAR Information
APAR number
IC91605
Reported component name
INFORMIX SERVER
Reported component ID
5725A3900
Reported release
B50
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2013-04-16
Closed date
2014-02-26
Last modified date
2024-09-24
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
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSGU8G","label":"Informix Servers"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"B50","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
24 September 2024