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 |
section_number information |
Description: The internal section number in the package for the SQL statement currently processing or most recently processed.
Usage: For static SQL, you can use this element along with "Application Creator" and "Package Name" to query the SYSIBM.SYSSTMT system catalog table and obtain the static SQL statement text, using the sample query as follows:
SELECT SEQNO, TEXT
FROM SYSCAT.STATEMENTS
WHERE PKGNAME = 'package_name' AND
PKGSCHEMA = 'creator' AND
SECTNO = section_number
ORDER BY SEQNO
| Note: | Exercise caution in obtaining static statement text, because this query against the system catalog table could cause lock contentions. Whenever possible, only use this query when there is little other activity against the database. |
[ Top of Page | Table of Contents | Glossary | Index ]