IT09446: A PREPARED STATEMENT EXECUTED MANY TIMES IN THE SAME SESSION ON UPDATABLE SECONDARY MAY CAUSE SQSCB->NEXTID OVERFLOW ON PRIMARY.

APAR status

• Closed as program error.

Error description

• You are running a client application via Updatable secondary
  server. The application is heavily using prepared statements.
  Eventually the application hangs and the following messages
  reported in the message log file of the Primary server:
  
    Encountered problem processing update on secondary : Cannot
  call mksdb
    Encountered problem processing update on secondary : Cannot
  call proxyWriteMksdb
    sprollback sqerrno -208 sqiserrno 0
  
  The application works fine if connected directly to the Primary
  instance.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Users of updatable secondary servers using prepared          *
  * statements.                                                  *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See Error Description                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Update to IBM Informix Server 12.10.xC7 when available.      *
  ****************************************************************
  

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