APAR status
Closed as fixed if next.
Error description
Error -769 when running a query that performs outer joins on remote tables. The problem was first observed when using IDS 11.50.FC7W3; versions prior to this release run the query without error. Stack (obtained from setting a trap for -769 ) : oninit :: afstack oninit :: afhandler oninit :: affail_interface oninit :: check_traperror oninit :: sqerr oninit :: sqerr1 oninit :: remote_scan_next oninit :: join_next oninit :: getrow oninit :: fetchrow oninit :: exfetch oninit :: sql_nfetch oninit :: sq_nfetch oninit :: sqmain oninit :: listen_verify oninit :: spawn_threa oninit :: startup
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: * * Remote OUTER joins on version 11.50.FC7W3 can fail with * * error 769. Versions prior to this release do not show this * * problem. * **************************************************************** * PROBLEM DESCRIPTION: * * Error -769 when running a query that performs outer joins on * * * * remote tables. The problem was first observed when using IDS * * * * 11.50.FC7W3; versions prior to this release run the query * * * * without error. * * * * * * * * Stack (obtained from setting a trap for -769 ) : * * * * * * * * oninit :: afstack * * * * oninit :: afhandler * * * * oninit :: affail_interface * * * * oninit :: check_traperror * * * * oninit :: sqerr * * * * oninit :: sqerr1 * * * * oninit :: remote_scan_next * * * * oninit :: join_next * * * * oninit :: getrow * * * * oninit :: fetchrow * * * * oninit :: exfetch * * * * oninit :: sql_nfetch * * * * oninit :: sq_nfetch * * * * oninit :: sqmain * * * * oninit :: listen_verify * * * * oninit :: spawn_threa * * * * oninit :: startup * **************************************************************** * RECOMMENDATION: * * Upgrade to IDS version 11.50.xC9 * ****************************************************************
Problem conclusion
Temporary fix
Comments
http://publib.boulder.ibm.com/infocenter/idshelp/v115/index.jsp For download information, go to: http://www.ibm.com/support/fixcentral
APAR Information
APAR number
IC73468
Reported component name
IBM IDS ENTRP E
Reported component ID
5724L2304
Reported release
B15
Status
CLOSED FIN
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2010-12-23
Closed date
2011-09-27
Last modified date
2011-09-27
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
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:
27 September 2011