JR57175: INFORMIX ERROR -285 NOT CAPTURED BY DATASTAGE JOB WITH INFORMIXCLI PLUGIN, RESULTING IN JOB HANG SITUATION

APAR status

• Closed as program error.

Error description

• Informix error -285 not captured by DataStage job with
  InformixCLI plugin, resulting in job hang situation
  

Local fix

• N/A
  

Problem summary

• ****************************************************************
  USERS AFFECTED:
  All users of Informix CLI plugin who experience hanged job
  caused by SQL state 24000 and error -285 in Informix.
  ****************************************************************
  PROBLEM DESCRIPTION:
  When Informix CLI returns SQL state 24000 and error -285
  Informixcli Plug-in Stage hangs infinitely.
  The stage should report fatal error instead.
  ****************************************************************
  RECOMMENDATION:
  Install Patch 261270.
  ****************************************************************
  

Problem conclusion

• Handling of the error -285 and SQL State 24000 in question has
  been fixed. Now if the SQL code 24000 with error -285 occurs
  during job execution the message is logged at error level and
  job fails immediately.
  

Temporary fix

• N/a
  

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

  WIS DATASTAGE

• Fixed component ID

  5724Q36DS

Applicable component levels

• RB50 PSY

     UP