IV66535: TOOLKIT ISSUE RELATED TO STATEMENT RTERMINATION CHARACTERS

6.1.1-TIV-BSM-FP0004-windows
6.1.1-TIV-BSM-FP0004-zlinux
6.1.1-TIV-BSM-FP0004-solaris
6.1.1-TIV-BSM-FP0004-linux
6.1.1-TIV-BSM-FP0004-aix
6.1.1-TIV-BSM-FP0003-aix
6.1.1-TIV-BSM-FP0003-zlinux
6.1.1-TIV-BSM-FP0003-windows
6.1.1-TIV-BSM-FP0003-solaris
6.1.1-TIV-BSM-FP0003-linux
IBM Tivoli Business Service Manager V6.1.1 Fix Pack 3(6.1.1-TIV-BSM-FP0003)
IBM Tivoli Business Service Manager V6.1.1 Fix Pack 4(6.1.1-TIV-BSM-FP0004)
IBM Tivoli Business Service Manager V6.1.1 Fix Pack 5(6.1.1-TIV-BSM-FP0005)

APAR status

• Closed as program error.

Error description

• We cannot use a different statement termination character as ;
  is used elsewhere. The ; needs to be escaped in the data read
  from TADDM. I am not aware of anyway to do this at the moment
  (except manually) so we need an APAR for the Toolkit for this.
  

Local fix

• workaround provided
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All TBSM Users                                               *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * Bulk load from TADDM into TBSM does not complete when the    *
  * TADDM data inclused ; characters.                            *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  Error seen in TBSM Toolkit toolks:
  com.ibm.tbsm.cltools.jdbc.ASIJDBCConnection executeBatch [2]
  GTMCL5205E: Exception caught. -10 -- Error for batch element
  #18: DB2 SQL Error: SQLCODE=-10, SQLSTATE=42603
  

Problem conclusion

• The fix for this APAR is contained in the following
  maintenance packages:
  |Fix Pack | 6.1.1-TIV-BSM-FP0003
  

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:

Modules/Macros

• UNKNOWN
  

Fix information

• Fixed component name

  TIV BUS SERV MG

• Fixed component ID

  5724C5100

Applicable component levels

• R611 PSY

     UP