DB2 Version 9.7 for Linux, UNIX, and Windows

creator - Application Creator monitor element

The authorization ID of the user that pre-compiled the application.

Table 1. Snapshot Monitoring Information
Snapshot Level Logical Data Grouping Monitor Switch
Application stmt Statement
DCS Statement dcs_stmt Statement
Table 2. Event Monitoring Information
Event Type Logical Data Grouping Monitor Switch
Deadlocks event_dlconn -
Statements event_stmt -
Activities event_activitystmt -
Usage
Use this element to help identify the SQL statement that is processing, in conjunction with the CREATOR column of the package section information in the catalogs.

If the CURRENT PACKAGE PATH special register is set, the creator value may reflect different values over the lifetime of the SQL statement. If a snapshot or event monitor record is taken before PACKAGE PATH resolution, the creator value will reflect the value flowed in from the client request. If a snapshot or event monitor record is taken after PACKAGE PATH resolution, the creator value will reflect the creator of the resolved package. The resolved package will be the package whose creator value appears earliest in the CURRENT PACKAGE PATH SPECIAL REGISTER and whose package name and unique ID matches that of the client request.