APAR status
Closed as fixed if next.
Error description
You have a UDR which uses sequences and from time to time Informix drops error -8319 ( Sequence object cannot be used here.) Trapped with use of 'onmode -I 8319' command, the Assertion Failure file shows the following stack: afstack afhandler check_traperror sqerr col2expr dotted2expr expr2expr prjlst2expr sel2cb subq2cb sq2expr subq2expr expr2expr ip_exprparse ip_evalexpr runproc udrlm_spl_execute udrlm_exec_routine udr_execute exroutine geval evalcols getrow fetchrow doselect exsubq ev_cb new_eval ip_evalexpr runproc udrlm_spl_execute udrlm_exec_routine udr_execute udr_spl_curnext ip_curnext ip_fetch getrow fetchrow exfetch sql_nfetch sq_nfetch sqmain listen_verify spawn_thread startup
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: * * If there is a concurrent UPDATE STATISTICS run from another * * session, a session running a UDR that is using sequences can * * fail with a -8319 error. * **************************************************************** * PROBLEM DESCRIPTION: * * You have a UDR which uses sequences and from time to time * * * * Informix drops error -8319 ( Sequence object cannot be used * * * * here.) * * * * * * * * Trapped with use of 'onmode -I 8319' command, the Assertion * * * * Failure file shows the following stack: * * * * * * * * afstack * * * * afhandler * * * * check_traperror * * * * sqerr * * * * col2expr * * * * dotted2expr * * * * expr2expr * * * * prjlst2expr * * * * sel2cb * * * * subq2cb * * * * sq2expr * * * * subq2expr * * * * expr2expr * * * * ip_exprparse * * * * ip_evalexpr * * * * runproc * * * * udrlm_spl_execute * * * * udrlm_exec_routine * * * * udr_execute * * * * exroutine * * * * geval * * * * evalcols * * * * getrow * * * * fetchrow * * * * doselect * * * * exsubq * * * * ev_cb * * * * new_eval * * * * ip_evalexpr * * * * runproc * * * * udrlm_spl_execute * * * * udrlm_exec_routine * * * * udr_execute * * * * udr_spl_curnext * * * * ip_curnext * * * * ip_fetch * * * * getrow * * * * fetchrow * * * * exfetch * * * * sql_nfetch * * * * sq_nfetch * * * * sqmain * * * * listen_verify * * * * spawn_thread * * * * 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
IC76047
Reported component name
INFORMIX SERVER
Reported component ID
5725A3900
Reported release
B50
Status
CLOSED FIN
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2011-04-28
Closed date
2011-09-27
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
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