IT12106: WHEN AN ERROR OCCURS IN AN SPL WITH A SELECT, A -285 IS GENERATE D INTERNALLY BY THE SERVER WHICH WILL BLOCK ANY CURSORS FROM BEI

APAR status

• Closed as program error.

Error description

• A Java program prepares and calls an SPL repeatedly.
  
  An exception is raised in the SPL.  As a result of this
  exception, a -285 is generated in the server attempting to close
  a cursor, which you could only detect if you trap for it (onmode
  -I 285)
  
  (oninit) afstack
  (oninit) afhandler
  (oninit) affail_interface
  (oninit) check_traperror
  (oninit) sqerr
  (oninit) close_cursor
  (oninit) sq_close
  (oninit) sqmain
  (oninit) spawn_thread
  (oninit) th_init_initgls
  (oninit) startup
  
  Then if the application attempts to execute the prepared
  statement again, the application will get a -285 attempting to
  Open a Cursor
  
  C->S (92)				Time: 2015-09-24 08:44:07.38726
  	SQ_ID
  		17
  	SQ_CURNAME
  		 "_ifxc000000000000f" [18]
  	SQ_BIND
  		# values: 5
  			0) Type.....: CHAR; NULLABLE
  			Indicator: NOT NULL
  			Precision: 0x0
  			Data.....: "BMMULTIMERY" [11]
  			1) Type.....: DATE; NULLABLE
  			Indicator: NOT NULL
  			Precision: 0x4
  			Data.....: 08/31/2015
  			2) Type.....: CHAR; NULLABLE
  			Indicator: NOT NULL
  			Precision: 0x0
  			Data.....: "A" [1]
  			3) Type.....: CHAR; NULLABLE
  			Indicator: NOT NULL
  			Precision: 0x0
  			Data.....: "K" [1]
  			4) Type.....: CHAR; NULLABLE
  			Indicator: NOT NULL
  			Precision: 0x0
  			Data.....: "" [0]
  	SQ_OPEN
  	SQ_EOT
  
  S->C (14)				Time: 2015-09-24 08:44:07.38727
  	SQ_ERR
  		SQL error..........: -285
  		ISAM/RSAM error....: 0
  		Offset in statement: 45
  		Error message......: "" [0]
  	SQ_EOT
  

Local fix

• On the client side you could prepare the statement again as a
  workaround.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Fetch on cursor returns error and during close of that       *
  * cursor may return 285 error.                                 *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See Error Description                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Update to IBM Informix Server 12.10.xC7                      *
  ****************************************************************
  

Problem conclusion

• Problem Fixed In IBM Informix Server 12.10.xC7
  

Temporary fix

Comments

APAR Information

• 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

• RB70 PSY

     UP

• RC10 PSY

     UP