IC73766: INSERTING INTO A TEMP TABLE IN AN ANSI DATABASE ON AN HDR SECONDARY GETS SQLCODE 100

APAR status

• Closed as program error.

Error description

• A temp table with no log is created in an ANSI database on a
  session to a HDR secondary. When inserting a row into the temp
  table, the server returns SQLCODE 100 though the row is inserted
  successfully.
  
  The stack trace on the server is as below:
  
  (ix_11.50.FC6/bin/oninit)afstack
  (ix_11.50.FC6/bin/oninit)afhandler
  (ix_11.50.FC6/bin/oninit)affail_interface
  (ix_11.50.FC6/bin/oninit)check_traperror
  (ix_11.50.FC6/bin/oninit)proxyWriteQXfer
  (ix_11.50.FC6/bin/oninit)proxyWritePostCmdSync
  (ix_11.50.FC6/bin/oninit)excommand
  (ix_11.50.FC6/bin/oninit)sq_execute
  (ix_11.50.FC6/bin/oninit)sqmain
  (ix_11.50.FC6/bin/oninit)listen_verify
  (ix_11.50.FC6/bin/oninit)spawn_thread
  (ix_11.50.FC6/bin/oninit)startup
  (ix_11.50.FC6/bin/oninit)coroutine_start
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All users on updatable secondary                             *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * DML operations on temp table incorrectly return error -100   *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Please upgrade to 11.50.xC9 when available                   *
  ****************************************************************
  

Problem conclusion

• Problem is first fixed in 11.50.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

  IBM IDS ENTRP E

• Fixed component ID

  5724L2304

Applicable component levels

• RB15 PSY

     UP