IV71255: SELECT STATEMENTS USED FOR LOGGING PURPOSES IN DB-CLEANUP.SQL SCRIPT NEED TO BE COMMENTED OUT.

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

• SELECT statements used for logging purposes in db-cleanup.sql
  script need to be commented out. One of this SELECT statements
  was taking too long and failed on a customer system.
  

Local fix

• Comment out the SELECT statement.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All TBSM 611 Users                                           *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * The db-cleanup.sql script was hanging at a select statement  *
  * in the script which is only used for logging.                *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  The db-cleanup.sql script was hanging at a select statement in
  the script which is only used for logging.
  

Problem conclusion

• The fix is split up the script into 2 - one for select
  statements for logging and one for statements that do the
  cleanup.
  The Fix for this APAR is contained in the following maintenance
  package:
  | 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:

Fix information

• Fixed component name

  TIV BUS SERV MG

• Fixed component ID

  5724C5100

Applicable component levels

• R611 PSY

     UP