IT25389: PREP_TIME = -1 IN EVENT MONITOR FOR ACTIVITIES WHEN CALLING STORED PROCEDURES

Db2 Version 11.1 Mod4 Fix Pack4 iFix001 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod 4 Fix Pack 4 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod 4 Fix Pack 6 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod 4 Fix Pack 5 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod 4 Fix Pack 7 for Linux, UNIX, and Windows

APAR status

• Closed as program error.

Error description

• Using a DB2 Event Monitor for Activities to monitor SQL
  statements, the
  ACTIVITY table logs the PREP_TIME but the PREP_TIME is -1 when a
  call to
  a stored procedures is made. The doc says that PREP_TIME should
  be a value
  in milliseconds or 0 for non-SQL statements:
  
   prep_time - Preparation time monitor element
  
   "Time in milliseconds required to convert an SQL statement from
  text
    form to an executable form (if the activity is an SQL
  statement;
    otherwise, the value is 0)."
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * ALL                                                          *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See Error Description                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to Db2 11.1.4.4 or higher                            *
  ****************************************************************
  

Problem conclusion

• Upgrade to Db2 11.1.4.4 or higher
  

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

  DB2 FOR LUW

• Fixed component ID

  DB2FORLUW

Applicable component levels

• RB10 PSN

     UP