PI89031: PROCESS REMAINS IN RUNNING STATE WITH DB2 CLOB SIZE ERROR

APAR status

• Closed as program error.

Error description

• When running DB2, with particularly large
  processes (such as those running multiple steps in a For Each
  Agent loop), the process can hang, and a DB2 error can appear in
  the UCD logs:
  
  DB2 SQL Error: SQLCODE=-433, SQLSTATE=22001, SQLERRMC=Lob-Value
  

Local fix

• Simplify or break up your large process into smaller pieces.
  Keep in mind that the trace log may grow linearly with the
  number of loop iterations that occur.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All end users on all supported browsers.                     *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * When running DB2, with particularly large                    *
  * processes (such as those running multiple steps in a For     *
  * Each                                                         *
  * Agent loop), the process can hang, and a DB2 error can       *
  * appear in                                                    *
  * the UCD logs:                                                *
  *                                                              *
  * DB2 SQL Error: SQLCODE=-433, SQLSTATE=22001,                 *
  * SQLERRMC=Lob-Value                                           *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Fixed in version 7.0.1.1                                     *
  ****************************************************************
  

Problem conclusion

• Fix is provided in IBM UrbanCode Deploy 7.0.1.1
  

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

  UC DEPLOY

• Fixed component ID

  5725M5400

Applicable component levels