IT20536: ERROR 32504 'REMOTE OPERATION NOT ALLOWED' WHEN DOING A REMOTE QUERY AFTER ANOTHER SESSION CHANGED INDENTITIES

APAR status

• Closed as program error.

Error description

• Error -32504 could be expected in a session if the user changed
  identities using the "set session to '%user%'" statement,
  but there is a possibility that the error would appear in a
  session, even if it has not executed the "set session"
  statement.
  
  If a separate session has changed identities and has not
  terminated properly (e.g: close database), the internal flag
  that indicates an identity change may be left set, which will
  cause the -32504 error in any session reusing that memory block.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Systems where users use the set session authorization in     *
  * their sql code.  When the server re-uses rstcb structures,   *
  * old information might be found which leads to the incorrect  *
  * sql error code.                                              *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See Error Description                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Update to IBM Informix Server 12.10.xC9                      *
  ****************************************************************
  

Problem conclusion

• Problem Fixed In IBM Informix Server 12.10.xC9
  

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

• RC10 PSN

     UP

• RC10 PSY

     UP