JR33179: DB2 CONNECTION ERROR REPORTED ONLY AS WARNING IN DS 7.5.2 CLI0108E COMMMUNICATION LINK FAILURE. SQLSTATE=40003

APAR status

• Closed as program error.

Error description

• DS Job that encounters a DB2 connection issue does not abort as
  message is only a warning. This needs to be a Fatal.
  
  DS Director
  ===========
  Type: Warning
  Message: BTR30VDDSBTM03..CTNProcess.Process: [IBM][CLI Driver]
  SQL30081N  A communication error has been detected.
  Communication protocol being used: "TCP/IP".  Communication API
  being used: "SOCKETS". Location where the error was detected:
  "127.0.0.1". Communication function detecting the error: "send".
  Protocol specific error code(s): "4", "*", "*".  SQLSTATE=08001
  
  Type: Warning
  Message: BTR30VDDSBTM03..Write_STGDB: [IBM][CLI Driver] CLI0108E
  Communication link failure. SQLSTATE=40003
  
  db2diag.log
  ===========
  MESSAGE : DIA5000C A DRDA AS token "AGENT TERMINATING" was
  detected.
  The diagnostic data returned is (SRVDGN): "SQLERRP:SQLJCMN
  SQLCODE:-30081".
  

Local fix

• Set job to abort upon receiving Warning.
  

Problem summary

• ****************************************************************
  USERS AFFECTED:
  752 AIX, DB2API Plugin
  ****************************************************************
  PROBLEM DESCRIPTION:
  DS Job does not abort when the network connection to the DB2
  server is lost in the middle of the job.
  ****************************************************************
  RECOMMENDATION:
  Install the patch: patch_JR33179_DB2_752_AIX.tar.Z
  ****************************************************************
  

Problem conclusion

• Fixed. Now the job will job will abort, when it encounter's
  network error.
  

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

  WIS DATASTAGE

• Fixed component ID

  5724Q36DS

Applicable component levels

• R810 PSN

     UP