LI74685: ACTION SCRIPT DOES NOT WORK PROPERLY IF USING TERM CHAR ;(SEMI-COLON).

DB2 Version 9.5 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 6a for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 10 for Linux, UNIX, and Windows

APAR status

• Closed as program error.

Error description

• Specified action script with term char ; will fail.
  
  If you execute journal, you can see the sqlcode
  "-22220" error.
  
  For example)
  The health monitor failed, with sqlcode "-22220", to initiate
  an alert action, running "script" "C:\tmp\test.sql" on
  system "YOUR_COMPUTER_NAME",
  when the Health Indicator "Log Filesyetem Utilization"
  ("db.log_fs_util")
  went into the "Alerm" alert state on "database" "sample".
  

Local fix

• db2set db2options= "-t"
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Can not execute action script.                               *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See the APAR description.                                    *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrde to DB2 UDB version 9.5 fixpack 5.                     *
  ****************************************************************
  

Problem conclusion

• Problem was first fixed in DB2 UDB Version 9.5 FixPack 5.
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

  LI74241

• APAR is sysrouted TO one or more of the following:

Fix information

• Fixed component name

  DB2 UDB WSE LIN

• Fixed component ID

  5765F3504

Applicable component levels

• R950 PSN

     UP