APAR status
Closed as program error.
Error description
When inserting a smart large object through a view, if the column name refers to the column in the view the sqlexec threads will hang in an endless loop, give error 206, and never leave the running state. This appears only if a host variable is used. onstat -g ath always shows: Threads: tid tcb rstcb prty status vp-class name 52 7000000119da8e0 70000001048ba98 1 running 1cpu* sqlexec onstat -g ses Sess SQL Current Iso Lock SQL ISAM F.E. Id Stmt type Database Lvl Mode ERR ERR Vers Explain 40 EXEC PROCEDURE mydb NL Not Wait 0 0 9.35 Off Host variables : address type flags value ----------------------------------------- 0x07000000119ba780 UDTVAR 0x000 <not shown> 0x07000000119ba810 UDTFIXED 0x000 <not shown>
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: * * IDS 9 and above * **************************************************************** * PROBLEM DESCRIPTION: * * Calling on a sblob column that is referenced via a view * * could lead * * to an infinite loop if the view and the base table is not in * * the same database and there * * is another view with the same name as the base table in the * * same database. * **************************************************************** * RECOMMENDATION: * * Upgrade to IDS 11.50.xC6 and above. * ****************************************************************
Problem conclusion
Problem first fixed in IDS 11.50.xC6
Temporary fix
Comments
APAR Information
APAR number
IC63507
Reported component name
IBM IDS ENTRP E
Reported component ID
5724L2304
Reported release
B15
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2009-09-30
Closed date
2009-10-30
Last modified date
2010-01-18
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
IBM IDS ENTRP E
Fixed component ID
5724L2304
Applicable component levels
RB15 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":"B15","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
18 January 2010