IBM Books

Package Name


Snapshot Information Level
Application

API Structure(s)
sqlm_appl
sqlm_stmt

Monitor Group
Statement
Statement

Resettable

No

 

Event Information Level
Statement

API Structure(s)
sqlm_stmt_event
sqlm_stmttext_event

 

API Element Name
Element Type

package_name
information

 

Description:  The name of the package that contains the SQL statement currently executing.

Usage:  You may use this element to help identify the application program and the SQL statement that is executing.

If you are using the database system monitor APIs, note that the API constant sqlm_ident_sz is used to define the length of this element. Only the first 8 characters are currently used.

[ Top of Page | Table of Contents | Glossary | Index ]

[ DB2 List of Books | Search the DB2 Books ]