• Admin-Scout-small-Banner
           
    CURSOR Admin-Scout
    get the ultimate tool for Informix
    pfeil  
invispix 10x10
invispix 10x10
Latest versionsfixlist
14.10.xC5 FixList
12.10.xC14.X5 FixList
11.70.xC9.XB FixList
11.50.xC9.X2 FixList
11.10.xC3.W5 FixList
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26
Question in the chat LiveZilla Live Help

Informix - Problem description

Problem IT34040 Status: Closed

-9700 ERROR CAN OCCUR ON OPEN CURSOR AFTER AUS_EVALUATOR TASK RUNS AND
UPDATE STATISTICS

product:
INFORMIX SERVER / 5725A3900 / B70 - IDS 11.70
Problem description:
The following problem was first reported by customer running
11.70.FC9 on linux x86_64.  This has also been reproduced in
12.10.FC10 and does not appear to be platform specific.

The reproduction involves running a multi-threaded client having
each associated server session prepare a statement and open it
several hundred times before
repeating the prepare again.

On occasion after the aus_evaluator task has run and update
statistics has run as well on the tables involved in the query
that the open cursor can fail with -9700.  Ifyou try a
subsequent open ... with re-optimization, it will fail as well.

To workaround the problem, it seems you have to prepare the
statement again and re-declare the cursor before you can open it
again, so you will have to
error check opens for -9700 errors and re-prepare.

If you use 'onmode -I -9700' to trap for the -9700 error, you
will see in the af.file that the onstat -g ses output for the
trapped session shows a stack like:

afstack
afhandler
affail_interface
check_traperror
sqerr
sqerr1
udr_determine
expr_determine
routine_bind
sqbind
sq_common_bind
sqmain
spawn_thread
th_init_initgls
startup

and for the session currently running:

Sess       SQL            Current            Iso Lock       SQL
ISAM F.E.
Id         Stmt type      Database           Lvl Mode       ERR
ERR  Vers  Explain
23934      SELECT         dbname            CR  Not Wait
-9700 0    9.35  Off

Current statement name : democursor1

Current SQL statement (5908) :


Host variables :
   address            type       flags value
   -----------------------------------------
   0x000000005c11e038 CHAR       0x000 25000.0
   0x000000005c11e0c8 CHAR       0x000 25000.0
   0x000000005c11e158 INT        0x000 4144996
   0x000000005c11e1e8 INT        0x000 4144998
   0x000000005c11e278 INT        0x000 4145000
   0x000000005c11e308 INT        0x000 -1

The interesting thing here is that the first two host variables
are normally DECIMAL and not CHAR type and a typical onstat -g
ses for a session's running
thread would look more like:

Id         Stmt type      Database           Lvl Mode       ERR
ERR  Vers  Explain
36         SELECT         dbname            CR  Not Wait   0
0    9.37  Off

Current statement name : democursor1

Current SQL statement (0) :


Host variables :
   address            type       flags value
   -----------------------------------------
   0x000000005ba3c038 DECIMAL    0x000 25000
   0x000000005ba3c0c8 DECIMAL    0x000 25000
   0x000000005ba3c158 INT        0x000 4144996
   0x000000005ba3c1e8 INT        0x000 4144998
   0x000000005ba3c278 INT        0x000 4145000
   0x000000005ba3c308 INT        0x000 -1
Problem Summary:
****************************************************************
* USERS AFFECTED:                                              *
* Users of Informix Server prior to 11.70.xC9W2, 12.10.xC15    *
* and 14.10.xC5.                                               *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* See Error Description                                        *
****************************************************************
* RECOMMENDATION:                                              *
* Upgrade to Informix Server to 11.70.xC9W2, 12.10.xC15 and    *
* 14.10.xC5.                                                   *
****************************************************************
The fix by default is disabled, enable it with ONCONFIG
SQL_DEF_CTRL bit 0x2000000.
Local Fix:
Solution
Workaround
not known / see Local fix
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
28.08.2020
11.09.2020
11.09.2020
Problem solved at the following versions (IBM BugInfos)
Problem solved according to the fixlist(s) of the following version(s)
invispix 10x10
invispix 10x10
invispix 10x10
Technical InfoTechnical Info

Technical Info

DocumentationDocumentation

Documentation

IBM NewsletterIBM Newsletter

IBM Newsletter

Current BugsCurrent Bugs

Current Bugs

Bug ResearchBug Research

Bug Research

Bug FixlistsBug Fixlists

Bug Fixlists

Release NotesRelease Notes

Release Notes

Machine NotesMachine Notes

Machine Notes

Release NewsRelease News

Release News

Product LifecycleProduct Lifecycle

Lifecycle

Media DownloadMedia Download

Media Download

invispix 10x10
Service und SupportService und Support

Service and Support

Informix MonitoringInformix Monitoring

Informix Monitoring

Admin-Scout forInformixAdmin-Scout forInformix

Admin-Scout for Informix

Informix News & InfosInformix News & Infos

Informix News & Infos

This site uses cookies to make it easier for us to provide you with our services. By using our site you agree to the use of cookies.